HOT
blank

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

Office Productivity

Rating4.7
Enroll Now

Pivot Tables, Power Pivot Tables, Power Query & Power BI, available at $109.99, has an average rating of 4.65, with 403 lectures, 28 quizzes, based on 2208 reviews, and has 32987 subscribers.

You will learn about Become more PRODUCTIVE at using Microsoft Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work! We teach you how to use Microsoft Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS! Increase your Microsoft Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers! COURSE #1: Learn ALL the Pivot Table features: Slicers, Pivot Charts, Filtering, Grouping, Sorting, Dashboards, Data Analysis, Calculated Fields plus MORE! COURSE #2: Learn Power Pivot, DAX Formulas, Measures, Calculated Columns & Table Relationships! COURSE #3: Learn Power Query (Get & Transform), import & transform your data, consolidate from multiple workbooks, folders, worksheets plus MORE! COURSE #4: Learn Power BI and create interactive Dashboards that tell a story about your data! COURSE #5: 333 Excel Keyboard Shortcuts explained, covering Formatting, Ribbon, Formulas, VBA, Pivot Tables, Power BI plus MORE! 7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!! ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! DOWNLOADABLE Excel workbooks so you can keep on your desktop & practice! Test your skills with various real life Quizzes & Homework Practice Activities & Assignments! Personal Excel support from Professional Excel Trainers with 30+ Years of combined Excel Training! This course is ideal for individuals who are People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE! or People who want to change career and apply for a new job or If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course! It is particularly useful for People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE! or People who want to change career and apply for a new job or If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!.

Enroll now: Pivot Tables, Power Pivot Tables, Power Query & Power BI

Summary

Title: Pivot Tables, Power Pivot Tables, Power Query & Power BI

Price: $109.99

Average Rating: 4.65

Number of Lectures: 403

Number of Quizzes: 28

Number of Published Lectures: 402

Number of Published Quizzes: 28

Number of Curriculum Items: 434

Number of Published Curriculum Objects: 433

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

  • Become more PRODUCTIVE at using Microsoft Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
  • We teach you how to use Microsoft Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
  • Increase your Microsoft Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
  • COURSE #1: Learn ALL the Pivot Table features: Slicers, Pivot Charts, Filtering, Grouping, Sorting, Dashboards, Data Analysis, Calculated Fields plus MORE!
  • COURSE #2: Learn Power Pivot, DAX Formulas, Measures, Calculated Columns & Table Relationships!
  • COURSE #3: Learn Power Query (Get & Transform), import & transform your data, consolidate from multiple workbooks, folders, worksheets plus MORE!
  • COURSE #4: Learn Power BI and create interactive Dashboards that tell a story about your data!
  • COURSE #5: 333 Excel Keyboard Shortcuts explained, covering Formatting, Ribbon, Formulas, VBA, Pivot Tables, Power BI plus MORE!
  • 7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!!
  • ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)!
  • DOWNLOADABLE Excel workbooks so you can keep on your desktop & practice!
  • Test your skills with various real life Quizzes & Homework Practice Activities & Assignments!
  • Personal Excel support from Professional Excel Trainers with 30+ Years of combined Excel Training!

Who Should Attend

  • People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
  • People who want to change career and apply for a new job
  • If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Target Audiences

  • People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
  • People who want to change career and apply for a new job
  • If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

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 SKILLSand KNOWLEDGEwithin HOURSwhich will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVEat using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESSat work!

  3. Use Excel Pivot Tables with CONFIDENCEthat will lead to greater opportunities like a HIGHER SALARYand 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 noticedby 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 Accessand 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 featuressuch 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 shortcutsand apply them each day, you will SAVE HOURS each week, which means you can go home early for once!

There are 15 different modulesso 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 & Macthat 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 ADVANCINGyour Microsoft Excel level & skills…

…saving HOURSeach day, DAYSeach week and WEEKSeach year and eliminating STRESSat work…

…If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHERsalary and KNOWLEDGEthat 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 ***

Course Curriculum

Lecture 1: COURSE INTRODUCTION

Lecture 2: A MESSAGE FROM YOUR INSTRUCTOR – JOHN MICHALOUDIS

Lecture 3: EXCEL WORKBOOKS – IMPORTANT INSTRUCTIONS (PLEASE READ)

Lecture 4: HANDOUT #1: COURSE TRACKER EXCEL WORKBOOK [FREE EXCEL WORKBOOK DOWNLOAD]

Lecture 5: HANDOUT #2: PIVOT TABLE CHEAT SHEET [FREE PDF DOWNLOAD]

Lecture 6: HANDOUT #3: 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE [FREE PDF DOWNLOAD]

Lecture 7: HANDOUT #4: 101 READY MADE EXCEL TEMPLATES [FREE EXCEL WORKBOOKS DOWNLOAD]

Lecture 8: HANDOUT#5: 50+ EXCEL KEYBOARD SHORTCUTS IN A KEYBOARD LAYOUT [FREE PDF DOWNLOAD]

Chapter 1: PIVOT TABLES: DESIGN & CUSTOMIZE YOUR PIVOT TABLE

Lecture 1: WORKBOOKS

Lecture 2: ARRANGING YOUR DATA SET ~ Tabular Format

Lecture 3: ARRANGING YOUR DATA SET ~ No Gaps

Lecture 4: ARRANGING YOUR DATA SET ~ Formatting

Lecture 5: ARRANGING YOUR DATA SET ~ Tables

Lecture 6: ARRANGING YOUR DATA SET ~ TIP: Clean Your Data Set

Lecture 7: CREATING A PIVOT TABLE ~ Inserting a Pivot Table

Lecture 8: CREATING A PIVOT TABLE ~ Field List – Activate, move, resize & layout

