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

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

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 ***

Who this course is 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!
  • 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!

Expected Outcomes

  1. 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, Conditional Formatting, Macros, Dashboards, Data Analysis, GETPIVOTDATA, Calculated Fields, Formatting 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! Show more Show less Requirements Excel for Windows 2007, 2010, 2013, 2016, 2019, Office 365 and Excel for Mac 2011 and 2016 This course is for Excel Beginners, Intermediates or Advanced Users No prior Microsoft Excel knowledge is required Description 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: Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers! Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work! 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: CUSTOMIZE YOUR PIVOT TABLE VALUE FIELD SETTINGS > SUMMARIZE VALUES BY VALUE FIELD SETTINGS > SHOW VALUES AS GROUPING SORTING FILTERING SLICERS CALCULATED FIELDS & ITEMS PIVOT CHARTS CONDITIONAL FORMATTING GETPIVOTDATA Formula MACROS DATA MANAGEMENT BONUS VIDEOS NEW EXCEL 2013 PIVOT TABLE FEATURES NEW EXCEL 2016 PIVOT TABLE FEATURES 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: IMPORT/LOAD DATA TABLE RELATIONSHIPS PIVOT TABLES & SLICERS INTRO TO DAX FORMULAS 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 Clean & transform lots of data quickly Import data from various external sources, folders & Excel workbooks Consolidate data with ease Sort & Filter data Merge data Join data Data shaping & flat files Auto cleanup your data 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 Text Function Logical and Lookup Functions Text to Columns Find & Remove Duplicates Conditional Formatting Find & Replace Go to Special 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: Introduction to Power BI Creating a Power BI Dashboard 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: Cell Formatting Drag & Drop Formulas & Functions Frequent shortcuts Function Key Making selections Ribbon Tab Cell Navigation Inside Ribbon Macros & VBA Pivot Tables Power BI Power Pivot 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 *** Who this course is 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! 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! Show more Show less Course content 38 sections • 402 lectures • 18h 27m total length Expand all sections COURSE INTRODUCTION 8 lectures • 8min COURSE INTRODUCTION Preview 03:54 A MESSAGE FROM YOUR INSTRUCTOR - JOHN MICHALOUDIS Preview 03:38 EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ) 00:30 HANDOUT #1: COURSE TRACKER EXCEL WORKBOOK [FREE EXCEL WORKBOOK DOWNLOAD] Preview 00:13 HANDOUT #2: PIVOT TABLE CHEAT SHEET [FREE PDF DOWNLOAD] Preview 00:00 HANDOUT #3: 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE [FREE PDF DOWNLOAD] Preview 00:00 HANDOUT #4: 101 READY MADE EXCEL TEMPLATES [FREE EXCEL WORKBOOKS DOWNLOAD] Preview 00:00 HANDOUT#5: 50+ EXCEL KEYBOARD SHORTCUTS IN A KEYBOARD LAYOUT [FREE PDF DOWNLOAD] Preview 00:00 PIVOT TABLES: DESIGN & CUSTOMIZE YOUR PIVOT TABLE 49 lectures • 1hr 24min WORKBOOKS 00:02 ARRANGING YOUR DATA SET ~ Tabular Format Preview 02:17 ARRANGING YOUR DATA SET ~ No Gaps 02:23 ARRANGING YOUR DATA SET ~ Formatting 01:20 ARRANGING YOUR DATA SET ~ Tables 02:38 ARRANGING YOUR DATA SET ~ TIP: Clean Your Data Set 02:11 CREATING A PIVOT TABLE ~ Inserting a Pivot Table Preview 03:14 CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout 01:33 CREATING A PIVOT TABLE ~ Field List & Areas 05:18 CREATING A PIVOT TABLE ~ Drill down to audit Preview 01:35 CREATING A PIVOT TABLE ~ Sort Field List from A to Z 00:37 CREATING A PIVOT TABLE ~ TIP: Double click on any labels to show more Fields 00:46 CREATING A PIVOT TABLE ~ TIP: Defer Layout Update 00:48 OPTIONS > DATA ~ Pivot Cache explained 00:53 OPTIONS > DATA ~ Refresh 01:12 OPTIONS > DATA ~ Refresh All 02:20 OPTIONS > DATA ~ Refresh External Data 04:51 OPTIONS > DATA ~ Import from Access database 02:19 OPTIONS > DATA ~ Change Data Source 03:03 OPTIONS > ACTIONS ~ Clear Filters & Clear Pivot 01:10 OPTIONS > ACTIONS ~ Select & format 03:08 OPTIONS > ACTIONS ~ Move a Pivot Table 00:53 DESIGN > STYLES ~ Pivot Table Styles 03:35 DESIGN > STYLES ~ Customising a Pivot Table Style 04:05 DESIGN > STYLES ~ Use a customised style in another workbook 01:20 DESIGN > LAYOUT ~ Subtotals 00:48 DESIGN > LAYOUT ~ Grand Totals 00:54 DESIGN > LAYOUT ~ Report Layouts 02:41 DESIGN > LAYOUT ~ Blank Rows 00:32 DESIGN > LAYOUT ~ TIP: Show the Classic Pivot Table Layout 01:00 OPTIONS > SHOW ~ Expand & Collapse buttons 04:19 OPTIONS > SHOW ~ Move & Remove Fields and Items 02:32 OPTIONS > SHOW ~ Show/Hide Field List 00:20 OPTIONS > SHOW ~ Show/Hide Field Headers 00:19 CUSTOMISATION ~ Change "Count of" to "Sum of" 01:01 CUSTOMISATION ~ Number formatting 01:34 CUSTOMISATION ~ Field name formatting 02:09 CUSTOMISATION ~ TIP: Predetermined number formatting 01:21 CUSTOMISATION ~ TIP: Change Sum views in Label areas 00:44 LAYOUT & FORMAT ~ Indent rows in compact layout 00:52 LAYOUT & FORMAT ~ Change the layout of a report filter 01:18 LAYOUT & FORMAT ~ Format error values 00:42 LAYOUT & FORMAT ~ Format empty cells 01:20 LAYOUT & FORMAT ~ Keep column widths upon refresh 00:46 LAYOUT & FORMAT ~ TIP: Automatic Refresh a Pivot Table 00:48 LAYOUT & FORMAT ~ TIP: Printing a pivot table on two pages 01:13 LAYOUT & FORMAT ~ TIP:Show report filter on multiple pages Preview 02:15 CUSTOMIZE YOUR PIVOT TABLE 3 questions Course Review 00:47 HOMEWORK: SET UP A PIVOT TABLE 00:14 PIVOT TABLES: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY 15 lectures • 39min WORKBOOKS 00:02 Create multiple subtotals Preview 01:36 Count 02:19 Average 02:36 Maximum 01:55 Minimum 01:19 Product 03:31 Count Numbers 02:26 Std Dev 06:59 Varp 03:28 PRO PIVOT TABLE TIP: Show various Grand Totals 02:28 PRO PIVOT TABLE TIP: Shortcuts to Field & Value Field Settings 02:12 PRO PIVOT TABLE TIP: See all pivot Items 05:52 PRO PIVOT TABLE TIP: Show a unique count 02:29 VALUE FIELD SETTINGS > SUMMARIZE VALUES BY 3 questions HOMEWORK: SUMMARIZE VALUES BY 00:14 PIVOT TABLES: VALUE FIELD SETTINGS > SHOW VALUES AS 19 lectures • 49min WORKBOOKS 00:02 % of Grand Total 02:01 % of Column Total 02:08 % of Row Total 01:47 % Of 03:56 % of Parent Row Total (NEW IN EXCEL 2010) 03:12 % of Parent Column Total (NEW IN EXCEL 2010) 02:16 % of Parent Total (NEW IN EXCEL 2010) 02:44 Difference From Preview 04:47 % Difference From 04:11 Running Total in 02:13 % Running Total in (NEW IN EXCEL 2010) 02:51 Rank Smallest to Largest (NEW IN EXCEL 2010) 02:14 Rank Largest to Smallest (NEW IN EXCEL 2010) 02:14 Index 03:38 PRO PIVOT TABLE TIP: Shortcuts to Show Values As 01:08 CASE STUDY ~ ACCOUNTING: % of Revenue Margins 02:31 CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report 04:43 VALUE FIELD SETTINGS > SHOW VALUES AS 3 questions HOMEWORK: SHOW VALUES AS 00:14 PIVOT TABLES: GROUPING 19 lectures • 46min WORKBOOKS 00:02 Group by Date 02:37 Group by Months 01:43 Group by Quarters & Years 01:41 Group by Sales ranges Preview 03:11 Group by Text fields 02:09 Group by Time 01:38 PRO PIVOT TABLE TIP: Shortcuts to Grouping 01:32 PRO PIVOT TABLE TIP: Grouping by Half Years 01:48 PRO PIVOT TABLE TIP: Group by a Date that starts on a Monday 01:53 PRO PIVOT TABLE TIP: Grouping by a custom date 01:41 PRO PIVOT TABLE TIP: Group by fiscal years & quarters 06:29 PRO PIVOT TABLE TIP: Errors when grouping by dates 02:46 PRO PIVOT TABLE TIP: Group two pivot tables independently 03:52 PRO PIVOT TABLE TIP: Fixing the problem of counting grouped sales 00:38 PRO PIVOT TABLE TIP: Display dates that have no data 00:52 CASE STUDY ~ ACCOUNTING: Quarterly Comparative Report 06:37 CASE STUDY ~ FINANCIAL: Min & Max Bank Balance 04:35 GROUPING 3 questions HOMEWORK: GROUPING 00:14 PIVOT TABLES: SORTING 11 lectures • 13min WORKBOOKS 00:02 Sorting by Largest or Smallest 01:51 Sort an Item Row (Left to Right) 01:24 Sort manually (drag, write, right click) 02:01 Sort using a Custom List Preview 03:13 Override a Custom List sort 01:20 Sort row from A-Z and sales from Z-A 01:16 PRO PIVOT TABLE TIP: Sort new items added to your data source 01:11 PRO PIVOT TABLE TIP: Clear a sort 00:21 PRO PIVOT TABLE TIP: Sort Largest to Smallest Grand Totals 00:19 SORTING 3 questions HOMEWORK: SORTING 00:14 PIVOT TABLES: FILTERING 21 lectures • 43min WORKBOOKS 00:02 Filter by Dates 06:41 Filter by Labels - Text 02:35 Filter by Labels - Numerical Text 02:44 Filter by Values 03:50 Filter by Values - Top or Bottom 10 Items 02:06 Filter by Values - Top or Bottom % Preview 01:39 Filter by Values - Top or Bottom Sum 01:42 Filter by Report Filter 03:31 PRO PIVOT TABLE TIP: Shortcuts to filters 01:36 PRO PIVOT TABLE TIP: Keep or hide selected items 00:57 PRO PIVOT TABLE TIP: Filter by Text wildcards * and ? 03:19 PRO PIVOT TABLE TIP: Filter by multiple fields 01:00 PRO PIVOT TABLE TIP: Apply multiple filters 01:45 PRO PIVOT TABLE TIP: Filter by multiple values 01:06 PRO PIVOT TABLE TIP: Include new items in manual filter 01:50 PRO PIVOT TABLE TIP: Clear filters with one click 01:30 PRO PIVOT TABLE TIP: Add a filter for the column items 00:33 CASE STUDY ~ ACCOUNTING: Top 5 Expenses report 02:22 CASE STUDY ~ FINANCIAL: Top 25% of Channel Partners 02:11 FILTERING 3 questions HOMEWORK: FILTERING 00:14 PIVOT TABLES: SLICERS (NEW FROM EXCEL 2010) 16 lectures • 48min WORKBOOKS 00:02 Insert a Slicer Preview 03:54 Slicer Styles 02:18 Creating a custom style 05:30 Copy a custom style into a new workbook 01:33 Slicer Settings 04:42 Slicer Size & Properties 02:56 Slicer Connections for multiple pivot tables Preview 03:16 PRO PIVOT TABLE TIP: Different ways to filter a Slicer 01:22 PRO PIVOT TABLE TIP: Use one slicer for two pivot tables 01:19 PRO PIVOT TABLE TIP: Lock the workbook but not the slicer 01:25 PRO PIVOT TABLE TIP: Interactive employee photos with Slicers! FUN! 09:20 CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer 04:13 CASE STUDY ~ FINANCIAL: Base, Best & Worst case Forecast 05:02 SLICERS 3 questions Course Review 00:47 HOMEWORK: SLICERS 00:14 PIVOT TABLES: CALCULATED FIELDS & ITEMS 18 lectures • 48min WORKBOOKS 00:02 Creating a Calculated Field 03:58 Use an existing Calculated Field in a new calculation 02:16 Editing a Calculated Field 01:56 Excel formulas & Calculated Fields 03:07 Creating a Calculated Item 04:05 Use an existing Calculated Item in a new calculation 01:36 Editing a Calculated Item 02:18 Excel formulas & Calculated Items 01:50 Calculated Item on Column Labels 02:07 Shortcomings of Calculated Items 02:04 PRO PIVOT TABLE TIP: Solve Order for Calculated Items 04:04 PRO PIVOT TABLE TIP: List Calculated Field & Item formulas 01:05 PRO PIVOT TABLE TIP: Remove a Calculated Field temporarily 00:52 PRO PIVOT TABLE TIP: Order of operations 01:49 CASE STUDY ~ ACCOUNTING: Creating a P&L Pivot Table Report Preview 08:18 CASE STUDY ~ FINANCIAL: Actuals v Plan with Calculated Fields 06:36 CALCULATED FIELDS & ITEMS 3 questions HOMEWORK: CALCULATED FIELDS 00:14 PIVOT TABLES: PIVOT CHARTS 22 lectures • 1hr 10min WORKBOOKS 00:02 Insert a Pivot Chart Preview 03:17 Insert a Slicer with a Pivot Chart 01:52 Pivot Chart Designs 03:48 Pivot Chart Layouts 04:57 Pivot Chart Formats 05:50 Limitations of Pivot Charts & workarounds 01:54 Saving a Pivot Chart template 01:28 PRO PIVOT TABLE TIP: Shortcuts to formatting a Pivot Chart 01:16 PRO PIVOT TABLE TIP: Link chart title to a pivot cell 00:58 PRO PIVOT TABLE TIP: Copying a second chart 00:51 PRO PIVOT TABLE TIP: Put a chart on a separate page with F11 00:40 PRO PIVOT TABLE TIP: Insert Pivot Chart straight from the data source 00:51 PRO PIVOT TABLE TIP: Paste Pivot Chart to your email as a picture 01:05 PRO PIVOT TABLE TIP: Paste Pivot Chart to PowerPoint & make live updates 01:34 PRO PIVOT TABLE TIP: Printing a Pivot Chart 01:20 PRO PIVOT TABLE TIP: Include a Sparkline with your pivot table 01:16 PRO PIVOT TABLE TIP: Charts Do´s & Don'ts 02:37 PRO PIVOT TABLE TIP: Change Chart Type with Slicers! FUN!!! 08:00 PRO PIVOT TABLE TIP: Workaround to creating an interactive Scatter graph 02:20 CASE STUDY ~ ACCOUNTING: P&L Pivot Table report with Graphs 08:14 CASE STUDY ~ FINANCIAL: Pivot Table Slicer & Chart Dashboard Preview 15:47 PIVOT CHARTS 3 questions Create a Pivot Table Dashboard 1 question 28 more sections Instructors MyExcelOnline John Michaloudis Chief Inspirational Officer at MyExcelOnline 4.5 Instructor Rating 5,108 Reviews 90,957 Students 12 Courses Hello fellow Excel lovers/beginners/experts/users! My name is John and I am the Chief Inspirational Officer at MyExcelOnline. I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel) My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials. My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & save you time , create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve. I have taught over 50,000 students on Udemy alone plus over 100,000 people on my website - MyExcelOnline. I have an active Excel blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights. I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer. Join one of my courses and get ready to change your life... Show more Show less Bryan Hong Author, Data Analysis Ninja 4.5 Instructor Rating 3,772 Reviews 55,225 Students 9 Courses Hi! I'm a book author of the 101 Excel Series paperback books and as you can see I love everything about Excel. I'm also an IT Software Developer for more than 10 years and have the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer Microsoft Certified Technology Specialist (MCTS): Windows Applications Microsoft Certified Systems Engineer (MCSE) Microsoft Certified Systems Administrator (MCSA) I focus on teaching in online courses and becoming a book author as I found my passion to reach out to students just like you. I have been teaching online courses for at least 5 years and counting. Courses I'm focused on range from SQL, Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. My passion lies in helping my students in whatever means possible, whether it be reaching them via courses or by books. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678104a75be7425d',m:'1f8c2cc625b4c31cee3d5e207623d0476bd9a213-1627841375-1800-AUxq8IKA16A5z585JAmThbFTH0Y3ciq42ln0BgjSaxjLUVlkzXNMO0I+mYnd7fxZy5bFIm3OdvLqEh09KJP+aN43f5ArQEUdr+EWvRSQ47OszJciOkOJH4e3qFtsl4b1A6yVvoySZr7q3vCQMkNkhrWJSHU6Y0sKorkKJhAZ9tvY',s:[0xaf53cd16d9,0x40a2da9521],}})();
  2. 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, Conditional Formatting, Macros, Dashboards, Data Analysis, GETPIVOTDATA, Calculated Fields, Formatting 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! Show more Show less Requirements Excel for Windows 2007, 2010, 2013, 2016, 2019, Office 365 and Excel for Mac 2011 and 2016 This course is for Excel Beginners, Intermediates or Advanced Users No prior Microsoft Excel knowledge is required Description 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: Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers! Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work! 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: CUSTOMIZE YOUR PIVOT TABLE VALUE FIELD SETTINGS > SUMMARIZE VALUES BY VALUE FIELD SETTINGS > SHOW VALUES AS GROUPING SORTING FILTERING SLICERS CALCULATED FIELDS & ITEMS PIVOT CHARTS CONDITIONAL FORMATTING GETPIVOTDATA Formula MACROS DATA MANAGEMENT BONUS VIDEOS NEW EXCEL 2013 PIVOT TABLE FEATURES NEW EXCEL 2016 PIVOT TABLE FEATURES 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: IMPORT/LOAD DATA TABLE RELATIONSHIPS PIVOT TABLES & SLICERS INTRO TO DAX FORMULAS 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 Clean & transform lots of data quickly Import data from various external sources, folders & Excel workbooks Consolidate data with ease Sort & Filter data Merge data Join data Data shaping & flat files Auto cleanup your data 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 Text Function Logical and Lookup Functions Text to Columns Find & Remove Duplicates Conditional Formatting Find & Replace Go to Special 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: Introduction to Power BI Creating a Power BI Dashboard 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: Cell Formatting Drag & Drop Formulas & Functions Frequent shortcuts Function Key Making selections Ribbon Tab Cell Navigation Inside Ribbon Macros & VBA Pivot Tables Power BI Power Pivot 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 *** Who this course is 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! 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! Show more Show less Course content 38 sections • 402 lectures • 18h 27m total length Expand all sections COURSE INTRODUCTION 8 lectures • 8min COURSE INTRODUCTION Preview 03:54 A MESSAGE FROM YOUR INSTRUCTOR - JOHN MICHALOUDIS Preview 03:38 EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ) 00:30 HANDOUT #1: COURSE TRACKER EXCEL WORKBOOK [FREE EXCEL WORKBOOK DOWNLOAD] Preview 00:13 HANDOUT #2: PIVOT TABLE CHEAT SHEET [FREE PDF DOWNLOAD] Preview 00:00 HANDOUT #3: 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE [FREE PDF DOWNLOAD] Preview 00:00 HANDOUT #4: 101 READY MADE EXCEL TEMPLATES [FREE EXCEL WORKBOOKS DOWNLOAD] Preview 00:00 HANDOUT#5: 50+ EXCEL KEYBOARD SHORTCUTS IN A KEYBOARD LAYOUT [FREE PDF DOWNLOAD] Preview 00:00 PIVOT TABLES: DESIGN & CUSTOMIZE YOUR PIVOT TABLE 49 lectures • 1hr 24min WORKBOOKS 00:02 ARRANGING YOUR DATA SET ~ Tabular Format Preview 02:17 ARRANGING YOUR DATA SET ~ No Gaps 02:23 ARRANGING YOUR DATA SET ~ Formatting 01:20 ARRANGING YOUR DATA SET ~ Tables 02:38 ARRANGING YOUR DATA SET ~ TIP: Clean Your Data Set 02:11 CREATING A PIVOT TABLE ~ Inserting a Pivot Table Preview 03:14 CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout 01:33 CREATING A PIVOT TABLE ~ Field List & Areas 05:18 CREATING A PIVOT TABLE ~ Drill down to audit Preview 01:35 CREATING A PIVOT TABLE ~ Sort Field List from A to Z 00:37 CREATING A PIVOT TABLE ~ TIP: Double click on any labels to show more Fields 00:46 CREATING A PIVOT TABLE ~ TIP: Defer Layout Update 00:48 OPTIONS > DATA ~ Pivot Cache explained 00:53 OPTIONS > DATA ~ Refresh 01:12 OPTIONS > DATA ~ Refresh All 02:20 OPTIONS > DATA ~ Refresh External Data 04:51 OPTIONS > DATA ~ Import from Access database 02:19 OPTIONS > DATA ~ Change Data Source 03:03 OPTIONS > ACTIONS ~ Clear Filters & Clear Pivot 01:10 OPTIONS > ACTIONS ~ Select & format 03:08 OPTIONS > ACTIONS ~ Move a Pivot Table 00:53 DESIGN > STYLES ~ Pivot Table Styles 03:35 DESIGN > STYLES ~ Customising a Pivot Table Style 04:05 DESIGN > STYLES ~ Use a customised style in another workbook 01:20 DESIGN > LAYOUT ~ Subtotals 00:48 DESIGN > LAYOUT ~ Grand Totals 00:54 DESIGN > LAYOUT ~ Report Layouts 02:41 DESIGN > LAYOUT ~ Blank Rows 00:32 DESIGN > LAYOUT ~ TIP: Show the Classic Pivot Table Layout 01:00 OPTIONS > SHOW ~ Expand & Collapse buttons 04:19 OPTIONS > SHOW ~ Move & Remove Fields and Items 02:32 OPTIONS > SHOW ~ Show/Hide Field List 00:20 OPTIONS > SHOW ~ Show/Hide Field Headers 00:19 CUSTOMISATION ~ Change "Count of" to "Sum of" 01:01 CUSTOMISATION ~ Number formatting 01:34 CUSTOMISATION ~ Field name formatting 02:09 CUSTOMISATION ~ TIP: Predetermined number formatting 01:21 CUSTOMISATION ~ TIP: Change Sum views in Label areas 00:44 LAYOUT & FORMAT ~ Indent rows in compact layout 00:52 LAYOUT & FORMAT ~ Change the layout of a report filter 01:18 LAYOUT & FORMAT ~ Format error values 00:42 LAYOUT & FORMAT ~ Format empty cells 01:20 LAYOUT & FORMAT ~ Keep column widths upon refresh 00:46 LAYOUT & FORMAT ~ TIP: Automatic Refresh a Pivot Table 00:48 LAYOUT & FORMAT ~ TIP: Printing a pivot table on two pages 01:13 LAYOUT & FORMAT ~ TIP:Show report filter on multiple pages Preview 02:15 CUSTOMIZE YOUR PIVOT TABLE 3 questions Course Review 00:47 HOMEWORK: SET UP A PIVOT TABLE 00:14 PIVOT TABLES: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY 15 lectures • 39min WORKBOOKS 00:02 Create multiple subtotals Preview 01:36 Count 02:19 Average 02:36 Maximum 01:55 Minimum 01:19 Product 03:31 Count Numbers 02:26 Std Dev 06:59 Varp 03:28 PRO PIVOT TABLE TIP: Show various Grand Totals 02:28 PRO PIVOT TABLE TIP: Shortcuts to Field & Value Field Settings 02:12 PRO PIVOT TABLE TIP: See all pivot Items 05:52 PRO PIVOT TABLE TIP: Show a unique count 02:29 VALUE FIELD SETTINGS > SUMMARIZE VALUES BY 3 questions HOMEWORK: SUMMARIZE VALUES BY 00:14 PIVOT TABLES: VALUE FIELD SETTINGS > SHOW VALUES AS 19 lectures • 49min WORKBOOKS 00:02 % of Grand Total 02:01 % of Column Total 02:08 % of Row Total 01:47 % Of 03:56 % of Parent Row Total (NEW IN EXCEL 2010) 03:12 % of Parent Column Total (NEW IN EXCEL 2010) 02:16 % of Parent Total (NEW IN EXCEL 2010) 02:44 Difference From Preview 04:47 % Difference From 04:11 Running Total in 02:13 % Running Total in (NEW IN EXCEL 2010) 02:51 Rank Smallest to Largest (NEW IN EXCEL 2010) 02:14 Rank Largest to Smallest (NEW IN EXCEL 2010) 02:14 Index 03:38 PRO PIVOT TABLE TIP: Shortcuts to Show Values As 01:08 CASE STUDY ~ ACCOUNTING: % of Revenue Margins 02:31 CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report 04:43 VALUE FIELD SETTINGS > SHOW VALUES AS 3 questions HOMEWORK: SHOW VALUES AS 00:14 PIVOT TABLES: GROUPING 19 lectures • 46min WORKBOOKS 00:02 Group by Date 02:37 Group by Months 01:43 Group by Quarters & Years 01:41 Group by Sales ranges Preview 03:11 Group by Text fields 02:09 Group by Time 01:38 PRO PIVOT TABLE TIP: Shortcuts to Grouping 01:32 PRO PIVOT TABLE TIP: Grouping by Half Years 01:48 PRO PIVOT TABLE TIP: Group by a Date that starts on a Monday 01:53 PRO PIVOT TABLE TIP: Grouping by a custom date 01:41 PRO PIVOT TABLE TIP: Group by fiscal years & quarters 06:29 PRO PIVOT TABLE TIP: Errors when grouping by dates 02:46 PRO PIVOT TABLE TIP: Group two pivot tables independently 03:52 PRO PIVOT TABLE TIP: Fixing the problem of counting grouped sales 00:38 PRO PIVOT TABLE TIP: Display dates that have no data 00:52 CASE STUDY ~ ACCOUNTING: Quarterly Comparative Report 06:37 CASE STUDY ~ FINANCIAL: Min & Max Bank Balance 04:35 GROUPING 3 questions HOMEWORK: GROUPING 00:14 PIVOT TABLES: SORTING 11 lectures • 13min WORKBOOKS 00:02 Sorting by Largest or Smallest 01:51 Sort an Item Row (Left to Right) 01:24 Sort manually (drag, write, right click) 02:01 Sort using a Custom List Preview 03:13 Override a Custom List sort 01:20 Sort row from A-Z and sales from Z-A 01:16 PRO PIVOT TABLE TIP: Sort new items added to your data source 01:11 PRO PIVOT TABLE TIP: Clear a sort 00:21 PRO PIVOT TABLE TIP: Sort Largest to Smallest Grand Totals 00:19 SORTING 3 questions HOMEWORK: SORTING 00:14 PIVOT TABLES: FILTERING 21 lectures • 43min WORKBOOKS 00:02 Filter by Dates 06:41 Filter by Labels - Text 02:35 Filter by Labels - Numerical Text 02:44 Filter by Values 03:50 Filter by Values - Top or Bottom 10 Items 02:06 Filter by Values - Top or Bottom % Preview 01:39 Filter by Values - Top or Bottom Sum 01:42 Filter by Report Filter 03:31 PRO PIVOT TABLE TIP: Shortcuts to filters 01:36 PRO PIVOT TABLE TIP: Keep or hide selected items 00:57 PRO PIVOT TABLE TIP: Filter by Text wildcards * and ? 03:19 PRO PIVOT TABLE TIP: Filter by multiple fields 01:00 PRO PIVOT TABLE TIP: Apply multiple filters 01:45 PRO PIVOT TABLE TIP: Filter by multiple values 01:06 PRO PIVOT TABLE TIP: Include new items in manual filter 01:50 PRO PIVOT TABLE TIP: Clear filters with one click 01:30 PRO PIVOT TABLE TIP: Add a filter for the column items 00:33 CASE STUDY ~ ACCOUNTING: Top 5 Expenses report 02:22 CASE STUDY ~ FINANCIAL: Top 25% of Channel Partners 02:11 FILTERING 3 questions HOMEWORK: FILTERING 00:14 PIVOT TABLES: SLICERS (NEW FROM EXCEL 2010) 16 lectures • 48min WORKBOOKS 00:02 Insert a Slicer Preview 03:54 Slicer Styles 02:18 Creating a custom style 05:30 Copy a custom style into a new workbook 01:33 Slicer Settings 04:42 Slicer Size & Properties 02:56 Slicer Connections for multiple pivot tables Preview 03:16 PRO PIVOT TABLE TIP: Different ways to filter a Slicer 01:22 PRO PIVOT TABLE TIP: Use one slicer for two pivot tables 01:19 PRO PIVOT TABLE TIP: Lock the workbook but not the slicer 01:25 PRO PIVOT TABLE TIP: Interactive employee photos with Slicers! FUN! 09:20 CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer 04:13 CASE STUDY ~ FINANCIAL: Base, Best & Worst case Forecast 05:02 SLICERS 3 questions Course Review 00:47 HOMEWORK: SLICERS 00:14 PIVOT TABLES: CALCULATED FIELDS & ITEMS 18 lectures • 48min WORKBOOKS 00:02 Creating a Calculated Field 03:58 Use an existing Calculated Field in a new calculation 02:16 Editing a Calculated Field 01:56 Excel formulas & Calculated Fields 03:07 Creating a Calculated Item 04:05 Use an existing Calculated Item in a new calculation 01:36 Editing a Calculated Item 02:18 Excel formulas & Calculated Items 01:50 Calculated Item on Column Labels 02:07 Shortcomings of Calculated Items 02:04 PRO PIVOT TABLE TIP: Solve Order for Calculated Items 04:04 PRO PIVOT TABLE TIP: List Calculated Field & Item formulas 01:05 PRO PIVOT TABLE TIP: Remove a Calculated Field temporarily 00:52 PRO PIVOT TABLE TIP: Order of operations 01:49 CASE STUDY ~ ACCOUNTING: Creating a P&L Pivot Table Report Preview 08:18 CASE STUDY ~ FINANCIAL: Actuals v Plan with Calculated Fields 06:36 CALCULATED FIELDS & ITEMS 3 questions HOMEWORK: CALCULATED FIELDS 00:14 PIVOT TABLES: PIVOT CHARTS 22 lectures • 1hr 10min WORKBOOKS 00:02 Insert a Pivot Chart Preview 03:17 Insert a Slicer with a Pivot Chart 01:52 Pivot Chart Designs 03:48 Pivot Chart Layouts 04:57 Pivot Chart Formats 05:50 Limitations of Pivot Charts & workarounds 01:54 Saving a Pivot Chart template 01:28 PRO PIVOT TABLE TIP: Shortcuts to formatting a Pivot Chart 01:16 PRO PIVOT TABLE TIP: Link chart title to a pivot cell 00:58 PRO PIVOT TABLE TIP: Copying a second chart 00:51 PRO PIVOT TABLE TIP: Put a chart on a separate page with F11 00:40 PRO PIVOT TABLE TIP: Insert Pivot Chart straight from the data source 00:51 PRO PIVOT TABLE TIP: Paste Pivot Chart to your email as a picture 01:05 PRO PIVOT TABLE TIP: Paste Pivot Chart to PowerPoint & make live updates 01:34 PRO PIVOT TABLE TIP: Printing a Pivot Chart 01:20 PRO PIVOT TABLE TIP: Include a Sparkline with your pivot table 01:16 PRO PIVOT TABLE TIP: Charts Do´s & Don'ts 02:37 PRO PIVOT TABLE TIP: Change Chart Type with Slicers! FUN!!! 08:00 PRO PIVOT TABLE TIP: Workaround to creating an interactive Scatter graph 02:20 CASE STUDY ~ ACCOUNTING: P&L Pivot Table report with Graphs 08:14 CASE STUDY ~ FINANCIAL: Pivot Table Slicer & Chart Dashboard Preview 15:47 PIVOT CHARTS 3 questions Create a Pivot Table Dashboard 1 question 28 more sections Instructors MyExcelOnline John Michaloudis Chief Inspirational Officer at MyExcelOnline 4.5 Instructor Rating 5,108 Reviews 90,957 Students 12 Courses Hello fellow Excel lovers/beginners/experts/users! My name is John and I am the Chief Inspirational Officer at MyExcelOnline. I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel) My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials. My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & save you time , create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve. I have taught over 50,000 students on Udemy alone plus over 100,000 people on my website - MyExcelOnline. I have an active Excel blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights. I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer. Join one of my courses and get ready to change your life... Show more Show less Bryan Hong Author, Data Analysis Ninja 4.5 Instructor Rating 3,772 Reviews 55,225 Students 9 Courses Hi! I'm a book author of the 101 Excel Series paperback books and as you can see I love everything about Excel. I'm also an IT Software Developer for more than 10 years and have the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer Microsoft Certified Technology Specialist (MCTS): Windows Applications Microsoft Certified Systems Engineer (MCSE) Microsoft Certified Systems Administrator (MCSA) I focus on teaching in online courses and becoming a book author as I found my passion to reach out to students just like you. I have been teaching online courses for at least 5 years and counting. Courses I'm focused on range from SQL, Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. My passion lies in helping my students in whatever means possible, whether it be reaching them via courses or by books. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678104a75be7425d',m:'1f8c2cc625b4c31cee3d5e207623d0476bd9a213-1627841375-1800-AUxq8IKA16A5z585JAmThbFTH0Y3ciq42ln0BgjSaxjLUVlkzXNMO0I+mYnd7fxZy5bFIm3OdvLqEh09KJP+aN43f5ArQEUdr+EWvRSQ47OszJciOkOJH4e3qFtsl4b1A6yVvoySZr7q3vCQMkNkhrWJSHU6Y0sKorkKJhAZ9tvY',s:[0xaf53cd16d9,0x40a2da9521],}})();
  3. 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, Conditional Formatting, Macros, Dashboards, Data Analysis, GETPIVOTDATA, Calculated Fields, Formatting 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! Show more Show less Requirements Excel for Windows 2007, 2010, 2013, 2016, 2019, Office 365 and Excel for Mac 2011 and 2016 This course is for Excel Beginners, Intermediates or Advanced Users No prior Microsoft Excel knowledge is required Description 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: Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers! Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work! 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: CUSTOMIZE YOUR PIVOT TABLE VALUE FIELD SETTINGS > SUMMARIZE VALUES BY VALUE FIELD SETTINGS > SHOW VALUES AS GROUPING SORTING FILTERING SLICERS CALCULATED FIELDS & ITEMS PIVOT CHARTS CONDITIONAL FORMATTING GETPIVOTDATA Formula MACROS DATA MANAGEMENT BONUS VIDEOS NEW EXCEL 2013 PIVOT TABLE FEATURES NEW EXCEL 2016 PIVOT TABLE FEATURES 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: IMPORT/LOAD DATA TABLE RELATIONSHIPS PIVOT TABLES & SLICERS INTRO TO DAX FORMULAS 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 Clean & transform lots of data quickly Import data from various external sources, folders & Excel workbooks Consolidate data with ease Sort & Filter data Merge data Join data Data shaping & flat files Auto cleanup your data 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 Text Function Logical and Lookup Functions Text to Columns Find & Remove Duplicates Conditional Formatting Find & Replace Go to Special 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: Introduction to Power BI Creating a Power BI Dashboard 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: Cell Formatting Drag & Drop Formulas & Functions Frequent shortcuts Function Key Making selections Ribbon Tab Cell Navigation Inside Ribbon Macros & VBA Pivot Tables Power BI Power Pivot 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 ta