EXCEL 365

Level 1

Vocabulary, Basic Formatting, Navigating Efficiently,

Basic Operations and Functions, Cut, Copy, and Paste, Duplicating Formulas, 3-D Formulas, Printing,
and critical tips and tricks!

​

Level 2

Tables, Sorting, Filtering, IF formulas, Vlookup,

Protecting your data, an introduction to Pivot Tables,

Drop-Down lists, Charts, and more tips and tricks!

​

PIVOT TABLES!

Now offering a class exclusively on Pivot Tables.

This 4-hour class will teach you how to create and modify

pivot tables by setting defaults, use fields more than once, showing summary data with different functions, percentages, ranking, grouping, slicers, timelines, data drill down,

individual reports, conditional formatting, using slicer choices

as titles, calculated fields, and more...

​

Announcing our newest class

 DYNAMIC ARRAYS!

(requires Excel 365 or 2021)

We are now offering a class on the new Dynamic Arrays

for Excel 365 or 2021.  This 8-hour class will cover the new Spill feature and the new functions

(Unique, Sort, Sortby, Filter, Xlookup, Sequence, and RandArray).

Get a jump on the competition and see how these new features can revolutionize how you use Excel.

​

The Level 1, Level 2, and the Dynamic Arrays are each 8 hours long (split into two 4-hour classes over two days).

The Pivot table class is 4 hours and is done in one day.