top of page

Training

We’ll provide training one-on-one or to a small group that is customized to your learning level and business needs. Choose from one of our standard training levels, or work with us to design your own training package.

Basic

  • Performing basic worksheet operations

  • Formatting worksheets

  • Introducing formulas and functions

  • Working with tables

  • Conditional formatting

  • Printing a spreadsheet

  • Selecting and copying data

  • Absolute reference

Intermediate

  • Using formulas for matching and lookups

  • Getting started in Excel charts

  • Creating sparklines

  • Importing data

  • Creating worksheet outlines

  • Using advanced charting techniques

  • Functions including AVERAGEIF, SUMIF, and COUNTIF

Advanced

  • Linking and consolidating worksheets

  • Introducing pivot tables

  • Using IF and IFS

  • Cleaning data

  • Data validation

  • Pivot tables: grouping, filtering, and slicers

  • Data tables

  • Goal seek

  • Protecting a worksheet

  • Macros

Expert

  • Scenario manager

  • Solver

  • Power pivot

  • Power query

  • Creating UserForms

  • Using UserForms controls in a worksheet

  • Excel events

bottom of page