Whether you need to build an Excel-based dashboard, perform some serious data analysis, or simply summarize data for a small project, Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) toolkit. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards, and charts that help you to summarize, analyze, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on which you base your key business decisions. Pivot Tables have a reputation for being complicated and scary but by attending this training, you’ll be pleasantly surprised at how easy it is to use and create them.
If you are tasked with summarizing data for reports and are frustrated with the process, attend this class! You will save time and your sanity when you understand the power of the Pivot Table!
If you are tasked with summarizing data for reports and are frustrated with the process, attend this class! You will save time and your sanity when you understand the power of the Pivot Table!
Andy Lanning
Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC. Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S. Andy’s background includes corporate training, private training, and freelance data analysis. She has recorded several online training courses for Udemy.com, GoSkills.com, and in her career has delivered …
Effective And Defensible Documentation Of Employee Problems…
Stress, Change And Team Resilience Through Humor: An Intera…
2026 EEOC & Employers: Investigating Claims of Harassment …
Burnout to Fired-up : Recognizing and Preventing Burnout in…
From Chaos To Calm: How to Eliminate Drama and Boost Workpl…
Be a Better Leader: Dealing with your Inner Control Freak, …
Project Management For Administrative Professionals
HR Metrics and Analytics 2026- Update on Strategic Planning…
The Emotionally Intelligent Manager: Thriving Under Pressure
AI, Jobs, and Skills: How HR Leaders Can Prepare Now for th…
ChatGPT and Project Management: Leveraging AI for Project M…
GROUPBY and PIVOTBY functions. Pivot table killers?
Stop Letting That Difficult Person Ruin Your Day: Effective…
Launch Your Career: The Ultimate Guide for Emerging Profess…
Recruiting Top Talent in a Digital Era
Copilot and HR: An Introduction for HR Professionals
The Importance of the first 5 seconds when presenting
How to Write Procedures to Avoid Human Errors
Microsoft Excel - Data Validation Techniques
Using Claude in Excel for Productivity, Automation & Data A…
AI for Excel Professionals: Enhancing Productivity with Cha…
2026 Form I-9 Changes & New ICE Penalties: What Every Emplo…
Human Factors Usability Studies Following ISO 62366 and FDA…
FDA Compliance for Regulated Systems using COTS, Cloud, and…
Implementing an Effective Succession Plan to Identify, Deve…
ChatGPT for HR - Build HR Policy Framework and Strategy
Boost Financial Analysis with Claude in Excel
I-9 Enforcement & Compliance: A 5-Step Plan for Employers t…