| Excel 97 |
|
| Module 2 (Advanced) Course Outline |
|
More Functions and Formulas
Formulas with Several Operators and CellRanges
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 and the Internet
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
Adding Hyperlinks to a Worksheet
Browsing Hyperlinks and using the Web Toolbar
Converting a Excel File to a Web Page
Data Analysis and PivotTables
Creating a PivotTable
Modifying a PivotTable's Structure
Adding a Page Field to a PivotTable
Grouping Dates in a PivotTable
Updating 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
Adding, Positioning, and Removing 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
|
|
|
|