Best Pivot Tables Courses

Find the best online Pivot Tables Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Pivot Tables Courses.

Microsoft Excel Pivot Tables – The Beginner Course

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!

Created by Matt Jackman - Digital Analytics and SEO Professional

"]

Students: 151181, Price: Free

Students: 151181, Price:  Free

What's this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they'll change the way you use Excel.

If you're not familiar with Pivot Tables, they're a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you'll need to start using Pivot Tables.

Who will benefit from this course

If you're somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don't have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you'll learn in this course

  • How to create a Pivot Table
  • How to summarize information in different ways using Pivot Tables

By the end of this course, you'll be able to take your own information and leverage Pivot Tables to answer questions with ease!

Microsoft Excel – Data Analysis with Excel Pivot Tables

Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 138976, Price: $174.99

Students: 138976, Price:  Paid

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course:

"This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT"

-Monique C.

"Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!"

-Paul M.

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well."

-Ernie A.

__________

FULL COURSE DESCRIPTION:

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

  • Raw data structure in Excel

  • Pivot Table layouts & styles

  • Design & formatting options

  • Sorting, filtering, & grouping tools

  • Calculated fields, items & values

  • Pivot Charts, slicers & timelines

  • Interactive Excel dashboards

__________

We'll then explore and analyze Excel datasets from a number of real-world case studies, including:

  • San Diego burrito ratings

  • Shark attack records from 1900-2016

  • Facebook Post data from Spartan Race

  • Major League Baseball team statistics

  • San Francisco employee salaries

  • Daily stock market data

  • IMDb movie ratings

  • Apple Store mobile app ratings

  • Wine ratings and descriptions

__________

Whether you're looking for a quick Excel Pivot Table primer, trying to diversify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place. In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro!

See you there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics

Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Great for interview prep!

Created by Jeff Knowlton - Senior Executive. Data Scientist. Teacher.

"]

Students: 119237, Price: Free

Students: 119237, Price:  Free

Here's what some students are saying about the course in the Reviews!

"Really concise quick summary and foundation in Excel" - Clare B.

"Instruction was very easy to follow. It was like having a friend show you what to do." - Patrick M.

"Very clear and easy to understand" - Fiona M

 "Great introduction to pivot tables and good examples too."  - John P. 

"Needed this to get ready for a new job, feeling more confident already!" - Daniel H.

"I have been using Excel for years but only in very specific ways. This course gave a good overview of major functions I have never used and didn't know existed. Will be making some accounting pivot charts right away." - Kyrie

The course is just 36 minutes - you can finish it over a lunch break! That’s how long it takes to complete the videos in this course, and come away with a strong understanding of the use of Excel in business. You’ll learn many of the important Excel functions: IF, VLOOKUP, pivot tables and charts, including line charts, column charts and 3D column charts. You’ll learn how to enter and edit data and formulas. How to format text and numbers. How to filter and sort large tables of data and calculate totals.

Only 36 minutes! How is this possible? I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. You’ll learn how the functions work, and you’ll learn when, and why, to use them in business analytics. Full disclosure: plan for another 45 minutes or so to work through the case studies yourself. I provide all of the files. 

And it’s free! Even though free, it includes all of the features of the standard course: downloadable files, closed captions and quizzes, to help you learn and make it stick. 

This course is designed for people who are preparing for an interview. Starting a new office job. Looking to jump-start their career. And even for those people who are thinking about a longer Excel course, but who aren't sure that Excel is right for them. 

But let’s make something clear: you won’t be an expert. This course is a starting point, the first step on your journey to learn business analytics. It may be as far as you need to go. Let’s find out! Click the button “TAKE THIS COURSE” and get started. 

The Complete Microsoft Excel Pivot Tables and Pivot Charts

Excel Charts, Excel Analytics, Excel Pivot Table , Excel Pivot Charts, Excel Dashboard, Excel Data Analysis & Reporting

Created by A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office) - 200,000+ Students | 4+ Rated | 190 + Countries

"]

Students: 73495, Price: $19.99

Students: 73495, Price:  Paid

Recent Student's Reviews

***It Is Very Helpful And Easy To Understand. I Have No Doubts Regarding Pivot Tables And Its Formatting After Going Through It. Thank You For The Wonderful Teaching And Technical Support. - Deepak Kumar Kanaujia***

***Very Detailed Illustration And The Instructor Knows Well How To Use His Tools. Happy To Attend This Course And I Believe I Am Gonna Use It A Lot In My Work. - Mohamed Eltantawi***

***Wonderful Course. I've Been Using Excel For Many Years. But, What I've Learned In This Course Is A Paradigm Shift. - Yousuf Saif Al Hinai***

***Wow! Its Amazing Pivot Tables Course. I've Lots Of Gap On This Topic. Now, I've Clear Concept. - Md. Anisur Rahmen***

Nine Reasons why you should choose this The Complete Microsoft Excel Pivot Tables and Pivot Charts Course

  1. Best Rated Course on Udemy

  2. You will learn various data analysis techniques using MS Excel

  3. Latest updated and Doubts Are Solved in this course

  4. Carefully designed curriculum By Proficient In Microsoft Excel Expert

  5. you can complete this course In Short time

  6. Pivot table & Pivot charts related examples and case studies Provided

  7. 06 Examples And  practice exercises Are Able to Download in The Recourse Section

  8. Your queries will be responded by the Instructor With In Short time

  9. A Verifiable Certificate will Be Provided On the Completion

Microsoft Excel's Pivot table and Pivot charts are  The Powerful Tools to Analysis And Manipulating the data . it helps to Analysis the data in different perspective to take importance and Essential decision making in the organization. The pivot tables and pivot chats help to calculate, summarize the data very quickly. Pivot Tables Allow to see comparisons, patterns, and trends by using our data. The Course Contents Eight Chapters & The Details As Below.

What is covered in this course?

CHAPTER -01 INTRODUCTION TO PIVOT TABLES & PIVOT CHARTS

  • Introduction To Pivot Tables & Pivot Charts

CHAPTER -02 FORMAT DATA FOR PIVOT TABLES IN EXCEL

  • Normalize The Data For Pivot Table

  • Convert Normal Data To Table

CHAPTER -03 CREATE PIVOT TABLE AND FORMAT VALUES IN EXCEL

  • Create The Pivot Table In Excel

  • Format Values In Pivot Table

CHAPTER -04 EXPAND AND COLLAPSE PIVOT TABLE IN EXCEL

  • Expand And Collapse Pivot Table In Excel

  • CHAPTER-05 REPORT FILTER AND REFRESH PIVOT TABLE IN EXCEL

  • Report Filter Pivot Table In Excel

  • Refresh Pivot Table In Excel

CHAPTER-06 CREATE DYNAMIC DASHBOARD & PIVOT CHARTS FROM PIVOT TABLES

  • Create Bar Chart -Clustered Bar

  • Create Column Chart -Clustered Column

  • Create Pie Chart - Doughnut Chart

  • Create Column Chart - 3d Column Chart

  • Create Line Chart- Line With Markers Chart

  • Insert Slicer

CHAPTER -07 MANAGING PIVOT TABLES

  • Connecting To An External Data Source

  • Creating A Recommended Pivot Table

  • Copy And Move Pivot Tables

  • Delete The Pivot Tables

  • Clearing & Reapplying Pivot Tables

  • Copy The Values Only From Pivot Table

