Session 1: Using Named Ranges
Adding and Selecting a Named Range
Naming a Single Cell
Using Column and Row Labels to Name a Range
Inserting a Row in a Named Range
Using a Named Range in a Formula
Deleting a Named Range
Revising a Formula
Listing Named Ranges in a Workbook
Session 2: Using and Creating Templates
Create a Workbook Using a Template
Edit, Create, and Apply Templates
Managing Workbooks and Folders
Create Workspaces
Customize Toolbars and Menus
Enter Dates and Apply Date Formats
Session 3: Outlining, Grouping, Consolidating, and Analyzing Data
Grouping and Outlining
Using Auto Outlining
Session 4: Consolidating Data from Multiple Workbooks
Creating a Link to Source Data
3D References
PivotTables and PivotCharts
What-if Analysis
Creating Scenarios
Data Validation
Session 5: Importing, Exporting, and Sharing Data
Import Data from External Sources
Running Web Queries
Using XML with Excel
Export to Other Applications
Apply File Passwords
Share Workbooks
Protecting Worksheets and Cells
Track Changes
Session 6: Working with Lists
Arrange Data in a List
Use Data Forms
Sort Data Topic
Apply Data Filters
Use Subtotaling
|
|
