Pivot Tables are one of Excel’s most powerful tools, but most users only scratch the surface of what they can do.

In this hands-on session, Excel Expert Jon Peltier takes you from the fundamentals to advanced techniques, covering everything you need to turn raw data into clear, actionable insights. Whether you work in finance, operations, or any data-heavy role, these skills apply to any dataset you’re working with.

You’ll learn how to:

• Build and format Pivot Tables with confidence
• Use Slicers and Pivot Charts for dynamic, visual reporting
• Connect multiple data sources with Power Pivot
• Explore Dynamic Array alternatives like GROUPBY and PIVOTBY

Plus, get a peek at how teams are taking their Excel reports even further. Automate your data pull so you can spend less time building reports and more time analyzing what matters.

*A workbook will be included in the session.

Your Presenter

Jon Peltier, Excel Expert and Founder of Peltier Technical Services, Inc.

Jon Peltier is a master of leveraging the power of Excel to produce and simplify complex solutions in engineering, finance, and marketing. Jon holds a Doctor of Science degree from MIT in Metallurgy, his background includes Manufacturing, Statistics, Total Quality, and Six Sigma, and he knows more about Excel charts than practically anyone. Jon has been a full-time Excel developer since 2004 and has received Microsoft’s Most Valuable Professional award every year since 2001.

REGISTER FOR THIS FREE WEBINAR NOW

Can’t attend live? Sign up anyway and we’ll send you the recording so you can watch on your own schedule.

You can withdraw your consent at any time by clicking “Unsubscribe” in our emails or contacting us at support@hrmorning.com. For more information on how we handle your data, please read our Privacy Policy.