SitesPower Training Center - PO Box 13801 Dubai, UAE
SitesPower Training Institute | Dubai : +9714-335-5549 | Sharjah Institute : +9716-575-1315 | معهد تدريب سايتس باور

Enquire About Course

Training Programs | Course Schedule

Printing Instructions

Microsoft Excel 2003 - Levels 1-3
1 day Instructor-Led Course per Level (8 hours per level)

Previous Software Versions: MS Office XP, 2002, 2000

Level 1 Course Outline:

Introduction to Microsoft Excel 2003
What is Excel?
Excel File Types
Excel Environment
Toolbars
Office Assistant
Review Questions

Workbooks and Worksheets
Creating and Opening Workbooks
Working with Workbooks
Working with Worksheets
Working with Cells
Navigating within a Worksheet
Navigating the Workbook
Review Questions

Spreadsheet Data
Entering Data
Using Time Saving Features
Checking the Spelling
Review Questions

Formatting and Customising Data
Selecting Items in Excel
Formatting Text
Formatting Numbers
Manipulating Data
Formatting Columns and Rows
Formatting with Colours and Patterns
Adding and Editing Borders
Using AutoFormat
Review Questions

Editing Spreadsheets
Cutting, Copying, and Pasting
Inserting and Deleting
Using Find and Replace
Using Undo and Redo
Review Questions

Formulas and Functions
Entering Formulas
Entering Functions
Using Named Cells and Ranges in Formulas
Review Questions

Printing
Using Page Setup
Margins
Headers and Footers
Printing a Spreadsheet
Review Questions

Level 2 Course Outline:

Viewing Worksheets
Customising View Options
Displaying and Customising Toolbars
Hiding Workbooks and Worksheets
Freezing Panes
Grouping and Ungrouping Worksheets
Review Questions

More Formatting Techniques
Using Styles
Conditional Formatting
Using the Format Painter
Using Guidelines
Hiding and Displaying Cells
Review Questions

More Formulas and Functions
Using the Series Command
Using the Insert Function Wizard
Using the Excel Function Categories
Correcting Formulas
Using the Formula Error Checker
Using the Formula Auditing Toolbar
Using the Watch Window
Review Questions

Database and List Management
Using Databases
Creating and Editing a Database
Sorting a Database
Using AutoFilters
Advanced Filters
Working with Filtered Data
Using Data Forms
Review Questions

Charts
Chart Wizard
Chart Toolbar
Working with Charts
Formatting the Chart
Review Questions

Drawing and Picture Objects
Drawing Toolbar
Working with AutoShapes
Creating Text Boxes
Adding Pictures
Layering Objects
Grouping and Ungrouping Objects

Excel 2003 and Other Applications
Converting Files from Other Applications
Copying Data from another Application
Embedding and Linking Objects
Hyperlinks
Managing Links

Level 3 Course Outline:

Importing Data
Importing Data from External Sources
Importing Text Files
Using Microsoft Query
Querying Data from the Web
Refreshing Data
Review Questions

Templates and Styles
Working with Templates
Working with Styles
Review Questions

Analysing Data
What-If Analysis
Goal Seek
Data Tables
Scenario Manager
Solver
Using Pivot Tables
Review Questions

Macros and Custom Controls
Working with Macros
Running Macros
Adding Custom Controls
Review Questions

Security and Proofing
Security Features
Protecting Excel Files
Worksheet Protection
Working with Digital Signatures
Checking Spelling
Using Data Validation
Using Text To Speech
Documentation
Review Questions

Customising Excel 2003
Configuring Excel 2003 Options
Customising the Excel Environment
Working with Workspaces
Review Questions

Collaboration and Consolidation
Sharing Workbooks
Sending Workbooks
Consolidation
Review Questions