CHAPTER-08 COMPLETE PIVOT TABLES AND PIVOT CHARTS EXERCISES WITH ANSWERS

  • Complete Exercises Questions One To Seven

  • Complete Exercises Questions Eight To Fourteen

  • Complete Exercises Questions Fifteen To Seventeen

Go ahead and click the enroll button, and I'll see you in Chapter 1!

Cheers

A.M.A.M.Mubeen

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 54092, Price: Free

Students: 54092, Price:  Free

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Welcome to my “Excel 2016 Pivot Table” course where you will learn how to create basic pivot tables.

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly around 15,000 Excel users come to my Excel blog and read my Excel and data analysis related articles and tutorials.

At the end of this course:

  1. You will be able to create and update basic pivot table reports using Excel 2016,
  2. You will be able to realize, why and when you can best use of Excel Pivot Table tool,
  3. You will be get used to with the features of an Excel Pivot Table Report
  4. And you will be able to handle the limitations and compatibility issues related Pivot tables.

Let me give you an idea what exact topics I am going to teach you in this course.

  1. I will show you the exact cases when you can use the Excel Pivot Table
  2. Then I will show you the anatomy of a pivot table report with a real life example.
  3. Then you will see the step by step by process of preparing a data source for Excel Pivot table
  4. Then you will learn how to create and update a basic pivot table report
  5. Then you will be introduced with the Slicer tool in Excel
  6. And at the end of the course, I will show you total three techniques that you can use to will save your time when you’re working with Excel Pivot tables.

I have designed this course for new comers in Excel pivot table feature. But if you are an intermediate level user and want to be get used to with Excel 2016 Pivot table feature, then this course is also for you. This course will give you a simple but powerful introduction to the most powerful tool in Excel.

Feel free to take a look at the free previews of this course. I hope this course will change your view about Excel Pivot Table. Enjoy the course and thanks for reading!

Microsoft Excel – Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 49142, Price: Free

Students: 49142, Price:  Free

Welcome to this course about Microsoft Excel.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting.
  • Create tables, PivotTables, Chart, PivotCharts and Sparklines.
  • Find out how powerful Visual Basic for Applications (VBA) is.
  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features - and you'll find out how much more you can learn.

Free Basic Excel Course + Lookup Function

Excel made easy for everyone

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 41781, Price: Free

Students: 41781, Price:  Free

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables.

In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.

Microsoft Excel Pivot Tables – Master Excel Pivot Tables!

Excel with Microsoft Excel Pivot Tables & Data Analysis - Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 32511, Price: $94.99

Students: 32511, Price:  Paid

You’re Just Seconds Away From Leveraging Excel & Pivot Tables That Will Make It Possible For YOU To:

  1. Increase your Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

**** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! ****

>> UPDATED APRIL 2020 with several Homework practice activities to increase your skills and an Assignment!

----------------------------------------

What some of the thousands of students who have viewed this tutorial have said...

"The course was fantastic! I had quite a few jaw-dropping moments!!" - Tan - Livingston

"I am one of the more advanced users in our organization but I have realized 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

----------------------------------------

No matter if you are a Beginner or an Advanced user of Excel,  you are sure to benefit from this quick 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, Excel 2016, Excel 2019 and Office 365.

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?

  • How to set up your data and create an Excel 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 Excel Pivot Table, taking your analytical skills to another level!

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

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

Scroll down this page to view the full Course Curriculum...

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Microsoft Excel 2016 Beginners & Intermediate Excel Training

Excel 2016 for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 30720, Price: $129.99

Students: 30720, Price:  Paid

Do you want to learn how to work with Excel 2016?

Even if you don’t have any prior experience?

If so, then this is the right course for you!

A Verifiable Certificate of Completion is presented to all students who complete this course.

Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far.

However, it’s essential that you learn how to work with it effectively.

If you want to become any of the following…

  • Executive Assistant

  • Office Clerk

  • Auditor

  • Accountant

  • Business Analyst

  • Financial Analyst

  • Credit Counselor

  • Sales Representative

  • Sales Manager

  • Financial Manager

  • Investment Banker

  • Real Estate Agent

  • Market Research Analyst

  • Financial Advisor

  • Business Operations Manager

  • Entrepreneur 

  • Someone who is involved with a business and would like to be successful

Then you simply have to learn Microsoft Excel 2016. There is no way around it.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.

What makes this course different from the rest of the Excel courses out there?

  • High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)

  • Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance)

  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)

  • Extensive Case Studies that will help you reinforce everything that you’ve learned

  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours

  • Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course

How come Microsoft Excel is so important?

Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.

Here are 5 more reasons why you should take this course and learn Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths

  • Promotions. Top Excel users are promoted very easily inside large corporations

  • Bill Gates knows how to work with Excel

  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?

Enrol today and let's start this journey together!

Pivot Tables, Power Pivot Tables, Power Query & Power BI

5 Course Excel Bundle: Microsoft Excel, Pivot Tables, Power Pivot Tables, Power Query & Power BI (Excel 2007-2019, O365)

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 30410, Price: $119.99

Students: 30410, Price:  Paid

You’re Just Seconds Away From Leveraging Microsoft Excel, Pivot Tables, Power Pivot, Power Query & Microsoft Power BI That Will Make It Possible For YOU To:

  1. Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

Listen to a few of our satisfied students who have taken this TOP-RATED Microsoft Excel course and advanced their Excel skills in days:

          "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

           "I was a Pivot Table novice when I started this course but with just a few lessons I was becoming more and more confident at using Pivot Tables.  John's teaching style is engaging, his voice is clear and the videos are first class and very in-depth, as he covers ALL the Pivot Table features.

There are plenty of exercise files and real life homework activities to practice the skills learned. I can now say with confidence that I am an advanced Excel & Pivot Table user to my colleagues, boss and future employers.

Thanks John for this comprehensive course and I am forever indebted to you. Keep up the awesome work you do." - Sebastian

----------------------------------------         

***** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! *****

***** GET 5 MICROSOFT EXCEL COURSES FOR THE PRICE OF 1 *****

> UPDATED APRIL 2020: New Excel Pivot Tables Features For Excel 2019 & Office 365.

> BONUS EXCEL COURSE: 333 Excel Keyboard Shortcuts with Free PDF Cheat Sheet for Windows & Mac

> 7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!!
---------------------------------------- 

YOU GET THE FOLLOWING 5 COURSES WITH THIS EXCEL BUNDLE:

----------------------------------------

COURSE #1 - EXCEL PIVOT TABLES

----------------------------------------

If you want to get better at Excel and stand out from the crowd to get the promotions or pay-rises that you deserve, then you are in the right place!

This is the most comprehensive Excel Pivot Table online course ever made which has over 250 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table.  The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

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.  The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!  

There are 17 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies. 

Here are the main topics that we will cover in this course:

EXCEL PIVOT TABLES COURSE:

  1. CUSTOMIZE   YOUR PIVOT TABLE       

  2. VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

  3. VALUE FIELD SETTINGS > SHOW VALUES AS

  4. GROUPING

  5. SORTING

  6. FILTERING

  7. SLICERS

  8. CALCULATED FIELDS & ITEMS

  9. PIVOT CHARTS

  10. CONDITIONAL FORMATTING

  11. GETPIVOTDATA Formula

  12. MACROS       

  13. DATA MANAGEMENT       

  14. BONUS VIDEOS       

  15. NEW EXCEL 2013 PIVOT TABLE FEATURES       

  16. NEW EXCEL 2016 PIVOT TABLE FEATURES

  17. NEW EXCEL 2019 & OFFICE 365 PIVOT TABLE FEATURES   

