Content Provider
Myexcelonline logo
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
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
Testimonials
Profile img default

Jessica, IL

"Every time I attend an Excel session presented by your team, I realize just how little I know about Excel. It's always humbling when you ask what level of proficiency we consider ourselves to be in Excel at the start of the course...because as we continue with the course, I always think that I should have downgraded my response from what level user I previously assessed myself to be. This course in particular really showed me how limited my pivot table skills are, and how much time I could have saved with the tips you provided. It's incredible that the system I set up for some of my monthly reports (that I previously thought were extremely efficient and amazing), I now consider extremely inefficient and a complete waste of time. Absolutely loved all of the tips, and enjoyed being "schooled" by the instructor. Thanks for another incredibly useful training!"
Profile img default

Frank, OH

"The course was awesome. I will have to go back and watch video again. It was fast paced but it was good in that I picked up some neat tips regarding Pivot tables, especially in how to locate blank cells in a table, etc. Maybe the best webinar that I have participated in."
Profile img default

Anne, OH

"I've taken a number of your courses. This one was, by far, the best ever. He truly taught us new skills rather than just selling a service. He was amazingly knowledgeable and, while he had to run through it quite quickly, gave a fantastic presentation! Thank you!"
Profile img default

Lisa, TX

"Wow! I learned more from John in one hour than I did in six months on the job Excel training. The information he conveyed in such a concise time span was amaaaazing. If he offers this course again, I'm sending more people from my company his way. Thanks!"
Profile img default

Peggy, GA

"Exceeded expectations! So much information brilliantly conveyed. Of course, a good bit of it was more advanced than I am, but I learned a lot and would like to listen again. Perhaps I'll find a use for it here at the office. I just love it."
Profile img default

Charmetra, GA

"The best one hour webinar I have ever attended! The presenter was highly effective in presenting the materials. I learned some new Excel Pivot Tables tricks as well as got a better understanding of Pivot Tables functions I already know."
Profile img default

Charles, GA

"The scale for the question "The session had a knowledgeable presenter", should have been extended to about "27". I thought I knew something about pivot tables, but now see I have only scratched the surface. Wow!"
Profile img default

Karen, VA

"This was an AMAZING seminar. I was blown away by how much can be done with Pivot Tables. The instructor did a great job of showing a lot of the potential and making me want to learn a lot more about this."
Show more testimonials
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!