Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
*** COURSE UPDATED OCTOBER 2016 ***
11 new tutorials have been added to the newly created Bonus chapter as well as 3 case studies under the Case Study chapter!
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this 2 and a half hour course which goes through the most important tools that are available in an Excel Pivot Table. The course is designed for Excel 2007, Excel 2010, Excel 2013 and Excel 2016.
In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers.
What you will learn?
What you get?
What some of the thousands of students who have viewed this tutorial have said...
The webinar was fantastic! I had quite a few jaw-dropping moments! - Tan - Livingston
I am one of the more advanced users in our organisation but I have realised that I knew next to nothing. Jocelyn - Melbourne
Not a question but just wanted to say in the space of 9 minutes I've learnt a lot. Richard - London
Wow! No question, just wow! Amazing! John - Hamburg
Simply awesome, with in an hour I found myself a Pivot expert - Natalie - Boston
I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way and I want to help you out as well because you deserve it! These tutorials will give you career-building skills that you can use to become better and more efficient at your job.
So go ahead and learn from the following Pivot table subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: EXCEL PIVOT TABLES|
There are two Excel workbooks for you when you download using the Resources button.
One is in a "Start" format so you can follow along and create the Pivot Tables as I teach you in each video.
The other one is in a "Finished" format so you can see how each Pivot Table looks in its final format. This way you can play around and see how the Pivot Table was created.
EXCEL RESOURCE BLOGPreview
MYEXCELONLINE PODCAST SHOWPreview
Why Most People Don´t Know How To Use Excel Pivot Tables?Preview
How to clean up your data set so you can create a flawless Pivot Table plus I show you why you should always convert your data in to an Excel Table.
Insert your first Pivot Table and explain the different Fields that you should put in the Row Labels, Column Labels, Report Filter and Values area.
How to Refresh a Pivot Table when you add more information in your data source;
Number formatting a Pivot Table;
Pivot Table Design: Styles, Grand Totals & Report Layout, Repeat All Items when in Outline Form layout.
How to add different calculations in your Pivot Table like Sum, Count and Average.
How to show your Sales Field as $ of Running Total In or YTD and the $ Difference from Previous Month.
How to Group by Sales numbers, Weeks and Text.
How to insert a Slicer and the different ways you can style & format a Slicer.
How to insert a Pivot Chart from a Pivot Table or a Slicer.
How to use a Slicer & a Pivot Chart to create an Interactive Dashboard by using Pivot Table Connections
Several time saving tips & tricks that will WOW YOU!
|Section 2: BONUS VIDEOS|
I have included the Excel workbooks for Lectures 16-26 which you can download and keep on your desktop to practice forever!
This workbook is in a "Finished" form with the Pivot Table already created for you, as I show you during the video.
You can follow along by creating a NEW Pivot Table simply by clicking in the data within the Data_Table worksheet of each workbook and going to Insert > Pivot Table.
You can then follow along as I go through the instructions in each tutorial.
Show the Classic Pivot Table Layout
Show various Grand TotalsPreview
Actual v Plan Variance Report
Group two pivot tables independently
Filter by Text wildcards * and ?
Different ways to filter a Slicer
Excel formulas & Calculated Fields
Data Bars, Color Scales & Icon Sets
Create a custom report with GETPIVOTDATA
Different pivot table views macro
|Section 3: EXCEL BUSINESS CASE STUDIES|
I have included the Excel workbook for this tutorial which you can download and keep on your desktop to practice forever!
This workbook is in a "Finished" form with the Pivot Table already created for you, as I
You can follow along by creating a NEW Pivot Table simply by clicking in the data within the
You can then follow along as I go through the instructions in each tutorial.
|Section 4: QUIZZES|
Recognize which button is used to update a Pivot Table
Recall the way to change a "Count Of" to a "Sum Of"
Identify the steps to showing the values as a Year to Date
State which command is used to group a PivotTable report by weeks
Recall the way to connect a Slicers to Pivot Tables
|Section 5: MY COMPREHENSIVE EXCEL PIVOT TABLE COURSE|
Dear Valued Student,
First of all I would like to thank you for purchasing the Excel With Excel Pivot Tables - Intro course.
I know that you have learned some new tricks that will make you better at Excel, so you can show off to your colleagues and boss!
With this course you have only just scratched the tip of the iceberg!
The next step in advancing your Excel skills and taking your Pivot Table analysis to the next level is the Xtreme Pivot Table Online Course!
This is an AWESOME course...especially considering you will be able to get all of the below from this online course:
· 30 Day Money Back Guarantee so you can view the course without any risk
· Course Bonus #1 ($490 Value): 12 Months of Dedicated Pro-Level Email Support
· Course Bonus #2 ($197 Value): 25% Lifetime Discount on Any MyExcelOnline.com Courses
· Course Bonus #3 ($25 Value): Power Pivot & Power BI Downloadable E-Book
· Course Bonus #4 ($90 Value): Pivot Table Cheat Sheet, Workbook Progress Tracker & Top 20 Keyboard Shortcuts
· Course Bonus #5 ($197 Value): Pivot Table webinar replay
· Course Bonus #6 ($97 Value): Intro to Power Query Online Course
· Course Bonus #7 ($97 Value): Intro to Power Pivot Online Course
“I have learned more about Pivot Tables within a week of taking this course than I have over the last couple of years. Really amazing stuff!” Joyce – England
“This is the best Excel course that I have taken! It not only talks about Pivot Tables in great detail, it also touches on charts, conditional formatting and macros. I can also track my progress and enter in Discussions with the lecturer who is always quick to respond. Excellent course for any Excel level” Jose - Spain
“This course is tremendously comprehensive. The best part is that the course is served in small bite-sized pieces that are easily digested. A teaching course that doubles as a reference guide. Definitely worth your time and money” James - USA
Now I want you to become better at your job and by taking this course you will be able to analyze data quicker, prepare awesome looking reports & interactive dashboards that will make you a key part of your team!
If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc.....then this is the course for YOU!
Get off the fence and get started NOW and join over 14,000 professionals who have taken this course and enhanced their Excel skills. Every hour you delay is delaying your professional progress.
UDEMY STUDENT DISCOUNT:
As a valued Udemy student you get lots of benefits and this is no exception! You will get a 25% discount on the course price simply by entering the following coupon code: udemystudent
Click the links below to join the course today. This will take you to a webinar page where you need to enter your details, watch the webinar where you will receive your invitation & special instructions on how to join this course which is open only a few times per year:
If you have any queries please email me at email@example.com and I will get back to you asap. To your success!
Chief Inspirational Officer
Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.
I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)
My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!
My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!
I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline. I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!
I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.
Join one of my courses and get ready to change your life!