Lecture 9: CREATING A PIVOT TABLE ~ Field List & Areas

Lecture 10: CREATING A PIVOT TABLE ~ Drill down to audit

Lecture 11: CREATING A PIVOT TABLE ~ Sort Field List from A to Z

Lecture 12: CREATING A PIVOT TABLE ~ TIP: Double click on any labels to show more Fields

Lecture 13: CREATING A PIVOT TABLE ~ TIP: Defer Layout Update

Lecture 14: OPTIONS > DATA ~ Pivot Cache explained

Lecture 15: OPTIONS > DATA ~ Refresh

Lecture 16: OPTIONS > DATA ~ Refresh All

Lecture 17: OPTIONS > DATA ~ Refresh External Data

Lecture 18: OPTIONS > DATA ~ Import from Access database

Lecture 19: OPTIONS > DATA ~ Change Data Source

Lecture 20: OPTIONS > ACTIONS ~ Clear Filters & Clear Pivot

Lecture 21: OPTIONS > ACTIONS ~ Select & format

Lecture 22: OPTIONS > ACTIONS ~ Move a Pivot Table

Lecture 23: DESIGN > STYLES ~ Pivot Table Styles

Lecture 24: DESIGN > STYLES ~ Customising a Pivot Table Style

Lecture 25: DESIGN > STYLES ~ Use a customised style in another workbook

Lecture 26: DESIGN > LAYOUT ~ Subtotals

Lecture 27: DESIGN > LAYOUT ~ Grand Totals

Lecture 28: DESIGN > LAYOUT ~ Report Layouts

Lecture 29: DESIGN > LAYOUT ~ Blank Rows

Lecture 30: DESIGN > LAYOUT ~ TIP: Show the Classic Pivot Table Layout

Lecture 31: OPTIONS > SHOW ~ Expand & Collapse buttons

Lecture 32: OPTIONS > SHOW ~ Move & Remove Fields and Items

Lecture 33: OPTIONS > SHOW ~ Show/Hide Field List

Lecture 34: OPTIONS > SHOW ~ Show/Hide Field Headers

Lecture 35: CUSTOMISATION ~ Change "Count of" to "Sum of"

Lecture 36: CUSTOMISATION ~ Number formatting

Lecture 37: CUSTOMISATION ~ Field name formatting

Lecture 38: CUSTOMISATION ~ TIP: Predetermined number formatting

Lecture 39: CUSTOMISATION ~ TIP: Change Sum views in Label areas

Lecture 40: LAYOUT & FORMAT ~ Indent rows in compact layout

Lecture 41: LAYOUT & FORMAT ~ Change the layout of a report filter

Lecture 42: LAYOUT & FORMAT ~ Format error values

Lecture 43: LAYOUT & FORMAT ~ Format empty cells

Lecture 44: LAYOUT & FORMAT ~ Keep column widths upon refresh

Lecture 45: LAYOUT & FORMAT ~ TIP: Automatic Refresh a Pivot Table

Lecture 46: LAYOUT & FORMAT ~ TIP: Printing a pivot table on two pages

Lecture 47: LAYOUT & FORMAT ~ TIP:Show report filter on multiple pages

Lecture 48: Course Review

Lecture 49: HOMEWORK: SET UP A PIVOT TABLE

Chapter 2: PIVOT TABLES: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

Lecture 1: WORKBOOKS

Lecture 2: Create multiple subtotals

Lecture 3: Count

Lecture 4: Average

Lecture 5: Maximum

Lecture 6: Minimum

Lecture 7: Product

Lecture 8: Count Numbers

Lecture 9: Std Dev

Lecture 10: Varp

Lecture 11: PRO PIVOT TABLE TIP: Show various Grand Totals

Lecture 12: PRO PIVOT TABLE TIP: Shortcuts to Field & Value Field Settings

Lecture 13: PRO PIVOT TABLE TIP: See all pivot Items

Lecture 14: PRO PIVOT TABLE TIP: Show a unique count

Lecture 15: HOMEWORK: SUMMARIZE VALUES BY

Chapter 3: PIVOT TABLES: VALUE FIELD SETTINGS > SHOW VALUES AS

Lecture 1: WORKBOOKS

Lecture 2: % of Grand Total

Lecture 3: % of Column Total

Lecture 4: % of Row Total

Lecture 5: % Of

Lecture 6: % of Parent Row Total (NEW IN EXCEL 2010)

Lecture 7: % of Parent Column Total (NEW IN EXCEL 2010)

Lecture 8: % of Parent Total (NEW IN EXCEL 2010)

Lecture 9: Difference From

Lecture 10: % Difference From

Lecture 11: Running Total in

Lecture 12: % Running Total in (NEW IN EXCEL 2010)

Lecture 13: Rank Smallest to Largest (NEW IN EXCEL 2010)

Lecture 14: Rank Largest to Smallest (NEW IN EXCEL 2010)

Lecture 15: Index

Lecture 16: PRO PIVOT TABLE TIP: Shortcuts to Show Values As

Lecture 17: CASE STUDY ~ ACCOUNTING: % of Revenue Margins

Lecture 18: CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report

Lecture 19: HOMEWORK: SHOW VALUES AS

Chapter 4: PIVOT TABLES: GROUPING

Lecture 1: WORKBOOKS

Lecture 2: Group by Date

Instructors

Rating Distribution

  • 1 stars: 18 votes
  • 2 stars: 42 votes
  • 3 stars: 214 votes
  • 4 stars: 714 votes
  • 5 stars: 1220 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Chatgpt And Ai Tools Courses to Learn in November 2024

Top 10 Excel Vba Courses to Learn in November 2024

Train the Trainer Pro: No Beginners Allowed!