Pivot Tables in Excel
Pivot Tables in Excel
In this course we teach you how to use Pivot Tables in Excel. Whether you are simply performing recons, or are responsible for data analytics and business intelligence in your company, Pivot Tables are the most important tool in Excel.
- Time Req – 8 hrs
- Skill Score >3.5
- FAQ
- All Online Courses
- Live Course Options
- Ask a Question
Pivot Tables are an intermediate skill and much easier to learn then all the complex VLOOKUP, SUMIFS type functions. BUT they are much more powerful!
If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar
Modules
Values in Pivot Tables
Lessons
Rows in Pivot Tables
Lessons
Columns in Pivot Tables
Lesson
Report Filter in Pivot Tables
Lessons
Slicers and Timelines in Pivot Tables
Lessons
Grouping in Pivot Tables
Lessons
Pivot Table Charts
Lessons
GetPivotData Function
Lessons
Pivot Table Conditional Formatting
Lesson
Calculated Fields and Items
Lessons
More Pivot Table Exercises
Lessons
- EXERCISE: QUICKLY EXTRACT A UNIQUE ITEM LIST
- EXERCISE: RECONCILE TWO LISTS WITH A PIVOT TABLE
- EXERCISE: PIVOT TABLES IN HR (LEAVE REGISTER)
- EXERCISE: CALL LOGS WITH PIVOT TABLES
- EXERCISE: RECONCILE PURCHASE ORDERS WITH INVOICES
- EXERCISE: EPL FOOTBALL STATS WITH PIVOT TABLES
- EXERCISE: WHEN LAST DID YOU USE A TRUCK
