Topic overview:  Creating pivot tables, applying filters, sorting and summarizing data, updating data sources, adding to data models.  We have distilled over 25 years of experience in teaching and solving the hardest problems that clients bring to us to an intense 6 hour course of tips, tricks, and shortcuts that dramatically improve your efficiency in…

Continue reading Excel 4: Working with Large Data Sets and Pivot Tables

Topic overview:  Creating, copying, and troubleshooting formulas and functions across multiple sheets and workbooks. Relative and absolute references, introduction to functions.  We have distilled over 25 years of experience in teaching and solving the hardest problems that clients bring to us to an intense 6 hour course of tips, tricks, and shortcuts that dramatically improve…

Continue reading Excel 2: Creating and Editing Formulas – Excel formulas for managing by the numbers.

An 2 hour course of tips, tricks, and shortcuts that dramatically improve your efficiency in Excel.