----------------------------------------

COURSE #2 - EXCEL POWER PIVOT & DAX FORMULAS

----------------------------------------

Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. It allows you to harness the power of Business Intelligence right in Excel.

In a nutshell, Power Pivot allows you to use multiple data sources for analysis. So it is a Pivot Table on steroids, meaning it can handle more data and create more powerful calculations using Measures & DAX Formulas.

Power Pivot gives you the power to work with large sets of data that are OVER 1 millions rows!!!

You can import, consolidate and create relationships from your data and perform enhanced analysis. The beautiful thing with Power Pivot is it allows you to work on Big Data with NO limitations.

Imagine getting data from multiple sources like SQL Server, Oracle, XML, Excel, Microsoft Access and analyzing these all into one awesome Pivot Table!

This course will introduce you to the key concepts of getting started with Power Pivot and it's various features for enhanced calculations, so you will be confident & comfortable in using Power Pivot on your data.

Here are the main topics that we will cover in this course:

EXCEL POWER PIVOT & DAX COURSE:

  1. IMPORT/LOAD DATA

  2. TABLE RELATIONSHIPS

  3. PIVOT TABLES & SLICERS

  4. INTRO TO DAX FORMULAS

  5. MEASURES & CALCULATED COLUMNS

----------------------------------------

COURSE #3 - EXCEL POWER QUERY

----------------------------------------

This is the Ultimate Microsoft Excel Data Cleansing course which has over 60 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single analytical & data cleansing tool that is available in Microsoft Excel. 

The course is designed for Excel 2007, 2010, 2013, 2016 or 2019 and Office 365.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers! 

The course is just over 4 hours long so you can become an awesome analyst and advanced Excel user within 1 day! 

In the first part of the course you will learn the various "Data Cleansing" techniques using Power Query or Get & Transform - as its name changed in Excel 2019 and Office 365.  We will show you how to:

EXCEL POWER QUERY - PART 1

  1. Clean & transform lots of data quickly

  2. Import data from various external sources, folders & Excel workbooks

  3. Consolidate data with ease

  4. Sort & Filter data

  5. Merge data

  6. Join data

  7. Data shaping & flat files

  8. Auto cleanup your data

  9. M Functions

In the second part of the course you will learn "Data Cleansing" techniques using various Excel features such as:

EXCEL POWER QUERY - PART 2

  1. Text Function

  2. Logical and Lookup Functions

  3. Text to Columns

  4. Find & Remove Duplicates

  5. Conditional Formatting

  6. Find & Replace

  7. Go to Special

  8. Sort & Filter

----------------------------------------

COURSE #4 - MICROSOFT POWER BI

----------------------------------------

If you want to get better at Microsoft Power BI so you get a better paying job or just get answers & insights from your data FAST with Power BI Dashboards, then you are in the right place!

No matter if you are an Power BI Beginner or NEVER USED POWER BI before, you are sure to benefit from this quick course which goes through the MUST KNOW Power BI features.

You will be able to master Power BI straight away the following (in just 90 minutes) with the following Sections:

  1. Introduction to Power BI

  2. Creating a Power BI Dashboard

  3. Advanced Power BI Dashboard with Real Live Data

----------------------------------------

COURSE #5 - 333 EXCEL KEYBOARD SHORTCUTS

----------------------------------------

This is the most comprehensive Excel Keyboard Shortcuts course ever made which has 333 short and precise video tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single Excel shortcut that is available inside Microsoft Excel.  The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

If you learn only 5 Excel keyboard shortcuts and apply them each day, you will SAVE HOURS each week, which means you can go home early for once!

There are 15 different modules so you can work on your weaknesses and enhance your strengths as well as practice files, quizzes and a FREE PDF Cheat Sheet listing all 333 Excel Keyboard Shortcuts for Windows & Mac that you can print off and keep. 

Here are the main keyboard shortcut topics that we will cover in this course:

333 EXCEL KEYBOARD SHORTCUTS VIDEO COURSE:

  1. Cell Formatting

  2. Drag & Drop

  3. Formulas & Functions

  4. Frequent  shortcuts

  5. Function Key   

  6. Making selections

  7. Ribbon Tab

  8. Cell Navigation

  9. Inside Ribbon 

  10. Macros & VBA

  11. Pivot Tables 

  12. Power BI 

  13. Power Pivot

  14. Other Shortcuts   

----------------------------------------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including over 250+ downloadable Excel workbooks, Quizzes, Assignments, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Learn Excel in 60 Minutes: Using Real Company Data

Filtering, SUMIFS, Pivot Tables, Conditional Formatting

Created by Tony Li - Hotel Manager

"]

Students: 27041, Price: Free

Students: 27041, Price:  Free

Use Excel to organize a real company's accounting and customer data. Then apply key practices in data analytics to draw insights from the data. 

This course is very straightforward and targets people that want to pick up Excel as quickly as possible. Keep in mind that this course may not be for everyone because we move fast. Video tutorials are also done on a Mac, and it may be a little different on a Windows PC. 

You are not required to have any prior experience with Excel, but there will be some knowledge gaps if you are 100% unfamiliar with it. In any case, we have structured the course so that you can  easily follow along, but we expect students to be resourceful (i.e. Google) to fill in any gaps. 

Excel tools you will learn: Pivot Tables, SUMIFS, COUNTIFS, AVERAGEIFS, filtering, conditional formatting, copying formulas, using dollar signs, and more!

Beginners Guide to Microsoft Excel Pivot Tables

Pivot Tables separate beginners from intermediates and allow you to delve deep into your data like no other tool can!

Created by Jed Guinto - ~445,000 Enrolments, ~185,000 Students, ~12,000 Reviews

"]

Students: 26600, Price: $19.99

Students: 26600, Price:  Paid

WHAT’S YOUR STORY?

  1. Are you a business professional needing to up-skill?
  2. Are you struggling to get a pay-rise and/or promotion?
  3. Are you a recent graduate with an empty looking resume and no job experience?
  4. Have you recently been laid off, fired or had a contract end?

If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. 

The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.

A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.

This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.

 

ONLINE TRAINING AND THE MOST COMMON PROBLEMS

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.

 

COURSE DELIVERY STYLE

I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.


WHAT YOU’LL LEARN IN THIS COURSE

Pivot Tables are extremely powerful analytic tools available in Microsoft Excel. I shall share an example of it's use using my favorite lunch time chocolate snack, M&M's!

If you don't know what M&M's, firstly you haven't lived, and second, they're awesome chocolates that come in little bite size forms in a variety of colors. So imagine someone gives you 100 M&M's. It's your job to sort them by color, by type and by size. Obviously, this will take a long time as you have to sift through the M&M's one by one. However, imagine you had some magical tool that will instantly sort the M&M's however you like. By type....No worries! By colour....even easier! 

Pivot Tables sort, group and summarize information similar to sorting M&M's by colour, size or shape. It's so easy to use and even easier to learn! In this course I'll teach you how to setup your data, how to create your first pivot, apply the different types of parameters using the pivot module, change data sources, refresh links and much more. 

