2.0 CPE This course begins by comparing the formula-based reports we built using SUMIFS in previous courses to reports using PivotTables. We dig into the details between these two report types so that you are comfortable applying them to specific scenarios.
This session is really fun because we create two versions of many reports, one version with formulas and the other with PivotTables so that you are comfortable replacing formula-based reports with PivotTables when appropriate.
Course Series
This course is included in the following series:
4 CoursesPivotTable Essentials
- PivotTable Essentials
- How to Use PivotTables instead of Formula-Based Reports
- PivotTable Conclusion and External Data Introduction
- Using PivotTables and PivotCharts to Prepare External Data
Learning Objectives
- Identify the three PivotTable report layout formats
- Discover the operator that causes Excel to create absolute structured table references
- Recognize the difference between calculated fields and calculated items
Last updated/reviewed: August 9, 2023
Included In Certifications
This course is included in the following Certification Programs:
9 CoursesExcel for Professional Applications Certification
- Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
- Excel Training: Skills for Better Workbook Design
- Excel Training: Boosting Proficiency with Selected Shortcuts (PC Version)
- Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
- Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
- PivotTable Essentials
- How to Use PivotTables instead of Formula-Based Reports
- PivotTable Conclusion and External Data Introduction
- Using PivotTables and PivotCharts to Prepare External Data
26 Reviews (85 ratings)
Reviews
Anonymous
(Owner)
Amazing course. Explanations are clear, the supporting files are what makes this course so effective. I learned a lot eventhough I have been using pivot tables for some time. Now, I can make a better job in less time. I highly recommend this course to anyone!
Anonymous
(-)
Another great course by Jeff. His explanations are very clear which is especially valuable when the material gets complicated. Following along with the workbook exercises is critical. I will definitely be returning to this course.
Anonymous
()
This gets pretty repetitive and Jeff goes very fast, so if you are new to pivot tables, you don't really want to start with this one. He does a great job showing some more advanced methods of pulling data out of tables.
Ellen Hynes
(Financial Consultant at Pacific Life)
A thouroughly thorough course on a deep excel subject. I feel very prepared now and highly recommend. It just took me a good bit longer than the state course time, as I wanted to learn this well. Scored 100%! :)
Jatin Talreja
(Financial Accounting Consultant at Wells Fargo)
How table col and table range reference change from relative to absolute when filled right using fill handle or fill command was a tip really cool and something I look forward to use in my work.
Anonymous
(Lead Wireless Data Analyst)
Intense with a lot of material to cover, but a great deal of useful info. Many ways to manipulate both formula tables and pivot tables to set up very efficient excel projects
Anonymous
()
Excellent overview of the topic very well presented.I wish the presentation materials were more substantial for later reference, but the practical examples were excellent.
Anonymous
(CFO)
Mr. Lenning is a very knowledgeable Excel instructor. The course is very hands on but Mr. Lenning moves through the exercises very quickly so you need to keep up!
Anonymous
(Accounting Director)
I've used pivot tables for a long time and didn't realize that the calculated field and calculated item functions existed. Will be very beneficial going forward.
Sheilah Brown
(Controller at SMB LTC)
The class showed me how to do some things in a different way than I had been. I can now use pivot tables to display data in much more user friendly way.
Grif Glenn
(Controller at Elder's Ace Hardware)
Great course for someone new to pivot tables. Fast paced. Requires more than the estimated time. Must work examples to get the most out of this course.
Anonymous
(Senior Accountant)
Great visual presentation of side by side formula based vs pivot table based approaches to same desired result. Well explained examples.
Paul Tansley
(President at Tansley's Tax & Fin..)
good course
Mark Eastman
(Accountant at Self)
A really sophisticated course on building reports using both pivot tables and formulas. Has the usual Lenning brisk pace. Recommended.
Anonymous
(CSR)
This was a great course for showing the value of Formula based Reports and Pivot Table Reports in there respective functions.
Robert Hendry
(Controller at NRI)
great excel course, moves a bit quickly at times but the ability to stop and go back allows this to work. Great course.
Anonymous
(Senior Manager)
Another great course by this instructor! I find it especially helpful to complete the exercises as I watch. Thanks!
Anonymous
(Senior Financial Analyst)
Excellent presentation. Learned much in a short span of time. Instructor presentation and narration is commendable
Anonymous
(Sr Accountant Lead)
This course provides a lot of pivot table examples. Jeff is very knowledgeable and explains the process well.
Anonymous
(Financial Reporting Manager)
Good explanations on various pivot table options with examples so you can actually practice the exercises.
Anonymous
(CFO)
Really helpful to see the side-by-side presentation with Formula based reports vs Pivot table reports
Anonymous
(Sr. Accounting Analyst)
The instructor is very knowledgeable and is very good at providing and demonstrating the information
Anonymous
()
informative course about the benefits of using a pivot table and the options available
Anonymous
(Accountant)
Instructor is very knowledgeable and presents information in a well organized manner.
Nicole Kolmetz
(Accountant at Personal Use)
This course is very well presented. Easy to understand and lots of exercises.
Ben Cudlip
(Staff Accountant at Omaze)
This course was really helpful! Thank you so much.
Prerequisites
Course Complexity: Intermediate
No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA
95113
Contact:
For more information regarding this course, including complaint and
cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to
.
Jeff LenningAuthor of Excel University
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 1608 W Campbell
- Av #221, Campbell, CA 95008
© 2024 Illumeo, Inc.