Technical training, computer training, and Real Estate training

Workforce and Community Services

Corporate Training
Microsoft Excel 2003 Training Content

[ Popular Programs and Services ]   [ Meet our Corporate Training Team ]
[ Satisfied Clients ]   [ Benefits ]   [ Contact Us ]   [ Post A Job Opening ]

Introductory Topics

Unit 1: Getting started
Topic A: Spreadsheet terminology
Topic B: Exploring the Excel window
Topic C: Getting help
Topic D: Opening and navigating workbooks
Topic E: Closing workbooks

Unit 2: Entering and editing data
Topic A: Creating workbooks
Topic B: Entering and editing labels and values
Topic C: Entering and editing formulas
Topic D: Saving and updating workbooks

Unit 3: Modifying a worksheet
Topic A: Moving and copying data
Topic B: Moving and copying formulas
Topic C: Using absolute references
Topic D: Inserting and deleting ranges

Unit 4: Using functions
Topic A: Entering functions
Topic B: Using AutoSum
Topic C: Using AVERAGE, MIN, and MAX

Unit 5: Formatting worksheets
Topic A: Formatting text
Topic B: Formatting rows and columns
Topic C: Number formatting
Topic D: Using Format Painter and AutoFormat

Unit 6: Printing
Topic A: Preparing to print
Topic B: Page Setup options
Topic C: Printing worksheets

Unit 7: Creating charts
Topic A: Chart basics
Topic B: Modifying charts
Topic C: Printing charts

Unit 8: Web features
Topic A: Saving workbooks as Web pages
Topic B: Hyperlinks
Topic C: Sending workbooks via e-mail

Intermediate Topics

Unit 1: Working with large worksheets
Topic A: Viewing options
Topic B: Hiding, displaying, and outlining data
Topic C: Printing large worksheets

Unit 2: Using multiple worksheets and workbooks
Topic A: Using multiple worksheets
Topic B: Linking worksheets by using 3-D formulas
Topic C: Consolidating data
Topic D: Linking workbooks
Topic E: Managing workbooks

Unit 3: Customizing Excel
Topic A: Using the Options dialog box
Topic B: Customizing toolbars and menus

Unit 4: Advanced formatting
Topic A: Borders and shading
Topic B: Using special number formats
Topic C: Working with dates
Topic D: Working with styles
Topic E: Other advanced formatting

Unit 5: List management
Topic A: Examining lists
Topic B: Sorting and filtering lists
Topic C: Advanced filtering

Unit 6: Advanced charting
Topic A: Chart formatting options
Topic B: Using combination charts
Topic C: Using graphic elements

Unit 7: Documenting and auditing
Topic A: Auditing features
Topic B: Comments and text boxes
Topic C: Protection
Topic D: Workgroup collaboration

Unit 8: Using templates
Topic A: Built-in templates
Topic B: Creating and managing templates


Advanced Topics

Unit 1: Working with advanced formulas
Topic A: Using names
Topic B: Using decision-making functions
Topic C: Creating nested functions
Topic D: Using financial functions

Unit 2: Lookups and data tables
Topic A: Working with lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Unit 3: Advanced list management
Topic A: Creating subtotals
Topic B: Validating cell entries
Topic C: Exploring database functions
Topic D: Working with data forms

Unit 4: Working with PivotTables and PivotCharts
Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: Working with PivotCharts

Unit 5: Exporting and importing
Topic A: Exporting and importing text files
Topic B: Exporting and importing XML data
Topic C: Querying external databases

Unit 6: Using analytical options
Topic A: Working with Goal Seek and Solver
Topic B: Working with the Analysis ToolPak
Topic C: Working with scenarios
Topic D: Working with views

Unit 7: Working with macros
Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Function procedures

Unit 8: Interactive Web pages
Topic A: Creating interactive Web spreadsheets
Topic B: Publishing PivotTables on the Web

Unit 9: Using SharePoint services
Topic A: Document Workspaces


Power User Topics

Unit 1: Advanced formulas, functions, and arrays
Topic A: Text functions
Topic B: Information functions
Topic C: Array formulas
Topic D: Labels

Unit 2: Advanced editing and formatting
Topic A: The Paste Special command
Topic B: The Go To Special dialog box
Topic C: Advanced formatting features

Unit 3: Advanced graphics
Topic A: Creating a custom chart
Topic B: Working with pictures

Unit 4: Analyzing and sharing information
Topic A: Using add-ins
Topic B: Solver models and reports
Topic C: Statistical analysis tools
Topic D: Embedding and linking

Unit 5: Advanced customization
Topic A: Custom lists
Topic B: Changing default settings
Topic C: Automating Excel


Start your success today by calling (567) 661-7319.

Visit us on Facebook!

CPR and First Aid training classesWorkforce course catalog