So what are you waiting for, sign up today!


ABOUT ME

  1. Member of the Udemy Council
  2. Co-Founded Paperclip Learning which teaches Microsoft Office
  3. Over 60,000 students and over 17,000 students for this course alone
  4. Over 130,000 enrollments
  5. Over 5,000 Positive Reviews and over 1,000 Reviews for this course
  6. Over 20 courses on Udemy

Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.


TESTIMONIALS

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks!

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach.

Excel Essentials for the Real World (Complete Excel Course)

Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas... (Excel 365, 2019 & 2016)

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 23289, Price: $129.99

Students: 23289, Price:  Paid

Learn Excel from Scratch OR become more CONFIDENT.

*******************************

COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as:

  • Excel's new XLOOKUP function

  • New FILTER function in Excel

  • SORT, SORTBY & UNIQUE functions

In addition to the above, we also cover:

  1. Excel's new calculation engine and how older formulas are impacted

  2. What the Hash (#) sign is

  3. Compatibility and the at (@) sign you might see in your older files

  4. The new errors such as #SPILL and #CALC

  5. Data validation drop-down lists and dynamic array references

If you have Excel for Microsoft 365 and you'd like to discover how you can take advantage of these new functions, make sure you check out this new section.

*******************************

Looking to learn Microsoft Excel and improve your data analysis skills but don't know where to start?

OR, you've been using Microsoft Excel for a while but don't feel 100% confident?

There is so much information out there. What do you need to succeed at work?

I’ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.

In fact, I collected the most common Excel problems faced by my clients. I added in my 15+ years' experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel MVP and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.

These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.

There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.

________________________________________________

WHY TAKE THIS SPECIFIC EXCEL COURSE?

Yes. There are many Microsoft Excel courses out there teaching you the important Excel functions and features you need to master.

BUT, can you apply what you learnt to your own files?

Do you get enough practice and challenges to remember all the new information?

This course will get you confident and comfortable designing simple to complex spreadsheets.  You'll go beyond Excel basics. As you go through the course, you'll be able to apply what you learnt immediately to your job.

You'll master new formulas and find better ways to setup your existing spreadsheets. Management loves efficiency.

In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder.

_________________________________________________

IS THIS ONLINE EXCEL COURSE FOR BEGINNERS ONLY?

This Complete Excel Course is for two types of people:

  1. Excel beginners, i.e. anyone looking to learn Excel from scratch

  2. Excel intermediate and Excel advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of.

The Excel Essentials for the Real World Course covers ALL the fundamentals an Excel beginner needs to know. BUT it also fills in the gaps for Excel Intermediate and Advanced users. It's for corporate professionals who feel comfortable with Excel but not 100% confident.

This is more than an Excel Basics Course. It starts off easy and adds in tips and tricks many Excel advanced users don't know of.

________________________________________________

WHAT YOU'LL BE ABLE TO ACHIEVE

By the end of the course you'll be confident showcasing your new Excel skills at work, allowing you to:

  • Input data and navigate large spreadsheets

  • Apply Excel hacks to get your work done faster

  • Be able to choose the right Excel formula to automate your data analysis (Excel VLOOKUP, IF Function, ROUND and more)

  • Use hidden Excel features to transform messy data to proper data sets

  • Get answers from your data

  • Organize, clean and manage large data

  • Create compelling Excel reports by following the set of spreadsheet design principles

  • Turn messy data into helpful charts

  • Create interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Time Lines

  • Import and transform data with tools like Get & Transform (Power Query)

We start from Microsoft Excel basics to make sure we have the right fundamentals. We them move on to more advanced topics like Conditional Formatting, Excel Pivot Tables and Power Query. We cover important formulas like VLOOKUP, SUMIFS and nested IF Functions.

I don't just cover the purpose of a feature or formula but how you can take advantage of it using practical examples.

There are challenges and quizzes along the way to test your new Excel skills.

Your downloadable Excel Course Notes are available as a PDF file. These cover the most important points. Keep them handy and refer to them when you need to.

________________________________________________

WHAT ARE SOME EXCEL FEATURES AND FUNCTIONS I WILL LEARN IN THIS COURSE

You'll learn:

  • How to customize the Microsoft Excel interface so you so you can easily find the files and features you use often.

  • To apply formatting correctly for cleaner and more professional reports.

  • To use important features like drop-down lists in Excel and add data validation to the cells. This way you can restrict the type of data which can be input in each cell.

  • How to add comments and notes to cells.

  • Add time stamps to your reports.

  • Automate data entry with Auto-Fill and Flash-fill.

  • How to best navigate large data and large spreadsheets.

  • Useful Excel shortcuts for data entry and navigation.

  • How to Protect your Excel files and worksheets properly.

  • Excel's essential rule when it comes to writing formulas.

  • How to write basic to advanced Excel formulas - also formulas that reference other workbooks or other worksheets.

  • The most useful Excel functions like, COUNTIFS, COUNT, SUMIFS, AVERAGEIFS, VLOOKUP, IF and many more.

  • How to convert raw Excel data into information you can use to create reports on.

  • Excel features that will help you to organize and structure data so it makes analysis easier (Sort, Filter, Search & Replace Go to Special etc...)

  • Useful Excel printing options which you'll need specially before you send your file to your boss or save as PDF.

  • Design principles for optimal spreadsheets.

  • Excel charts that go beyond column and bar charts. You'll learn how to create a Pareto chart, Histogram, Treemap, Sunburst charts and more.

  • Excel Pivot Tables so you can quickly get insights from your data.

  • What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets.

  • Use Power Query to transform messy data to tabular data.

    _________________________________________________

WHY WOULD YOU CHOOSE TO LEARN EXCEL?

Excel in itself can do so much for your career. It's just one program but it's the one hiring managers are interested in.

That’s why basic Excel skills is a mandatory requirement for most office-based professionals today.

Superior Microsoft Excel skills can get you a promotion. Some jobs require that to begin with.

_________________________________________________

WHICH VERSION OF EXCEL IS USED IN THE COURSE?

The course is applicable for Excel 2019, Excel 2016 & Excel for Microsoft 365. Generally all features and formulas with exception of a few Excel charts (Histogram, Pareto, Treemap and Sunburst charts) will work on Excel 2010 & Excel 2013. For the Power Query section, you'll have to install the free Excel Power Query add-in if you have Excel 2010 or Excel 2013 to be able to follow along. Other than this, the other features and formulas shown are valid for all Excel versions.

_________________________________________________

★★★★★  "Leila has an extraordinary way of breaking down complex formulas to understand how the mechanics actually work so you start to imagine on your own different combinations of formulas to solve complex questions.” Lisa

★★★★★ “The instructor's explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith

★★★★★ "It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great "hacks" for excel." Teo

★★★★★ "Lots of tips and techniques. Already using them in my own work!" Alison

★★★★★ "I am really enjoying the course, Leila is a great instructor. Every lesson I learn something useful to improve my day to day with excel." Alisa

________________________________________________

There's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work.

The course comes with lifetime access. Buy now. Watch anytime.

Google Sheets: Pivot Tables + Data Insights For Beginners!

Learn to explore data & uncover insights with Google Sheets pivot tables! Course taught by fmr Google Analytical Lead.

Created by Brian Moore - data analytics to inform business decisions

"]

Students: 20799, Price: Free

Students: 20799, Price:  Free

  • Do you have data in Google Sheets and not sure how to make it useful? Then this course is for you!

  • Do you want to get on the path to being Data-Savvy? Then this course is for you!

  • Do you want to grow your Google Sheets data skills? Then this course is for you!

This course has been *designed by a former Google Analytical Lead* so that you can get comfortable going from rows and columns of data in a Google Sheet to useful insights via pivot tables.

This course includes numerous hands-on examples and practice exercises that will get you feeling data-savvy.

As a bonus, practice exercises and lecture examples are included in a spreadsheet that you can keep as part of the course.

This course is broken out into 8 key sections:

  • Section 1: Introduction (what are pivot tables and how they are used in the real-world to surface data insights)

  • Section 2: An Overview of the Data Insights Pivot Table Process

  • Section 3: Applying the Data Insights Pivot Table Process

  • Section 4: Practice Exercises: Set 1 (Titanic Dataset)

  • Section 5: Solution Videos for Practice Exercises: Set 1 (Titanic Dataset)

  • Section 6: Practice Exercises: Set 2 (Red Wine Dataset)

  • Section 7: Solution Videos for Practice Exercises: Set 2 (Red Wine Dataset)

  • Section 8: Course Wrap + Bonus Content

The content has intentionally been curated for practitioners who want to apply learnings right away.

This is NOT a long drawn out course that goes deep in the weeds on academic theory.

Make the transition from decisions based on gut feel to data informed decision making!

Use this efficiently designed course to level up your data skills. Get started today! 

#AlwaysBeLearning

No Nonsense Excel Pivot Tables Pro Course

With real Companies examples learn the best tricks of Excel Pivot Tables in Just 1 Hour. Improve Decision Making Skills.

Created by Javier Polanco - Engineer

"]

Students: 19216, Price: $19.99

Students: 19216, Price:  Paid

Working with large data can be stressful and time consuming, also sometimes you have to dig down too much just to get simple statistics. This course will make you analyze data a lot more quick and efficient using pivot tables. The content of this course will not only make you faster, will make you improve in the decision making process because you will be able to see statistics that are almost impossible to see just using normal tables.

Analyze any type of data using pivot tables with practical examples

  • Format any type of data to create better and cleaner pivot tables.
  • Practice with 6 real life practical examples.
  • Create pivot tables with ease.
  • Group data fields manually to have a better perspective.
  • See your results in percentages, numbers and a lot more formats.
  • Learn how to create and easily use Pivot Charts.
  • Use powerful filters to dig down your data.
  • Customize you original data to create very powerful Pivot Tables.

Quicker than you ever imagine

Pivot Tables are not difficult nor advanced tools, you cannot believe how easy is to create and manipulate them. If you use excel to process any type of data in you personal life, job or any other project, this course will bring you efficient solutions with 6 real life practical examples. 

Contents and overview

Forget theoretical explanations and slow, long and boring examples and learn in just 1 hour, 10 lessons and 6 practical examples everything you need to know about pivot tables. 

The learning method used in this course brings easy and digestible explanations while you work simultaneously with me in every single lesson.  

When you finish the course you will create pivot tables in less than 5 minutes with clean and good quality data, also you will be able to visualize your data with dynamic pivot charts. 

As a bonus you will learn some tips, tricks and hacks, that made me succeed in a lot of problems and situations in my professional experience and will help you more than you imagine in yours. 

Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel

Master 75+ Excel tips to build advanced Excel skills: formulas, pivot tables, charts, data analysis & data visualization

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 19037, Price: $174.99

Students: 19037, Price:  Paid

COURSE DESCRIPTION:

This course is designed to transform everyday people into Excel POWER USERS.

It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.

Unlike most Excel courses, this one is non-linear and constantly evolving. This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis.  Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons.

The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.

The Excel tips and techniques covered in this course fall into six core categories:

  • Excel Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)

  • Excel Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)

  • Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)

  • Excel Visualization Tips (sparklines, filled maps, custom templates, Excel form controls, etc.)

  • Excel Pivot Table Tips (slicers & timelines, custom layouts, value calculations, etc.)

  • Excel Analytics Tips (outlier detection, monte carlo simulation, forecasting, CUBE functions, etc.)

