A deep dive into vlookup, hlookup, xlookup and pivot tables and how they work together.  Learn the basics and pitfalls as you transform raw data into meaningful knowledge.

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…

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

Advanced functions and charting. Organizing data for graphing, creating and modifying chart components, charting tricks and tips. Inserting functions – lookups, database, statistical, and financial functions. Nesting functions and troubleshooting…

Continue reading Excel 3: Charting and Functions