| The "IF" Function |
"IF" Functions and Relational Operators
Using Text in "IF" Functions
Logical Operators ("AND" and "OR") with "IF" Functions
Nested "IF" Functions
Getting Table Data with "VLOOKUP" Function
|
|
| Dates and Time |
Using Dates as Values
Entering a Series of Dates
Date/Time Techniques |
|
| Multi-Sheet Workbooks |
Renaming Sheets and Coloring Tabs
Inserting and Deleting Sheets
Moving, Copying and Grouping Sheets
Formulas Across Multiple Sheets
|
|
| Multiple Workbooks |
Opening and Displaying Multiple Workbooks
Moving and Copying Sheets Across Workbooks
Linking Formulas Across Workbooks
Locating and Maintaining Links
|
|
| Features and Settings |
Show/Hide Gridlines and Formulas
Recently Used File List and New Workbook Settings
Other Settings and Features |
|
| Overview of Charting |
Quick Chart Creation
Chart Types
Titles, Gridlines and Scaling
Formatting Basics
Printing and Copying Charts |
|
| Overview of Database Features |
Sorting Data
Creating Subtotals
Filtering
Pivot Tables
|