Microsoft Excel 2003 Level 2
| Duration: | 1 day |
| Prerequisite: | Excel Introduction or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises, 160 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the intermediate concepts of Microsoft Excel 2003 with managing workbooks, automating tasks, using and analyzing list data, enhancing charts and worksheets, and working with Excel and the Internet. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Managing Workbooks
Switching Between Sheets in a Workbook
Inserting and Deleting Worksheets
Renaming and Moving Worksheets
Working with Several Workbooks and Windows
Splitting and Freezing a Window
Referencing External Data
Creating Headers, Footers, and Page Numbers
Specifying a Print Area and Controlling Page Breaks
Adjusting Page Margins and Orientation
Adding Print Titles and Gridlines
Changing the Paper Size and Print Scale
Protecting a Worksheet
Hiding Columns, Rows, and Sheets
Viewing a Worksheet and Comparing Workbooks Side by Side
Saving a Custom View
Working with Templates
Consolidating Worksheets
Review
Student Exercises
More Functions and Formulas
Formulas with Several Operators and Cell Ranges
Using the Insert Function Feature
Creating and Using Range Names
Selecting Nonadjacent Ranges and Using AutoCalculate
Using the IF Function to Create Conditional Formulas
Using the PMT Function
Displaying and Printing Formulas
Fixing Formula Errors
Mathematical Functions
Financial Functions
Date and Time Functions
Statistical Functions
Database Functions
Review
Student Exercises
Working with Lists
Creating a List
Working with Lists and Using the Total Row
Adding Records Using the Data Form Dialog Box and Insert Row
Finding Records
Deleting Records
Sorting a List
Filtering a List with the AutoFilter
Creating a Custom AutoFilter
Filtering a List with an Advanced Filter
Copying Filtered Records
Using Data Validation
Review
Student Exercises
Automating Tasks with Macros
Recording a Macro
Playing a Macro and Assigning a Macro a Shortcut Key
Adding a Macro to a Menu
Adding a Macro to a Toolbar
Review
Student Exercises