Content Provider
Myexcelonline logo
Middlebanner right03282024
Additional Materials
MyExcelOnline: Blog
MyExcelOnline: Podcast
Course materials
Webinar Technical FAQs
Excelpivotfear

EXCEL PIVOT TABLES - OVERCOME YOUR FEARS & LEARN ITS POWER IN 1 HOUR

Cost Free
Presentation Length 1.0 hour

Recorded DateSeptember 10, 2015
CPE:Not available
(archived webinars do not offer CPE credits)
Subject AreaOther
Course LevelBasic
Who Should AttendCPA - small firm
CPA - medium firm
Other
Course Description

Pivot Tables are one of the most powerful features of Microsoft Excel. They have been around since the inception of Microsoft Excel but have been underutilized due to its many hidden functionalities. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly presentations.

In no time your newly developed skills will be noticed by your superiors as you unleash the power of Pivot Tables.

Learning Objectives

  • How to set up your data and create a Pivot Table in less than 3 minutes which will increase your efficiency

  • How to put your key business metrics like Year to Date Sales, Monthly Variations and Top 10 Customers in an interactive Pivot Table, taking your analytical skills to another level

  • How to create an Interactive Dashboard with Slicers & Pivot Charts that will WOW your boss and get you noticed by top Management

  • Pivot Table tips & special Bonus attendee material that you can keep and use to become better at Excel straight away which will skyrocket your personal development

Not logged
PLEASE NOTE: ARCHIVED WEBINARS DO NOT QUALIFY FOR CPE
Linkedin

John Michaloudis

MyExcelOnline
Chief Inspirational Officer
john@myexcelonline.com
34645899767

Myexcelonline logo

John is the founder of MyExcelOnline and long-time lover of Excel. He holds a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speaks English, Greek and Spanish. His Excel journey began after he graduated and has since helped many of his colleagues around the world understand this underutilised but powerful tool. Now it is his turn to teach the rest of the world! John has taught over 10,000 professionals around the world with his most comprehensive Pivot Table online course! He maintains a daily blog on Formulas, Pivot Tables, Charts and Data Analysis and interviews other Excel experts on his weekly Podcast show. John currently lives in the North of Spain with his wife and son. ADDITIONAL LINKS: www.myexcelonline.com/blog www.myexcelonline.com/podcast http://store.excel-university.com/product?catalog=XPT

About Our Presenter

Myexcelonline logo
MyExcelOnline.com was established to educate the beginner to intermediate Excel user on how to get the best out of Microsoft Excel via our online courses, daily blog tutorials and weekly Excel podcasts. We currently have the most comprehensive online course on Pivot Tables (200+ tutorials) and will be bringing more courses throughout the year. We publish daily tutorial blogs on key Excel topics such as Formulas, Pivot Tables, Graphs, Data Analysis, and Shortcuts to increase your Excel knowledge and efficiency. We also interview other Excel experts to get their Excel insights, tips and tricks and share them with you via our weekly Podcast show. At MyExcelOnline.com we are leveraging the online tools to get you better at Excel and Stand Out From The Crowd!