Suggested Excel Topics

  • Basic Workbook Navigation
  • Worksheet and Workbook setup
  • Cell and Range Formatting
  • Using SmartTags (2002 and later)
  • Using Custom Formatting
  • Worksheet Views
  • Auto Fill and Custom Lists
  • Working with Charts
  • Printing
  • Using Formulae
  • Using Excel's Built-in Functions
  • Working with Data
    • Sorting
    • Filtering Data
    • Creating Subtotals
    • Working with Lists (2003 and later)
    • Presenting Data using Pivot Tables
    • Advanced Database Filter
  • Creating and Using Templates
  • Auditing Workbooks
  • Consolidating Data
  • Using Scenarios
  • VBA
    • Introduction to Visual Basic
    • The Excel Object Model
    • Sub and Function procedures
    • Using Variables
    • Using IF and SELECT Case structures
    • Code Loops
    • Where should I store my code
    • Error Handling
    • Debugging your code
    • Customising Menus and Toolbars (to 2003)
    • Customising the Ribbon (2007)