While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).

It's time to start working smarter, not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.

Join today and get immediate, lifetime access to the following:

  • 10+ hours of high-quality video

  • Downloadable PDF ebook

  • Excel project files & solutions

  • Expert-support and Q&A forum

  • 30-day money-back guarantee

Happy learning!

-Chris (Founder, Maven Analytics)

NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

See why this is one of the TOP-RATED Excel courses on Udemy:

"At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!"

- Judit Bekker

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!"

- Ernie Atkins

"I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!"

-Ryan Hughes

Excel Pivot Tables in a Nutshell

Learn how to use Excel Pivot Tables at work plus one killer trick.

Created by Sebastian Glöckner - Diplom-Informatiker, 14 Jahre Vollzeit-Projektmanager

"]

Students: 18661, Price: $89.99

Students: 18661, Price:  Paid

Works with any Excel version!

Do you know why so many people use Pivot Tables in Excel?Many people use pivot tables in their daily work for fast, standardized requests. What does that even mean? Imagine you need to know the total sales of your business broken down to months. You don't need to filter that manually - pivot tables are the perfect tool to give you that answer every time fully automated!

This course contains downloadable xlsx-files attached to the lectures containing the formulas and data shown in the videos!

What you will learn

  • Build up a pivot table in 30 seconds

  • Practice with a more detailed example

  • What to do if you need more than two dimensions (you'll understand when you see it)

  • Advanced killer trick: Pull data from a pivot table into your individual report!

30 day full refund policy + no questions asked! (If bought via Udemy website. If you bought the course via App and are not satisfied, please contact me directly.)

Master Excel Pivot Tables – Excel 2016

Master Microsoft Excel Pivot Tables in an afternoon! Excel 2016, Excel 2013, and Excel 2010 Pivot Tables.

Created by Tom Meservy - Professor and Consultant

"]

Students: 16831, Price: $39.99

Students: 16831, Price:  Paid

Do you want to help your company or organization make better decisions? Do you want to advance your career because you bring real value to the organization? Do you want to save hundreds of hours a year in creating reports and charts? Are you ready to make an impact because you understand the patterns and trends in your company’s data? Do you want to master Excel Pivot Tables? This course is for you!


Master Excel Pivot Tables in this Comprehensive Course

This comprehensive course contains concise illustrations yet detailed topic coverage that will benefit both Beginners and Advanced Users of Excel. In just an hour and a half, you will learn to effectively use Excel Pivot Tables including how to:

  • Create and Format Pivot Tables
  • Select, Move, and Clear Pivot Tables
  • Design Pivot Tables
  • Value Field Settings – Summarize Values By
  • Value Field Settings – Show Values As
  • Filter Data
  • Manually and Automatically Group Data
  • Create Calculated Fields and Items
  • Explore Other Useful Pivot Table Concepts

Learn Pivot Tables by Doing

Learn one of the most powerful features of Excel that will allow you to dig deep into your company’s data and answer complex questions with only a few mouse clicks. Learn to analyze vast amounts of data, create useful reports, and impress top management or prospective employers.

Most that say they know Excel Pivot Tables really only have a grasp on the basics. Within the first 10 minutes of this course, you will likely surpass their knowledge and by the end of the course you will master even some of the most complex aspects of Pivot Tables.

Throughout the course, you can follow along with the numerous concise examples that illustrate the power and features of Pivot Tables using the included worksheets. Further, “homework” examples are provided to allow you to apply these same concepts to another data set so that you can know that you have mastered the concepts.

  • Create pivot tables from data in an existing worksheet and answer basic questions from the data.
  • Summarize pivot table values by sum, count, average, max, min, and other types of calculations.
  • Select different parts of the pivot table, move it within and between worksheets, and clear or reset the contents of the pivot table.
  • Adjust the design aspects of the pivot table including totals, layout, and visual aspects of the pivot table.
  • Adjust pivot table calculations to show the results as a percentage of a total, difference from another field, or other value calculation.
  • Filter data out of the pivot table using various techniques including field filters, table filters, slicers, and timelines.
  • Automatically and manually group results within your pivot table using a variety of approaches.
  • Create and utilize new pivot table fields that are calculated using existing data in the pivot table and new items that consist of formulas that refer to other rows.
  • Appropriately reference pivot table data.
  • Create pivot charts and understand the relationship between pivot charts and pivot tables.
  • And More.

We are professional instructors who have helped thousands of students Master Excel Pivot Tables and become even more effective at work. We invite you to join us on a short journey to advance your career.

Beginners to Expert Excel and Excel VBA 38 Hours Mega Course

Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with our Microsoft Excel 38+ hours tutorial

Created by Mach 42 Productions - Excel Consulting | 21,000+ Students

"]

Students: 15848, Price: $19.99

Students: 15848, Price:  Paid

This comprehensive 38 hours+ Microsoft Excel and Excel VBA course includes content from our Mach 42 Productions Excel courses 1 through 11 and our IT careers course, to take you from beginner to expert level:

  • Excel Course 1- Step By Step Beginners Excel

     

  • Excel Course 2- How To Use Excel comments

     

  • Excel Course 3- Excel Charts And Tips To Make Better Charts

     

  • Excel Course 4- How To Make Waterfall Charts

     

  • Excel Course 5 - Advanced Excel Charts

     

  • Excel Course 6- Automated Excel Charts And Tables

     

  • Excel Course 7- Learn How To Use Excel Text Functions

     

  • Excel Course 8- Advanced Excel tips

     

  • Excel Course 9- Quick Excel Tips For Excel Reports

     

  • Excel Course 10- Advanced Excel Skills And Career Tips

     

  • Excel Course 11- Spreadsheet Protection

     

  • 8 Ways to Further your IT Career

If you are enrolled on any of our above courses, please bear this in mind before considering this one.

 

Our in-depth Excel syllabus takes you from beginner level to advanced level in Excel and will help build you a solid understanding of Excel and use it effectively in your work. Over 38 hours of Excel content is provided in this course including:   

  • How to use the basics of Excel e.g. create new worksheets, copy, cut and paste, the Excel ribbon and how to print documents properly

     

  • How to sort, find and replace Excel data quickly

     

  • How to understand, write, use, audit formulas and coverage of Excel text functions, maths operators and advanced functions including vlookup via worked examples/case studies. We provide hours of material on this to build your confidence levels (11 sections)   

  • Coverage of Excel charts from beginner level to advanced automated charts. We cover charts such as bar charts, line charts, waterfall charts and funnel charts. We also provide tips on how to make better charts.

  • A thorough grounding in Excel Pivot Tables- from scratch. This tool alone can save you a lot of time in your data work.   

  • Essential Excel tips to boost your work and help you make better Excel reports e.g. how to watermark Excel sheets

     

  • How to protect your Excel spreadsheets using Excel’s security model.

  • Excel VBA- We teach from ground up Excel’s powerful VBA programming language which can be used to automate tasks, clean up data (very fast) and overall increase your productivity. Our VBA learning culminates in building real life (and actually useful) programs/macros which you can use in your everyday work. Further the skills taught will enable you to build your own macros. All the source code is provided in our examples in addition to testing your knowledge with assignments and tasks. We have over 7 hours of lecture videos covering Excel VBA.   

  • Excel career tips- Advice on how to write Excel examples for your CV/Resume

Full support is given on this Excel course by means of our course discussion forum, lecture quizzes and tasks/activities are provided right from the start of the course. All Excel workbooks used in the lectures are provided too.   

Remember by picking up essential Excel skills, you can significantly increase your productivity, save time and money and furthermore be confident that you can use one of the most popular office business tools today.

Data Visualization with Excel – Crash Course

Learn Excel for Business. Learn the most useful features of excel to develop dynamic business dashboards and Graphs.

Created by Mobeen Ayub - MBA, Entrepreneur, BI enthusiast, Leadership Trainer

"]

Students: 13273, Price: Free

Students: 13273, Price:  Free

1. Learn to create a database and some excel formulas and shortcuts common for people in Universities and Corporate roles.

2. Learn to create different metrics and KPI's (Key Performance Indicators) from the main database in the form of Pivot Tables which update automatically when you update data in the main table.

3. Learn to visualize data in the database in the form of different charts which automatically update when you update the data in the table.

Lookup Functions, Advanced Charts and Pivot tables

Excel charts and pivotes made it easy

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 11553, Price: Free

Students: 11553, Price:  Free

Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. After you enroll and complete this course, you will be proficient in all kinds of charts in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts. You will be able not only to create these charts in Excel, but also to format them quickly and easily.

This course also provides an in-depth coverage of pivot tables and pivot charts. These are two of the powerful data analysis tools in Excel's arsenal, and they should definitely be mastered by anyone who aspires to becoming an Excel “power user. Pivot Tables and Pivot Charts allow you to dynamically reorganize and display your data in many different ways and they help you get meaningful information from large amounts of data.   

Microsoft Excel Data Analysis: Pivot Tables and Formulas

Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users

Created by James Nissen - Data Analyst

"]

Students: 9889, Price: $19.99

Students: 9889, Price:  Paid

This course will teach you to go from level up from beginner to intermediate in Excel in around 2 hours. You'll learn a wide variety of important Excel features, including Pivot Tables, sorting and filtering, keyboard shortcuts, as well as intermediate functions like VLOOKUP, INDEX & MATCH, IF statements, and many more (2016 PC Version used in course).

Sample data sets provided for you to follow along and learn as you watch!

Excel Deep Dive: Pivot Tables Workshop

Excel data mastery is possible! Learn how to use pivot tables in excel and learn how to use pivot tables to get a raise

Created by Alex Mozes - Instructor Liaison with Udemy

"]

Students: 8744, Price: $94.99

Students: 8744, Price:  Paid

Master Excel Pivot Tables and save the world!

This course discusses one of the most powerful tools of the Office Ninja's arsenal, Excel Pivot Tables and how to use pivot tables. It's potential for analyzing and summarizing data is legnendary, but few have mastered its intricacies. Through a series of easy to follow lessons on how to use pivot table in excel, you will be introduced to the concepts, techniques and powerful features of this mysterious excel tool, and can follow along with each step with the included sample file.

We will cover:

● Pivot Table Concepts

● Creating A Pivot Table

● Modifying Pivot Table Elements

● Filtering Extraneous Data (the Slicer tool)

● Creating Multiple Pivot Tables

● Creating Pivot Charts

● Advanced Analysis Techniques

Learn how to use pivot table in excel today.

Microsoft Excel – 333 Microsoft Excel Keyboard Shortcuts

Learn the must know Excel keyboard shortcut to save time in Excel 2010, Excel 2013, Excel 2016, Excel 2019 & Office 365

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 7604, Price: Free

Students: 7604, Price:  Free

You’re Just Seconds Away From Leveraging Microsoft Excel That Will Make It Possible For YOU To:

  1. Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

If you want to get better at Excel and stand out from the crowd to get the promotions or pay-rises that you deserve, then you are in the right place!

This is the most comprehensive Excel Keyboard Shortcuts course ever made which has 333 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single Excel shortcut that is available inside Microsoft Excel.  The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

If you learn only 5 Excel keyboard shortcuts and apply them each day, you will SAVE HOURS each week, which means you can go home early for once!

There are 15 different modules so you can work on your weaknesses and enhance your strengths as well as practice files, quizzes and a FREE PDF Cheat Sheet listing all 333 Excel Keyboard Shortcuts for Windows & Mac that you can print off and keep. 

Here are the main keyboard shortcut topics that we will cover in this course:

  1. Cell Formatting

  2. Drag & Drop

  3. Formulas & Functions

  4. Frequent  shortcuts

  5. Function Key   

  6. Making selections

  7. Ribbon Tab

  8. Cell Navigation

  9. Inside Ribbon 

  10. Macros & VBA

  11. Pivot Tables 

  12. Power BI 

  13. Power Pivot

  14. Other Shortcuts   

----------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year…

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Excel Pivot Tables for Management Consultants & Analysts

Practical guide how to do data and business analyses using Pivot Tables during consulting projects

Created by Asen Gyczew - Expert in performance improvement, turnaround and startups

"]

Students: 7385, Price: $89.99

Students: 7385, Price:  Paid

What is the aim of this course?   

Excel is the most often used the first-choice tool of every business analyst and consultant. Maybe it is not the fanciest or sophisticated one, yet it is universally understood by everybody especially your boss and your customers.    

Excel is still a pretty advanced solution with a countless number of features and functions. One of the most useful Excel tools is the Pivot Tables that help you do fast and efficiently data analyses. In this course, I will show you how to use the full potential of Pivot Tables during consulting projects. This course is organized around the 80/20 rule and I want to teach you the most useful (from a business analyst/consultant perspective) features of Pivot Tables as fast as possible. I want you also to acquire thanks to the course good habits in Excel that will save you loads of time.   

If done properly, this course will transform you in 1 day into a pretty good business analyst that knows how to use Pivot Tables Excel in a smart way. It is based on my 14 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement, and turn-arounds in the biggest companies from FMCG, SMG, B2B sectors that I worked for.  On the basis of what you will find in this course, I have trained in person over 100 business analysts who now are Investment Directors, Senior Analyst, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 88 000 students including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others   

I teach step by step on the basis of Excel files that will be attached to the course. To make the most out of the course you should follow my steps and repeat what I do with the data after every lecture. Don’t move to the next lecture if you have not done what I show in the lecture that you have gone through.   

I assume that you know basic Excel so the basic features (i.e. how to write formulas in Excel) are not explained in this course. I concentrate on intermediate and advanced solutions and purposefully get rid of some things that are advanced yet later become very inflexible and useless (i.e. naming the variables). In the end, I will show full-blown analyses using Pivot Tables that use the tricks that I show in the lectures.   

For every lecture, you will find attached  (in additional resources) the Excel files shown in the lectures. In this way, as a part of this course, you will also get a library of ready-made analyses that can, with certain modifications, be applied by you in your work.   

   

Why have I decided to create this course?   

I have done a number of courses showing you how to analyze data in Excel. Yet, I have noticed that some students lack the fluency of operations in Excel, especially when it comes to Pivot Tables. This course is designed to fill in the gap and help you fully appreciate my other courses for business analysts and consultants. It can be used also as a standalone course that will help you to be smart with Excel Pivot Tables. I recommend it especially to people that have to work in Excel 2-3 hours a day or want to become management consultants.   

                                                        

In what way will you benefit from this course?   

The course is a practical, step-by-step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you do the analyses using Pivot Tables as well as the quality of the conclusions coming out of available in your company data. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:   

  • How to use Pivot Tables in practice?   

  • How to calculate things directly in Pivot Tables  

  • How to draw conclusions from analyses – chosen examples of analyses   

  • How to improve the look & feel of Pivot Tables and Pivot Charts   

  • How to use Pivot Charts to present the data & conclusions   

You can also ask me any question either through the discussion mode or by messaging me directly.

     

How the course is organized?  

The course is divided currently into the following sections:   

  • Introduction. We begin with a little intro to the course    

  • Basic Usage of Pivot Tables. In this section, I will show you the most important features of Pivot Tables that will drastically increase the speed of your data analysis. We will discuss how to build Pivot Table, Pivot Chart, how to replaces Pivot Tables with some other functions. We will also go through an example of an analysis done using Pivot Table   

  • Calculation in the Pivot Tables. Quite often you want to do a lot of calculations on the basis of the original data. You can do it in the original table or directly in the Pivot Table. In this section, you will learn how to do it in the Pivot Tables. We will discuss the calculation field, “show as…” option, and many others.   

  • Other useful pre-defined options. Pivot tables have many predefined options such as sorting, filtering, changing source data, adding new variables, etc. We will discuss them in this section and will show you some examples of how to use them in practice.   

  • Improving the look and feel of the table. In this section, I will show you how to improve the look and feel of the Pivot Tables.   

  • Pivot Charts. In this section, I will go into details when it comes to Pivot Charts. I will also show you how to create a Dashboard using Pivot Charts and slicers.    

  • Examples of analysis using Pivot Tables. Here I will show examples of real-life data analyses using Pivot Tables   

We will be adding new sections in the coming months 

You will be able also to download many additional resources   

  • Excels with analyses shown in the course

  • Links to additional presentations and movies

  • Links to books worth reading

   

At the end of my course, students will be able to…  

  • You will master the most crucial functions and features of Excel Pivot Tables

  • Understand the main challenges in analyzing data with Pivot Tables

  • Do calculation directly in the Pivot Table without impacting the original data set

  • Perform the analyses in a very effective manner

  • Build Dashboards using Pivot Tables and Charts

Who should take this course? Who should not?

  • Business analysts

  • Consultants

  • Students that want to work in Management Consultants

  • Researchers

  • Students that want to work in Private Equity

  • Controllers

  • Small and medium business owners

  • Startups founders

Excel Data Analytics With Pivot Tables & Pivot Charts – 2021

Data analysis excel, data analysis, Pivot Chart, Microsoft excel, advanced excel, ms excel, Data Analytics, Excel, Data

Created by A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office) - 200,000+ Students | 4+ Rated | 190 + Countries

