Excel Lookups and Pivots Short Course
Teams MeetingA 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.
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…
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…