2.0 CPE This course introduces the PivotTable feature and covers all of the essentials. We start here to ensure that all participants, regardless of previous PivotTable experience, have the skills needed to do fundamental PivotTable activities and to build toward more advanced pivot table capability. We discuss the four report layout areas: rows, columns, values, and filters. We then discuss how to update PivotTable reports and ensure that any new transactions appended to the data source are included in the report. We explore how to create monthly columns and how to properly format the values in a PivotTable.
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
- Explore the process to create a PivotTable report
- Identify the four PivotTable report layout areas
- Recognize which type of PivotTable field will create report filters
Last updated/reviewed: March 23, 2024
Included In Certifications
This course is included in the following Certification Programs:
9 CoursesExcel 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
67 Reviews (219 ratings)
Reviews
Ezgi Ustundag
(Financial Analyst at Cisco LIFT)
I enrolled in this believing I was already proficient in Pivot Tables, and though the general information about the Pivot Table fields and features was a review for me, I loved learning about the keyboard shortcuts for dialog boxes that will minimize the amount of time I spend clicking in Excel. I also enjoyed the different methods of changing value displays and collapsing/expanding/grouping fields that Jeff demonstrated. Great for beginners and regular/experienced Pivot Table users alike!
Anonymous
(Senior Accountant Lead)
I really enjoy Jeff's classes and can pick up new tips and tricks. My only complaint is that the courses should include written materials that can be saved as reference. He moves through the course at a very quick pace and it is difficult to catch all of the shortcuts, etc. I always have to stop and re-wind several sections of the course in order to pick up the information. Please consider adding written materials to the courses.
Anonymous
(Associate Accountant)
I thought this was a great class. Jeff is fast, and his speed keeps up with more of an intermediate-level excel user, so it helps to already know the basics of pivot tables. I learned a lot of great stuff that I didn't know about pivot tables, and some additional shortcuts. Would absolutely recommend this class if you already know the pivot table basics! His teaching style is easy to understand/follow.
Anonymous
(Finance and Accounting Consultant)
Jeff explains things very well and in a fun way. The course was informative and interesting. It held my interest. Sometimes a bit too fast but can go over the material again.
It would be nice if the support materials had a listing of all the shortcut keys. They are presented too fast to remember, and it's difficult to go back and try to view the video looking for them.
Anonymous
()
Jeff makes learning Excel unintimidating, however, he is really fast and can lose folks as he goes along. Be prepared to pause the lesson so that you can keep up. But he has great stuff and a good enthusiastic teaching style. Plan on spending more than 2 hours if you really want to do all the exercises and really understand the material.
Anonymous
(Owner)
This is an outstanding course; the lectures are concise and engaging. I really appreciate that I can follow along with the supporting files. Moreover, the instructor has a great way of breaking down the information and explaining which makes for very effective learning. I highly recommend this course.
Nicole Kolmetz
(Accountant at Personal Use)
This is a very well presented course. The course covers all the subtle details that often overlooked in other presentations. The course has a lot of hands-on exercises that help to learn how to apply material to your workbooks.
Great Job Jeff!!! Thank you.
Karen Schrader
(Sr Accountant Lead at Charter Communications)
The course provided a lot of detail. It would have been best if I completed it in one setting. I learned a lot from the Groups & Subtotals chapter. Jeff adds a little humor and is always upbeat which makes the course interesting.
Anonymous
(Snr Accounting Consultant, CPA)
This a great introduction to pivot tables. Thank you for the tricks and tips that you offer. Definitely, one needs to practise to get the hang of pivot tables. I can see how one can save so much time. And up goes productivity!
Anonymous
(Director)
I used pivot table from time to time and is very familiar on how it works but I've learned few other things through this lecture. Jeff is a very good instructor and very engaging. This course is highly recommended.
Anonymous
()
Great course by Jeff Lenning! However, if you want to make the most out the tips and information provided, prepare yourself to spend four hours on the course as opposed to two. The extra time is well worth it!
Anonymous
(Senior Accountant)
Easy to understand step by step build up of Pivot Tables. Gives multiple approaches to achieve same desired result. Pulls in prior course volumes to aid in PT builds. Can easily start using steps in next PT.
Anonymous
(controller)
Awesome course! My only wish is that he would provide a written document with the short cuts. The only attached support are the excel workbooks. A "cheat sheet" would be really nice for shortcuts.
Anonymous
(Controller)
Great course for someone with basic understanding of pivot tables. Course is fast paced. You will need to work through all the examples. Expect to spend more than the suggested time to complete.
Ted Feher
(Owner at Feher, PC (CPA))
Very good tutorial on pivot tables. Easy to understand examples and in depth coverage of virtually all aspects of getting your data into a pivot table and how to modify presentation..
Anonymous
(Training Facilitator)
A lot of pivot table experience and knowledge is assumed to begin with. The instructor moves pretty quickly through the steps making it difficult to keep up at times.
Anonymous
(Accountant)
Thank you, Jeff for another excellent course. I will be buying your books for easy reference and practice. You make confusing concepts easy to understand. Well done!
Anonymous
(Assistant Controller)
It is more efficiency to build up different kinds of reports to meet the management needs. Especially enable to refresh the report after change the data source.
Anonymous
(Senior Accountant)
The coarse is great. I had little experience with pivot tables and this coarse is very helpful. I think creating a pivot table should be included in the exam.
Anonymous
()
Great, great course! I was unfamiliar with pivot tables and this really helped me gain a basic understanding. I really enjoy Mr. Lenning's teaching style.
Anonymous
(Accounting Assistant)
Course was very through and very well taught. I also like that the instructor has a sense of humor and keeps things light, as opposed to be so serious.
Anonymous
(-)
Good step by step guidance. I love being able to do the exercises along with the instructor. The instructor is very clear and upbeat. Great course!
Anonymous
(Senior Manager)
Great course! I enjoyed working through the exercises as I watched. I had to pause the playback a few times to keep up, but I loved the pace.
Anonymous
(Senior Accountant)
This was a good refresher course on what I have learned over the years about using pivot tables despite having no formal training
Jatin Talreja
(Financial Accounting Consultant at Wells Fargo)
I have been following excel university courses for many years now. Must say Jeff always makes excel learning fun & interesting.
Anonymous
()
The course is a very good introduction to pivot tables. The lecturer was clear and provided information in a palpable format.
Mark Eastman
(Accountant at Self)
A worthwhile introduction to Pivot tables . Useful when explaining Excels default logic for setting up tables and structure.
Anonymous
(Staff Auditor 1)
ok course, alot of information, would have bee nice to have the slide presentation available to review/refer back to as well
Leslie Harding-Ide
(Lead Wireless Data Analyst at Charter Communications)
There are new things to learn even if you already use pivot table. I specifically added date manipulation to my repertoire.
Anonymous
(President)
as always, good course.....................
Martin Smith
(owner at M. Ward Smith, Inc.)
This was a very good course. It walked you through common errors in addition to showing you how it was supposed to work.
Aminah Bey
(Senior Financial Analyst at Nemours)
Jeff just has a knack for breaking down the data to a level that is easy to comprehend and I absolutely love his humor:)
Anonymous
(Sr AP Specialist)
Great Information -- conveyed in a good way that encourages wanting to know more about utilizing all aspects of Excel.
Anonymous
(Church Controller Rep)
More basic than I was anticipating. I wasn't aware there would be a shortcut keys section not applicable to Mac users.
Sheilah Brown
(Controller at SMB LTC)
I use pivot tables a lot and I still learned things I didn't know and how to do some things faster. Very helpful.
Anonymous
(Wireless Data Analyst)
The instructor provided clear details, it was a bit challenging at times, had to stop a few times and practice.
Anonymous
(Accountant)
Well-structured and taught course. Instructure understands and explains material in a clear and concise manner.
Robert Hendry
(Controller at NRI)
a very well done course on the basics of pivot tables - great examples to help you work through what is taught
Anonymous
(Property Accounting Manager)
I wish a PDF of the main points was provided as a resource to keep since PIvot table a very useful tool.
Anonymous
(CFO)
Jeff's lessons are very practical and valuable. However, he does run through them material very quickly!
Anonymous
(Financial Reporting Manager)
Useful for learning the basics of pivot tables. The Excel files included for practice are very helpful.
Anonymous
(Senior Financial Analyst)
Useful course as it provides quick refresher course on Pivot tables. Recommended for brginners.
Anonymous
(CPA)
Love the course. Could have enjoyed less keyboard shortcuts and more on pivot table functions.
Anonymous
()
Good examples of how to create, use and format pivot tables. Presentation is easy to follow.
Anonymous
(CSR)
This was an excellent course to familiarize somebody with pivot tables and how to use them.
Anonymous
(Tax Consultant)
I knew the basics of pivot tables but this course took my understanding to the next level
Ben Cudlip
(Staff Accountant at Omaze)
Great course on the basics. I took me step by step through everything I needed to learn.
Anonymous
(Manager)
this course showed some tricks I was not aware of. it will help with my pivot table use.
Corey Masters
(Accountant, Internal Auditor, Risk Speci.. at Self)
Jeff does a great job and is a great teacher. He made it very understandable I thought.
Anonymous
(PMA)
This was a very well put together course with very good examples and sequencing. Thanks
Anonymous
(IT Advisory Snr. Associate)
This is a refresher course on pivot table. Everyone will benefit from this training.
Ellen Hynes
(Financial Consultant at Pacific Life)
thorough coverage of pivot tables. I have immediately started seeing the benefits.
Judy Heath
(Manager, Financial Shared Services at LennoxInternational)
Pivot information was good, but dialogue box navigation did not really apply
Anonymous
(Sr. Accounting Analyst)
The instructor is very knowledgeable and explains the information thoroughly
Anonymous
()
well organized tutorial, easy to understand, course material is very good.
Rena Faulkner
(Senior Accountant at Charter Communications)
A lot to cover, but it was educational. I liked the interactive exercises.
Prashant Shah
(Manager-FP&A at jda)
Good Course on Pivot table. All excel user need to go through this course.
Anonymous
(Accountant)
Thank you for your courses! They are super entertaining and helpful. :)
Anonymous
(APS)
Informative and easy to understand. Can't wait to use the new options!
Anonymous
()
This was an excellent course for pivot tables. Thanks I learned a lot.
Anonymous
(Card Program Administrator)
Enjoyed the training. Learned many new methods. Well worth the time.
Rabe Makwarela
(Admin Assistant at City of Detroit)
The instructor was easy to understand and used great examples.
Anonymous
(Compliance)
Good course. Objectives were completed. Easy to understand.
Anonymous
(Income Tax Senior)
very good course the pivot table basics and essentials..
Anonymous
(Accountant)
This is s very good course, reminding shortcuts as well.
Anonymous
(Consultant)
Great summary of Pivot table functions and limitations.
Anonymous
(Accountant)
Excellent course
Prerequisites
Course Complexity: Foundational
No Advanced Preparation or Prerequisites are needed for this course.
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.