"]

Students: 6329, Price: $19.99

Students: 6329, Price:  Paid

Eight Reasons why you should choose this Excel Data Analytics With  Tables and Pivot Charts Course

  1. You will learn various data analysis techniques using MS Excel

  2. Latest updated and Doubts Are Solved in this course

  3. Carefully designed curriculum By Proficient In Microsoft Excel Expert

  4. you can complete this course In Short time

  5. Pivot table & Pivot charts related examples and case studies Provided

  6. Practical Examples And practice exercises Are Able to Download in The Recourse Section

  7. Your queries will be responded by the Instructor With In Short time

  8. A Verifiable Certificate will Be Provided On the Completion

Excel Pivot Tables & Pivot Charts are an absolutely Fundamental tool for anyone working with data in Excel. Pivots Table allow you to quickly explore and analyze raw data in Excel. It is powerful tools to analyze Excel Data in Different perspective. Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep & comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you how to use Excel Pivot Tables & Pivot charts and introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way. After Completing This Course Your Are Able To Create Interactive & Visually Effective Pivot Charts Based On Your Pivot Table.

What is covered in this course?

Chapter -01 Introduction Of Data Analytics With Pivot Tables & Charts

  • Introduction Of Data Analytics

  • Introduction Of Pivot Table And Pivot Charts

