Excel 2003 Intermediate

Raising the Bar
Sydney, NSW, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' FORMATTING CELLS USING MENU OPTIONS
Formatting Cells Using Menu Options
How To Double Underline Using Menu Option
How To Align Vertically
How To Change Text Orientation
How To Wrap Text In A Cell
How To Format Numbers
How To Format Date
How To Change Cell Background Colour
How To Add Outline Border
How To Add Double Line Border
How To Format Table Using AutoFormat

WORKING WITH ADVANCED FORMATTING, STYLE AND OUTLINING
Customising Data Appearance With Advance Formatting
How To Use Build-In Number Formats
How To Custom Number Format
How To Custom Date Format

Using Conditional Formatting
How To Use Conditional Formatting

Maintaining Format Consistency With Styles
How To Add Style Box Tool To The Toolbar
How To Create New Style
How To Apply Styles
How To Redefine Style
How To Delete Style
How To Merge Style From Another Workbook

Using Data Outlining
How To Create An Outline Automatically
How To Remove Outline
How To Create Outline Manually
How To Use Subtotal To Create Outline
How To Show / Hide Details Using Outline Symbols
How To Remove Subtotal

MANAGING WORKBOOK INFORMATION
Managing Workbook Information
How To Rename Worksheet
How To Add New Worksheet
How To Rearrange Worksheet
How To Copy Worksheet
How To Hide And Unhide Worksheet
How To Hide And Unhide Workbook
How To Format Worksheet Tab

WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
Managing Data in Multiple Worksheets
How To Select Adjacent Worksheets
How To Select Non-Adjacent Worksheets
How To Enter Data Into Multiple Worksheets
Using 3-D Formula Across Worksheets
How To Enter 3-D Formula Across Worksheets
How To Enter 3-D Formula Across Worksheets Using Function

Linking Information From Different Worksheets And Workbook
How To Link Information Using Copy And Paste Link
How To Update Link

IMPORTING AND EXPORTING DATA
Importing / Exporting Data
How To Use Text Import Wizard
How To Export Data To A Document
How To Copy Data From Other Applications
How To Insert Objects
How To Export Data To Excel Workbook In Other Application
Retrieving Data From A Database

How To Get Specific Information Using Database Query
How To Edit Database Query

FORMATTING CHARTS
Formatting a Chart
How To Change Font Format
How To Change Text Orientation
How To Change Object Color
How To Change The Order Of Data Series
How To Use Combination Of Chart Type
How To Create A Pie Chart
How To Use 3-D View To Rotate Chart
How To Explode A Wedge In Pie Chart
How To Create A Picture Chart

WORKING WITH COMMENTS
Using Comments
How To Add A Comment Into A Cell
How To Show Comments
How To Show/Hide Comment Indicators
How To Edit And Delete Comments

PROTECTING WORKSHEET STYLE, CONTENTS AND ELEMENTS
How To Protect The Worksheet
How To Unprotect The Worksheet
How To Unlock Cell For Editing In Protected Sheet
How To Hide Cell Formula In Protected Sheet
How To Set Password To Edit Specific Range
How To Grant Selected Users Edit Range Without Password

Protecting Workbook Contents
How To Protect The Workbook Structure
How To Unprotect The Workbook Structure
Protecting Your Workbook From Unauthorised Users Access
How To Set Password To Open
How To Remove Password To Open
How To Set Password To Modify CREATING

CREATING POWERFUL DATABASES
Creating A Database
How To Create Database Field
How To Add Records Manually
How To Add New Record Using A Built-In Data Form

Managing Record in Database
How To Search For The Record Using Data Form
How To Edit / Delete The Record Using Data Form
How To Create A List
How To Find Total In A List
How To Switch Functions In A List
How To Convert A List To A Range

Sorting Records
How To Perform Simple Sort
How To Perform Multiple Sort
How To Set Advanced Sort Options

Using AutoFilter
How To Enable / Disable AutoFilter
How To Apply / Remove The Criteria
How To Customise Criteria
How To Use Wildcard In Criteria

Using Advance Filter
How To Define The Criteria Range
How To Use The Advanced Filter Command
...''

Phone:(02) 9929-8845

School Address:

Suite 501, Level 5
65 Walker St
North Sydney NSW 2060


Jobs & Resumes: Sydney
Houses & Roommates: Sydney
Travel Agencies: Sydney

Search other schools for Excel 2003 Intermediate training resources.

Access 2003 VBA Basic
Access 2003 Basic
Access 2003 Intermediate
Access 2003 Advanced
Excel 2003 VBA Basic
Excel 2003 Advanced
Excel 2003 Basic
Outlook 2003 Basic
Outlook 2003 Advanced
Powerpoint 2003 Advanced
Powerpoint 2003 Basic
Project 2003 Advanced
Project 2003 Basic
Word 2003 Advanced

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.