EXCEL 365

Level 1 - The Basics

Vocabulary, Basic Formatting, Navigating Efficiently, Basic Operations and Functions,

Cut, Copy, and Paste, Duplicating Formulas, 3-D Formulas, and critical tips and tricks!

​​

​

​

​

​

​

​

Level 2 - Advanced

Tables, Sorting, Filtering, IF formulas, Vlookup, Protecting your data, an introduction to Pivot Tables, an introduction to Dynamic Arrays, Drop-Down lists, Protection, and more tips and tricks!

​

​

​

​

​

​

​

​

​

​

​

​

​PIVOT TABLES!

A class exclusively on Pivot Tables.

This 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...

​​

​

​

​

​

​

​

​

 DYNAMIC ARRAYS!

(requires Excel 365, 2021, or 2024)

We are now offering a class on the new Dynamic Arrays.  This class will cover the new Spill feature and many of the new functions such as Unique, Sort, Sortby, Filter, Xlookup, Sequence, RandArray and many more.

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

​

​

​

​

​

​

​

​

​

​

All classes are each 8 hours long
(split into two 4-hour classes over two days).