| Excel 2002 (XP) |
|
| Module 2 (Advanced) Course Outline |
|
More Functions and Formulas
Formulas with Several Operators and Cell Ranges
Using the Formula Palette to Enter and Edit Formulas
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 Errors in Your Formulas
Mathematical Functions (Reference)
Financial Functions (Reference)
Date and Time Functions (Reference)
Statistical Functions (Reference)
Database Functions (Reference)
Working with Lists
Creating a List
Using the Data Form to Add Records
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
Automating Tasks with Macros
Recording a Macro
Playing a Macro and Assigning a Macro a Shortcut Key
Adding a Macro to a Toolbar
Editing a Macro's Visual Basic Code
Inserting Code in an Existing Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If…Then…Else Statement
Working with Other Programs
Inserting an Excel Worksheet into a Word Document
Modifying an Inserted Excel Worksheet
Inserting a Linked Excel Chart in a Word Document
Inserting a Graphic into a Worksheet
Opening and Saving Files in Different Formats
Using Excel with the Internet
Adding Hyperlinks to a Worksheet
Browsing Hyperlinks and using the Web Toolbar
Saving a Workbook as a Non-Interactive Web Page
Saving a Workbook as an Interactive Web Page
Using Queries to Retrieve Information from the Web
Data Analysis and PivotTables
Creating a PivotTable
Specifying the Data a PivotTable Analyzes
Modifying a PivotTable's Structure
Selecting What Appears in a PivotTable
Grouping Dates in a PivotTable
Updating a PivotTable
Formatting and Charting a PivotTable
Creating Subtotals
Using Database Functions
Using Lookup Functions
Grouping and Outlining a Worksheet
What-If Analysis
Defining a Scenario
Creating a Scenario Summery Report
Using a One and Two-Input Data Table
Understanding Goal Seek
Using Solver
Advanced Topics
Hiding, Displaying, and Moving Toolbars
Creating and Using Custom Toolbars
Creating a Custom AutoFill List
Changing Excel's Options
Password Protecting a Workbook
File Properties and Finding a File
Sharing a Workbook and Tracking Changes
Merging and Revising a Shared Workbook
Using Detect and Repair
|
|
|
|