|
ADVANCED FEATURES
|
Customize Menus
|
The Menu Bar
|
|
Creating Custom Menus
|
Customize Toolbars
|
Toolbars
|
|
Customize a Toolbar
|
Create a New Toolbar
|
CALCULATE YOUR DATA
|
|
Work With Named Ranges
|
Using Named Ranges
|
Range Naming Rules
|
|
Range Names Using Labels
|
Define Range Names for Data
|
Without Labels
|
|
Named Range in a Formula
|
Viewing Named Ranges In A
|
Worksheet
|
|
Use Subtotals
|
Add Subtotals to a Worksheet
|
Use Lookup Functions
|
|
What Is A Lookup Function?
|
The VLOOKUP Function
|
Use the VLOOKUP Function
|
|
Find & Correct Errors
|
Auditing Worksheets
|
Precedents & Dependents
|
|
Trace Errors
|
Use Data Validation
|
Circle Invalid Data
|
|
MANAGE & ANALYZE DATA
|
Create & Filter Lists
|
What Is A List?
|
|
Use a Data Form
|
Use the List Feature
|
AutoFilter
|
|
Sort List Data
|
Sort Data
|
Subtotal Columns
|
|
Outline a Worksheet
|
Using Outlines30
|
Add & Remove an Outline
|
|
Outline a Worksheet Manually
|
Query External Databases
|
Use the Query Wizard
|
|
XML Documents
|
What Is XML?
|
Save a Workbook as an XML
|
|
Document
|
Goal Seek & Solver
|
Use Goal Seek
|
|
Use Solver
|
Scenarios
|
What Is A Scenario?
|
|
Create & View Scenarios
|
Link & Consolidate Data
|
Data Consolidation
|
|
Consolidate Data
|
Link Consolidated Data
|
Consolidate Data
|
|
Workbooks
|
PivotTables & Pivot Charts
|
PivotTables & Pivot Charts
|
|
Create a PivotTable
|
Modifying a PivotTable
|
Create a PivotChart
|
|
FORMAT a WORKSHEET
|
Conditional Formatting
|
Conditional Formatting
|
|
Use Conditional Formatting
|
Styles
|
What Is A Style?
|
|
Create & Apply a Style
|
USE MACROS
|
Create Macros
|
|
What Is A Macro?
|
Record a Macro
|
Absolute vs. Relative
|
|
Work With Macros
|
Assign a Macro
|
Edit a Macro
|
|
“Step Into” A Macro
|
Macro Security
|
RKBOOKS
|
|
Link & Consolidate Data
|
Data Consolidation
|
Consolidate Data
|
|
Link Consolidated Data
|
Consolidate Data
|
Workbooks
|
|
Import & Export Data
|
Use the Office Clipboard
|
Import Data from Text Files
|
|
Import Data
|
Import Data from the Web
|
Export Data
|
|
COLLABORATE
|
Share Workbooks
|
Create a Shared Workbook
|
|
Resolve Conflicts
|
Track Changes in A Shared
|
Workbook
|
|
Track Changes
|
View the Change History
|
Workbook Protection
|
|
Worksheet Protection
|
Protect Cells in a Worksheet
|
Apply Workbook Protection
|
|
Apply Password Protection
|
Workbook Properties
|
Change Workbook Properties
|
|
EXCEL & THE WEB
|
Create Web Pages
|
Publish a Worksheet to Web
|
|
Create Hyperlinks
|
Publish PivotTable to the Web
|
Smart Tags to Retrieve Web
|
|
Data
|
|
|
.gif)
