Excel Outlines
Excel Introduction Excel Intermediate Excel Advanced
Classes are available in Microsoft Office 97, 2000, 2002,
2003, and 2007.
Lesson 1: Excel basics
- The paper spreadsheet
- The Excel program
- The workbook environment
Lesson 2: Entering data and navigating in a worksheet
- Entering and correcting data
- Saving a file
- Using formulas
- Opening a second file
- Navigation and movement techniques
Lesson 3: Modifying a workbook
- Working with ranges
- Working with functions
- Editing cell contents
Lesson 4: Moving and copying data
- Inserting rows and ranges
- Moving data
- Copying data
- Absolute references
- Using the Fill Series feature
Lesson 5: Formatting a worksheet
- Formatting a worksheet
- Number formats and text alignment
- Copying and pasting formats
- Special and custom formatting
Lesson 6: Printing a worksheet
- Checking spelling
- Using the Print Preview command
- Printing a large worksheet
- Additional print options
Lesson 7: Introduction to the workbook environment
- Using a multiple-sheet workbook
- Creating a chart
- Outlining
- Spreadsheet solutions
Lesson 8: Creating Excel Web pages
- Using Excel as a Web tool
Lesson 1: Creating Charts
- Creating a Chart Sheet
- Creating an Embedded Chart
- Comparing Chart Sheets with Embedded Charts
Lesson 2: Modifying Charts
- Chart Types
- Modifying Embedded Charts
- Adding and Deleting Chart Items
- Moving and Sizing Chart Items
Lesson 3: Formatting a Chart
- Formatting Chart Text
- Formatting Labels
- Formatting the Chart
- Printing a Chart Sheet
Lesson 4: Using Graphic Objects
- Adding Graphic Objects
- Formatting Graphic Objects
- Using Graphic Objects to Enhance Worksheets and Charts
Lesson 5: Sorting Data
- Single-level Sorting
- Multiple-level Sorting
- Sorting Options
- Importing Data
- Design Considerations
Lesson 6: Filtering Data
- Filtering a List
- Custom Criteria
- Multiple-condition Criteria
- Managing a Filtered List
Appendix A: Additional Topics
- Database Functions
- Excel Web Pages and the Internet or an Intranet
Lesson 1: Customizing the Work Area
- Working with Built-in Toolbars
- Using Custom Toolbars
- Creating and Using Styles
- Using Templates
Lesson 2: Advanced Formula Construction
- Using Names
- Using the IF Function
- Using the VLOOKUP Function
- Using IS Functions and the Auditing Features
Lesson 3: Using Pivot Tables
- Creating Pivot Tables
- Modifying Pivot Tables
- Grouping and Summarizing Data in a Pivot Table
- Creating Interactive Pivot Tables for the Web
Lesson 4: Working with Multiple Worksheets
- Working with Workbooks
- Linking Cells in Different Workbooks
- Workbook Versus Links and Workspaces
- Sharing and Merging Workbooks
Lesson 5: Consolidating and Analyzing Data
- Consolidating Data from More Than One Worksheet
- Using the Goal Seek and Solver Utilities
- Using Scenario Manager to View a Worksheet with Different
Input Values
Lesson 6: Using Protection and Display Options
- Using Comments
- Protecting Workbooks
- Using Custom Views
Lesson 7: Introduction to Macros
- Running Macros
- Recording a Macro
- Viewing and Editing VBA Code
Lesson 8: Working with Interactive Excel Web Documents
- Saving Excel Worksheets as Web Documents
- Spreadsheet Web Components
|
