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