Chapter -02 The Five Steps For Data Analytics With Pivot Tables And Charts

  • The Five Steps For Data Analytics With Pivot Table And Pivot Charts

  • Chapter -03 Pivot Table & Pivot Chart Example -01

  • Data Analytics With Pivot Table & Pivot Chart Example-01

Chapter -03 Data Analytics With Pivot tables & Pivot Charts Example -01

  • Introduction Of Data Analytics With Pivot tables & Pivot Charts Example -01

Chapter -04 Format The Raw Data For Pivot Tables (Step 01)

  • Format The Raw Data For Pivot Tables

  • Insert New Column

Chapter -05 Convert The Raw Data To Table (Step 02)

  • Create Pivot Table By Using Range

  • Convert Raw Data To Table

  • Modify The Table

Chapter -06 Create Pivot Tables (Step-03)

  • Create Pivot Table

  • Create Recommended Pivot Table

  • Change Pivot Table Name & Design

  • Pivot Table Builder & Clear & Rearrange

  • Copy , Move And Delete The Pivot Table.

  • Creating Groups In Pivot Table – Date Group

  • Creating Groups In Pivot Table – Number Group

  • Custom Calculation In Pivot Table.

  • Sorting , Filtering In Pivot Table.

  • Working With Slicer.

  • Update The Data In Pivot Table.

