Click here to schedule your class

Classes are taught using excel 2003 but excel 2007 will be reviewed each day as well.

Become a Microsoft Certified Office Specialist/Expert-Office Specialists/Expert certified individuals report increased competence, and productivity with Microsoft Office programs as well as increased credibility with their employers, co-workers, clients, and higher pay.

Our Excel Classes levels 1-4 not only teach you all the important functionality of each of these programs, but also prepare you for the certification in Excel 2003, for both the Specialist and Expert levels.

Days 1 & 2 Excel Level 1 & 2 - Specialist

Day 1 - Level 1 MOS Specialist
Lesson: 1 Navigating in Excel and Understanding the Interface
Understanding Excel’s Interface
Investigating the Default Bars at the Top of Your Screen
Task Pane
Workbook Components
Worksheet Components
Navigating in Excel
Moving Around in Workbooks
Moving Around in Worksheets
Adding and Editing Data in a Workbook
Managing Data in Cells
Managing Cells
Managing Rows and Columns
Organizing Worksheets
Saving and Managing Workbooks
Moving and Copying Data
Copy and Paste
Cut and Paste
Selecting Contiguous and Noncontiguous Ranges
Using the Office Clipboard
Using the Mouse to Drag and Drop or Fill Data

Lesson: 2 Formats, Graphics, and Excel’s Templates
Using the Format Cells Dialog Box and the Formatting Toolbar
Font Formatting
Using the Different Cell Formats
Cell Alignment
Applying Cell Borders and Patterns
Formatting Shortcuts
Creating and Modifying Styles
The Format Painter
Formatting Worksheets
Using AutoFormats
Formatting Backgrounds
Excel and Graphics
Understanding the Drawing Toolbar
Adding and Editing Graphics in a Worksheet
Adding and Editing Diagrams and Organizati
Charts in a Worksheet
Creating and Modifying Charts
Using the Chart Wizard
Using the Chart Toolbar
Customizing Charts
Editing the Data Used to Produce Charts
Combination Charts
Using Excel’s Templates
Understanding Templates
Adding Data Using Templates

Lesson: 3 Organizing Data, Changing Views, and Printing
Organizing Data
Sorting Data, Based on Single and Multiple Columns
Using AutoFilters
Working with Views
Freezing Panes and Splitting Worksheets
Using Multiple Windows to View and Edit Data
Creating Workspaces
Understanding Custom Views
Controlling Page Layout
Orienting a Page and Repeating Rows and Columns
Adding Headers and Footers
Setting Margins
Managing Page Breaks
Printing
Printing Selections
Printing Multiple Copies and Specific Pages

Day 2 Level 2 MOS Specialist
Lesson: 4 Editing Tools, Comments, and Hyperlinks
Using Excel’s Editing Tools
Using the Spelling Tool
Using AutoCorrect
Using Find And Replace
Using Automated Features to Maintain Accuracy
Consistency
Using the Research Pane
Converting Text to Columns
Comments and Hyperlinks
Working with Comments
Hyperlinks in Excel

Lesson: 5 Formulas and Functions in Excel
Creating Basic Arithmetic Formulas
Simple Arithmetic Using Operators
Simple Addition Using the SUM Function
Working with Statistical Functions
Entering Statistical Functions Directly into Cells
Using the Insert Function Utility
Working with Date and Time Functions
Date and Time Formats in Formulas
Calculating Dates and Times
Working with Financial Functions
Using the PMT Function
Using the FV Function
Working with Logical Functions
The IF Statement
More Logical Functions
Adding Multiple Nested Conditions and Multi
Return Values in IF Statements
Printing Formulas

Lesson: 6 Advanced Functions, Table Arrays, and Database
Understanding Cell References
Using Named Ranges, Cells, and Constants
Named Ranges
Naming Cells as Bookmarks
Naming Constant Values
Using Lookup and Reference Functions
The Lookup Functions
The Reference Functions
Using Database Functions and Features
Excel’s Database Features
The Database Functions
More Functions
Text Functions
Math & Trig Functions
Information Functions
Array-Entered Formulas
Constructing Array-Entered Formulas
Using Array-Entered Formulas

DAY 3 & 4 Excel Level 3 & 4 - Expert

Day 3 - Level 3 MOS Specialist
Lesson: 7 Advanced Data Organization and Display
Summarizing Data
Using Outlining When Data Is Already Subtotaled
Creating Subtotals and Outlines at the Same Time
Consolidating Data
Linking Data
Creating Simple Links to External Data
Using Linked Data in Formulas
Dealing with Broken Links
Using Pivotal Reports
Manipulating Data Layout with a PivotTable Report
Producing a Pivot Chart
Using Advanced Formatting Techniques
Controlling Data Display with Custom Formats
Controlling Data Display Using Conditional Formatting

Lesson: 8 Data Analysis and Sharing Workbooks
Troubleshooting Formula Errors
Locating Formula Errors
Evaluating and Correcting Formula Errors
Understanding What-If Analysis
Using Goal Seek and Trendlines
Using Scenarios to Compare Predictions
Excel’s Add-Ins
Sharing Data
Creating a Shared Workbook
Using a Shared Workbook

Lesson: 9 Advanced Template Design and Workbooks
Security
Designing Templates
Understanding Templates and How They Work
Editing Existing Templates
Creating Your Own Templates
Organizing Your Templates
Workbook Security and Protection
The Importance of Workbook Properties
Worksheet and Workbook Protection
File Protection
Macro Security

Day 4-Level 4 MOS Specialist
Lesson: 10 Data In and Data Out
Introduction to Converters
Data In
Opening Different File Types in Excel
Bringing Data into Excel Using Alternative Methods
Data Out
Moving and Copying Data Out of a Worksheet
Saving and Editing Excel Files in Different Formats
Importing and Inserting Excel Worksheets into Ot
File Types
Saving Workbook Structure Using XML
Summary

Lesson: 11 Working with Macros
Working with Macros in One Workbook
Recording New Macros
Editing Macros
Copying Macros
Assigning Macros to Command Buttons
Working with Macros in All Workbooks
Creating a Personal Macro Workbook to St
Global Macros
Assigning Macros to Toolbars and Menus

Lesson: 12 Customizing Excel and Setting Defaults
Customizing Toolbars and Menus
Setting Toolbar and Menu Options
Creating New Toolbars and Adding Buttons
Editing Toolbar Buttons and Menu Items
Working with Excel’s Options Dialog Box
Excel’s View Options
Excel’s Calculation Options
Excel’s Edit Options
Excel’s General Options
Excel’s Transition Options
Excel’s Chart Options
Excel’s Color Options
Excel’s International Options
Excel’s Save Options
Excel’s Error Checking Options
Excel’s Spelling Options
Excel’s Security Options