Microsoft Excel 2007 – Beginning (6-8 hours)
- Spreadsheet Basics
- Excel Basics (Screen, Menu)
- Navigating Within a Worksheet
- Changing the View
- Using Help
- Entering, Editing, Deleting & Undeleting Data
- Working with Blocks
- Adjusting Column Widths & Row Height
- Creating & Filling Formulas
- Entering Natural Language Formulas
- Auto Fill
- Using the Spell Checker
- Saving, Opening & Printing Workbooks
- Setting Print Options
- Copying & Moving (Drag & Drop)
- The Office Clipboard
- Formatting (Alignment, Attributes, Borders)
- Inserting & Deleting Rows/Columns
- Using Built-In Functions
- Customizing Cell Formats
- Cell Styles
- The Format Painter
- Working with Charts
- Absolute Addressing
- Document Recovery
- Using & Creating Templates
Microsoft Excel 2007 – Intermediate (6-8 hours)
- Find/Replace
- Using Block Names
- Working With Dates
- Advanced Functions
- Creating a Database
- Sorting Records
- AutoFilter & Custom Filters
- Working with Tables
- Working with Macros
- Creating an Array Formula
- Linking Files
- Creating a Workspace
- Protecting Blocks/Worksheets
- Freezing Panes
- Splitting the Screen
- Hiding Columns/Blocks
- Multiple Worksheets & Tabs
- Working with Chart Sheets
- Hyperlinks
- Sharing Workbooks
- Tracking Changes
- Adding Cell Comments
- Conditional Formatting
- Formatting Shortcuts
- Custom Formats
Microsoft Excel 2007 – Advanced (6-8 hours)
- Creating Outlines
- Pivot Tables & Pivot Charts
- Advanced Chart Options
- Adding Clipart, Graphic Files, AutoShapes
- Adding Word Art
- Using the Goal Seeker
- Creating Scenarios
- Adding an Outlook Task
- Consolidating Data
- Importing & Exporting
- Customizing the Toolbar
- Working with Styles
- Custom Views
- File Properties
- Setting Program Options
- Sending Workbooks
- Creating Web Pages