Chapter -07 Create Pivot Charts (Step-04)

  • Create Pivot Table For Pivot Chart

  • Create Line Charts.

  • Create Bar Charts.

  • Create Column Charts.

  • Create Pie Charts.

  • Insert Slicers & Connect With Reports

Chapter -08 Analysis The Pivot Table & Pivot Charts (Step-05)

  • Analysis The Pivot Table & Pivot Charts

Chapter -09 Pivot Table & Pivot Chart Example-02

  • Introduction Of Question

  • Answer Question 1 & 2

  • Answer Question 3

  • Answer Question 4 & 5 & 6

  • Answer Question 7

  • Answer Question 8

Pivot Tables Playground for Business Users

Learn to use Pivot Tables to produce Business Insights and semi automate the reports.

Created by Kunaal Naik - Data Science Instructor and Marketing Adviser at Dell

"]

Students: 3721, Price: Free

Students: 3721, Price:  Free

As a Business user, you might often feel overwhelmed by the number of requests you can handle at a time. Sometimes you wished there were more hours in a day to work them out correctly and at the same time provide insights.

In this Pivot Table series for Power Business users, you will learn smart tips and tricks to get to a solution quickly using Excel Pivot tables and semi-automate your reporting to answer same questions faster in the future repeatedly. Also, we will learn how to build Dashboards which are easy to make and simple to use.

Fundamental Excel Skills for Accountants and Finance Staff

Learn the core fundamental Excel skills every Accountant or Finance Professional should have

Created by Paula Guilfoyle CPA & MVP - Microsoft MVP, CPA Accountant, & Life Long Learner

"]

Students: 3328, Price: Free

Students: 3328, Price:  Free

Are you an Accountant or an aspiring Accountant?  Do you work in Finance?  Do you want to ensure you are equipped with the core fundamental Excel skills that every accountant or financial professional should have? well if so this course has been designed for you.

Excel is the tool of choice for most accountants, and having great Excel Skills can make a massive difference in your career prospects.  However many are lacking the core fundamental skills Excel required to use the tool efficiently. 

This course has been designed and developed by an accountant and focuses on the core Excel skills needed in the industry.  Some of these skills are at a basic level, however, some of them are at an advanced level. Each of the topics covered in this course is a core skill for the job and knowing some of the newer features of Excel 365 will put you ahead of the curve.

This course is a short course and a basic knowledge of Excel is required.  In this course, you will find workbooks to download so you can practice along and you will also find some activities to complete.

The topics covered in this course are

  1. Logical tests and IF statements.

  2. Lookup Formulas

  3. Summing with criteria

  4. Working with tables

  5. Pivot tables

  6. Dynamic arrays

Learn Five Useful Excel Techniques

Excel Techniques

Created by Manoj Chandak - Freelancer Trainer and Consultant

"]

Students: 2564, Price: Free

Students: 2564, Price:  Free

Student will get understanding of five very useful techniques in excel and their practical applications from real life examples.

These techniques are:

1. Sorting

2. Filtering

3. Absolute referencing and by cell name

4. Data Visualization using various Excel charts

5. Data analysis using Pivot Table

After going through this course, the student will get broader understanding of these techniques to boost up their excel task productivity.

Complete Introduction to Excel Pivot Tables and Pivot Charts

Learn to analyze & summarize data in seconds using Excel's most powerful data feature - Pivot Tables & Pivot Charts!

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 2509, Price: $99.99

Students: 2509, Price:  Paid

Recent reviews:

"I would rate the course a 4.8 out of 5.0 I Iike the fact that the instructor applies pivot tables to business situations. I love that he gives a video solution to all the problems and not just give the answers He shows us how to solve the homework. BUY HIS COURSE!"

"I just passed my Excel 70-779 test to complete my BI Solutions MCSA . Thank you Ian...watched all your videos on here for both tests."

"Really good informative course, at the right pace, I'm substantially increasing my excel know for data and pivot tables, I would highly recommend."

**** Life time access to course materials and practice activities. ****

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. 

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn the INCREDIBLE power of Pivot Tables to analyze and summarize data in seconds.  Pivot Tables are without doubt the most powerful feature in Microsoft Excel. 

In this class (the last module of my 3 part "Excel Master Class" Series), you will cover:

  1. Introduction and Course Content

  2. Creating Pivot Tables

  3. Methods of Aggregation and Grouping

  4. Trend Analysis

  5. Filtering and Slicing Pivot Tables

  6. Show Value As Calculations

  7. Frequency Analysis

  8. Conditional Formatting

  9. Interactive Dashboards

  10. Excel and Power BI

We look forward to having you on our course as we learn and explore the incredible power of Excel Pivot Tables and Pivot Charts.

Please note that this course is the third course in a series of three courses for the Excel Master Class series.  Search for my instructor profile to purchase these other courses.

  1. Course 1 - Power Query - Prepare and Transform Data

  2. Course 2 - Power Pivot - Data Modeling and DAX Formulas

  3. Course 3 - Pivot Tables and Pivot Charts