Spreadsheet Books


 

Advanced Microsoft Excel
- 2 Day Workshop

The following topics are covered:
  • Using lists and filters
  • Naming ranges
  • Outlining a worksheet
  • Creating a workspace file
  • Consolidating data
  • Using Database functions, advanced filters, and automatic subtotals
  • Creating Pivot Tables
  • Using MS Query
  • Using styles
  • Creating and using template files
  • Auditing a worksheet
  • Working with forms