Best Power Pivot Courses

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

Microsoft Excel Pivot Tables – The Beginner Course

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

Created by Matt Jackman - Digital Analytics and SEO Professional

"]

Students: 151181, Price: Free

Students: 151181, Price:  Free

What's this course about

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

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

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

Who will benefit from this course

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

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

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

What you'll learn in this course

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

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

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics

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

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

"]

Students: 119237, Price: Free

Students: 119237, Price:  Free

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

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

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

"Very clear and easy to understand" - Fiona M

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

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

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

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

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

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

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

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

Learn Power BI Basics for Free

In this tutorial you will be learning all basic knowledge required for Power BI and understanding Power BI component

Created by Vishal Pawar - Microsoft MVP Data Platform, Solution Architect

"]

Students: 93846, Price: Free

Students: 93846, Price:  Free

Learn Power BI Basics for Free !

Power BI transforms your company's data into rich visuals for you to collect and organize so you can focus on what matters to you. Stay in the know, spot trends as they happen, and push your business further.

Let us help you bring your data to life !

Looking for new ways to find and visualize data and to share your discoveries? Power BI can help. This collection of tools, online services and features from Microsoft transforms your company's data into rich visuals for you to collect and organize, so you can spot trends, collaborate in new ways, and make sense of your data.

This video tutorial contains following chapter decks

  1. Introduction to Course
  2. Introduction to Power BI and all Its Components
  3. How to download and installation Component of Power BI
  4. Power BI Desktop
  5. Power BI Service Online.
  6. Power BI Gateways
  7. PowerPivot
  8. PowerQuery
  9. PowerView
  10. PowerMap
  11. Power BI - Q&A
  12. Power BI Mashup
  13. What a next!

Microsoft Excel: Business Intelligence w/ Power Query & DAX

Learn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)

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

"]

Students: 69153, Price: $89.99

Students: 69153, Price:  Paid

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

"I am a self-taught Excel Power Query user and it took me a while to understand what each tool does and how it interacts with others. Thanks to your introduction I finally nailed it in a very clear, unambiguous way. You helped me build a method that I can confidently apply to my data in Excel. Thank you so much!"

-Francesca C.

"I'm less of an expert at breathing than Chris is at Excel. This course is thorough and well-planned, and he presents in a manner that simplifies the complicated. Well worth your time if you want to master Excel power query and power pivot!"

-Tim B.

"I'm geeking out, this is so cool. Where has this been all my life???"

-Karen P.

__________

COURSE DESCRIPTION:

This course introduces Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and absolutely supercharge your Excel analytics game, this course is the A-Z guide that you're looking for.

I'll introduce the "Power Excel" landscape, and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence. Together, we'll walk through the Excel BI workflow, and build an entire Excel data model from scratch:

  • First we'll get hands-on with Power Query; a tool to extract, transform, and load data into Excel from flat files, folders, databases, API services and more. We'll practice shaping, blending and exploring our project files in Excel's query editor, and create completely automated loading procedures inside of Excel with only a few clicks.

  • From there we'll dive into Data Modeling 101, and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies and more). We'll take a tour through the Excel data model interface, introduce some best practices and pro tips, and then create our own relational database to analyze throughout the course.

  • Finally, we'll use Power Pivot and DAX to explore and analyze our Excel data model. Unlike traditional Excel Pivot Tables, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables (inside of Excel!), and create supercharged calculated fields using a formula language called Data Analysis Expressions (or "DAX" for short). We'll cover basic DAX syntax, then introduce some of the most powerful and commonly-used functions -- CALCULATE, FILTER, SUMX and more.

If you're ready to take your Excel game to new heights and join the leading edge of analytics & business intelligence, this course is for you. It's time to stop fighting with tedious, manual tasks and struggling with "old-school" Excel; join me on this journey and emerge a certified excel analytics NINJA.

See you in there!

-Chris (Founder, Excel Maven Maven Analytics)

__________

IMPORTANT: Power Query and Power Pivot are currently NOT available in Excel for Mac. You'll need a PC version of Excel that is compatible with Power Pivot (Excel 2010 with plug-in, Excel 2013, Excel 2016, or Excel 2019 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

__________

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

*** This course includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee! ***

Power BI – The Ultimate Orientation

Business Intelligence and data is here to stay. Get your Orientation to Self Service BI with Power BI

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

"]

Students: 66892, Price: Free

Students: 66892, Price:  Free

Business Intelligence and data are here to stay.  Now with Power BI by Microsoft, costs and skills are no longer a barrier to entry.

Power BI is a self service business intelligence system, and best of all, it is free for all to use. 

COURSE OVERVIEW

The aim of this course Power BI - The Ultimate Orientation is to give you a solid orientation of Power BI. First you will learn how to download and install power bi desktop.  We will have a look around the user interface and then we will start to work with some data.

Using an example data set, we will connect to both excel and cvs files and you will get an introduction of the Query editor as we do some transformation on the data.  Then we will move on to a few calculations and you will be introduced to the concept of relationships and dax. Finally in powerbi desktop we will look at the visualisations side.

After we look at visualisations in Power Bi Desktop we will move on to power Bi services.  Its in services that you will get insights, have the ability to share reports, build dashboards and connect to data packs that contains prebuilt dashboards and reports.

 We will not be looking at any of this in detail as, this course is an orientation course, designed to get you familiar and comfortable with the Power BI user interface.  The aim of the course is to get you up and running.  To show you that Power BI offers a real solution, and give you ideas of how it can be used.

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

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

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

"]

Students: 54092, Price: Free

Students: 54092, Price:  Free

Teaching 11 Courses on Excel and Data Analysis!

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

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

Course Updated:  Nov 01. 2016

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

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

At the end of this course:

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

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

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

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

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

Power Pivot Workshop Beginner

Learn how to start using Power Pivot for Excel creating your own data models.

Created by Marco Russo - Business Intelligence expert at SQLBI - SSAS Maestro & MVP

"]

Students: 45049, Price: Free

Students: 45049, Price:  Free

The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics.

The course includes almost 3 hours of video in 30 lectures. You do not need any previous experience in Power Pivot to take this course.

Sections included in this course:

  • Introduction to Self-Service Business Intelligence
  • Introduction to Power Pivot
  • Loading Data
  • Data Modeling

After this course, we suggest you to take the Power Pivot Workshop Intermediate one.

Learn Power BI Fast

Build a professional Power BI report in less than 2 hours. Learn data visualization basics and advanced techniques.

Created by Parker Stevens - SQL/BI Developer

"]

Students: 33672, Price: Free

Students: 33672, Price:  Free

Microsoft Power BI is one of the most robust business intelligence software on the market and it so happens that it's one of the cheapest! Anyone can start building their own data visualizations for free. If you own your own business and want to harness the power of your data or if want to start a career in Business Intelligence, Power BI is a great tool to leverage.

This course will walk you through the entire process of making your first Power BI dashboard. By the end of the course, you will be able to create visualizations using your own data and add value to your company.

First, I walk you through how to download Power BI. Since there is no better practice than by doing it yourself, we will be using a publicly-available database called AdventureWorksDW2012. I will guide you in how to install SQL Server Management Studio and configure the database so that you can perform the lessons right alongside me.

Next, we take a tour of Power BI and create our first visualizations using data that we retrieve from the database. You'll learn about all of the different chart types and when to use them.

Later, we dive into some more advanced topics including how to calculate your own columns and measures and how to leverage DAX (Data Analysis Expressions) to perform complex calculations.

We then move on the styling your report. Arguably one of the most important parts of report building, you need to make sure it looks good or no one will want to use it. Take my word for it.

We finish up with how to share your reports. This involves setting up your workspace in Power BI Service, pushing your report up the cloud, and then publishing your hard work for others to see.

At this point, you will be proud of what you have built and you will hopefully see just how addictive building data visualizations in Power BI can be. Without further ado, let's get started!

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

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

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 30410, Price: $119.99

Students: 30410, Price:  Paid

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

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

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

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

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

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

          "This course is tremendously comprehensive. The best part is that the  course is served in small bite-sized pieces that are easily digested.  A teaching course that  doubles as a reference guide. Definitely worth your time and money" - James

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

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

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

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

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

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

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

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

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

YOU GET THE FOLLOWING 5 COURSES WITH THIS EXCEL BUNDLE:

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

COURSE #1 - EXCEL PIVOT TABLES

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

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

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

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

In no time you will be able to analyze lots  of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management &  prospective employers.  The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!  

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

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

EXCEL PIVOT TABLES COURSE:

  1. CUSTOMIZE   YOUR PIVOT TABLE       

  2. VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

  3. VALUE FIELD SETTINGS > SHOW VALUES AS

  4. GROUPING

  5. SORTING

  6. FILTERING

  7. SLICERS

  8. CALCULATED FIELDS & ITEMS

  9. PIVOT CHARTS

  10. CONDITIONAL FORMATTING

  11. GETPIVOTDATA Formula

  12. MACROS       

  13. DATA MANAGEMENT       

  14. BONUS VIDEOS       

  15. NEW EXCEL 2013 PIVOT TABLE FEATURES       

  16. NEW EXCEL 2016 PIVOT TABLE FEATURES

  17. NEW EXCEL 2019 & OFFICE 365 PIVOT TABLE FEATURES   

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

COURSE #2 - EXCEL POWER PIVOT & DAX FORMULAS

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

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

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

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

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

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

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

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

EXCEL POWER PIVOT & DAX COURSE:

  1. IMPORT/LOAD DATA

  2. TABLE RELATIONSHIPS

  3. PIVOT TABLES & SLICERS

  4. INTRO TO DAX FORMULAS

  5. MEASURES & CALCULATED COLUMNS

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

COURSE #3 - EXCEL POWER QUERY

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

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

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

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

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

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

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

EXCEL POWER QUERY - PART 1

  1. Clean & transform lots of data quickly

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

  3. Consolidate data with ease

  4. Sort & Filter data

  5. Merge data

  6. Join data

  7. Data shaping & flat files

  8. Auto cleanup your data

  9. M Functions

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

EXCEL POWER QUERY - PART 2

  1. Text Function

  2. Logical and Lookup Functions

  3. Text to Columns

  4. Find & Remove Duplicates

  5. Conditional Formatting

  6. Find & Replace

  7. Go to Special

  8. Sort & Filter

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

COURSE #4 - MICROSOFT POWER BI

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

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

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

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

  1. Introduction to Power BI

  2. Creating a Power BI Dashboard

  3. Advanced Power BI Dashboard with Real Live Data

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

COURSE #5 - 333 EXCEL KEYBOARD SHORTCUTS

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

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

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

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

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

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

333 EXCEL KEYBOARD SHORTCUTS VIDEO COURSE:

  1. Cell Formatting

  2. Drag & Drop

  3. Formulas & Functions

  4. Frequent  shortcuts

  5. Function Key   

  6. Making selections

  7. Ribbon Tab

  8. Cell Navigation

  9. Inside Ribbon 

  10. Macros & VBA

  11. Pivot Tables 

  12. Power BI 

  13. Power Pivot

  14. Other Shortcuts   

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

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

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

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

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

...THEN THIS COURSE IS FOR YOU!

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

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

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

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

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

Excel Essentials for the Real World (Complete Excel Course)

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

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 23289, Price: $129.99

Students: 23289, Price:  Paid

Learn Excel from Scratch OR become more CONFIDENT.

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

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

  • Excel's new XLOOKUP function

  • New FILTER function in Excel

  • SORT, SORTBY & UNIQUE functions

In addition to the above, we also cover:

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

  2. What the Hash (#) sign is

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

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

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

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

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

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

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

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

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

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

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

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

________________________________________________

WHY TAKE THIS SPECIFIC EXCEL COURSE?

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

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

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

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

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

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

_________________________________________________

IS THIS ONLINE EXCEL COURSE FOR BEGINNERS ONLY?

This Complete Excel Course is for two types of people:

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

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

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

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

________________________________________________

WHAT YOU'LL BE ABLE TO ACHIEVE

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

  • Input data and navigate large spreadsheets

  • Apply Excel hacks to get your work done faster

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

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

  • Get answers from your data

  • Organize, clean and manage large data

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

  • Turn messy data into helpful charts

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

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

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

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

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

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

________________________________________________

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

You'll learn:

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

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

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

  • How to add comments and notes to cells.

  • Add time stamps to your reports.

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

  • How to best navigate large data and large spreadsheets.

  • Useful Excel shortcuts for data entry and navigation.

  • How to Protect your Excel files and worksheets properly.

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

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

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

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

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

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

  • Design principles for optimal spreadsheets.

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

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

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

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

    _________________________________________________

WHY WOULD YOU CHOOSE TO LEARN EXCEL?

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

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

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

_________________________________________________

WHICH VERSION OF EXCEL IS USED IN THE COURSE?

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

_________________________________________________

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

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

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

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

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

________________________________________________

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

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

Google Sheets: Pivot Tables + Data Insights For Beginners!

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

Created by Brian Moore - data analytics to inform business decisions

"]

Students: 20799, Price: Free

Students: 20799, Price:  Free

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

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

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

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

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

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

This course is broken out into 8 key sections:

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

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

  • Section 3: Applying the Data Insights Pivot Table Process

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

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

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

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

  • Section 8: Course Wrap + Bonus Content

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

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

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

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

#AlwaysBeLearning

Data Visualization with Excel – Crash Course

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

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

"]

Students: 13273, Price: Free

Students: 13273, Price:  Free

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

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

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

Excel 365 – The Ultimate Excel Updates Course

Stay in tune with with the latest updates in Excel From Excel 2016 to Latest Release of Excel 365

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

"]

Students: 10144, Price: Free

Students: 10144, Price:  Free

This course aimed at keeping you informed on the latest and greatest improvements to Excel as they are rolled out. 

Excel 365 keeps improving and to stay ahead of the game, you need to know what changes, additions and improvements are made in each rollout.

This course is an evolving course, as new releases happen, I will update this course with new material. If you just need to stay up to date, then with this course, you will never need to buy another Excel course again.

There are 5 modules in this course

· Communications and collaboration

· General feature improvements

· New Functions

· Charts and Visualizations

· Power tools and data

Each module will have articles and videos. The topics of the article and videos overlap however it is important that you complete both. This will help reinforce the learning and will give you different application examples. Each module also has a quiz and activities for which all workbooks and solutions will be provided.

.Many people don’t need full functions and formulas course, or beginner to advanced course. They just need to know whats changes and how to use the changes. And that’s what this course is all about. This course is aimed at experienced Excel users looking to stay up to date and it is not designed for beginner Excel users or those looking for a deep dive into Excel.

Power BI Dashboard Step by Step

Business Intelligence, Data Connectiion, Power Query Basic, Creating Visuals, DAX, Dashboards.

Created by Asif Hafeez - Microsoft Certified Trainer | MCSA (BI Reporting)

"]

Students: 9199, Price: Free

Students: 9199, Price:  Free

Try not to become a man of success, but rather try to become a man of value. – Albert Einstein

Data analysis is an exciting field to get into and the career prospects are amazing. You don’t need to be a math/computer science/coding whiz to land a job in data analysis.

Data Analysis in demand and we normally use Excel to create beautiful Charts and Graphs to show the results. But Power BI is the ultimate choice to prepare quick Reports and Dashboards and easy to understand that is the reason it has become the first choice of a Data Analysis.

In this Course I will teach you to create some beautiful Dashboards/Reports by simple techniques in few minutes. Power BI was generally made available in 2015 and by the time it is has become the Leader in the market for Business Intelligence (source: Gartner Report).

WHAT YOU WILL LEARN

  • Simple methods to prepare Power BI Dashboards

  • Quick way to create Reports and Dashboards

PREREQUISITES

  • Basic Excel Knowledge

WHO THIS COURSE IS FOR?

  • Power BI beginners

  • Data Analyst

  • Dashboards lovers

  • Business Intelligence professionals

Excel Power Query, Power Pivot, Power Map & DAX Masterclass

Learn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019

Created by Andreas Exadaktylos - Best Selling Teacher | Msc Computer Scientist

"]

Students: 8320, Price: $99.99

Students: 8320, Price:  Paid

COMPLETELY REDONE ON FEB 2021 WITH NEW VIDEOS!

Learn Power Query, Power Pivot, DAX, Power View, Power Map (3D Maps) and Power BI Desktop Business Intelligence Tools that are rarely found on Excel users, and transform to an Excel Star!

These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create interactive charts, summarize data intelligently using Power Pivot and Power BI tools, and finally present output in stunning Dashboards.

IMPORTANT NOTE: To make sure that your version is compatible before you go on with that course, please check the Microsoft Excel compatibility page. You can watch the 3rd lecture of the course: Versions, Compatibility and Install Power Pivot, Power Map & Power View. (it has a free preview)

Power Pivot is currently not available for Mac and is only available in specific Excel versions for windows.

Content and Overview
This course is a guide with simple step by step instructions to walk you through creating business intelligence reports and dashboards in Excel, quickly and efficiently. The course has been created with the version of Microsoft Excel 2019 and Microsoft 365, but it's compatible with older versions of Excel.

This course aims to introduce the Excel user to the brave new world of self-service BI using the Excel BI Toolkit.

We'll use Microsoft Excel Power Query, Power Pivot, Power View, Power 3D Maps tools and DAX Formula Language to analyze huge amounts of business data fast and transform data into bottom-line results – no programming required!

Finally, we’re going to explain the Power BI Desktop application, that lets you share interactive dashboards based on your Excel data.

At the end of the course, we will create a beautiful dashboard, combining all the excel BI tools together.

You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee!

Plus you will get fast and responsive support within 48 hours.

Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.

What are you waiting for? Enroll now and take your business intelligence analysis to a whole new level!

What you'll learn:

  • Understand and install the Excel Power Query, Power Pivot, Power Map, Power View and Power BI Desktop add-ins

  • Import data from spreadsheets, Access, SQL, text files and other sources

  • Add calculated fields, columns and Measures with Data Analysis Expressions (DAX) formula language

  • Create complex reporting systems

  • How to use the Power View presentation and analysis tool.

  • Learn from start to finish the powerful features of Excel Power Map

  • Explain the Power BI Desktop application, that lets you share interactive dashboards based on your Excel data.

  • Design your Excel Dashboard with link buttons

  • What are KPI's and add key metrics

  • Create mind blowing Excel Pivot Charts from Power Pivot

  • Create powerful reports using Slicers and Timeline

  • Make an amazing interactive sales map using Excel Power View powerful add-in

  • Summarize data with Matrices, Cards and Tiles

  • Perform simple-to-sophisticated calculations like Month to date and Year to date

  • Analyze multiple tables together without the need to ever write VLOOKUP formulas again

Enroll now and master the creation of interactive Excel Dashboards!

100% risk free – 30 day money back guarantee! - Lifetime access

Who is this course for?

This course assumes that you have a basic knowledge of Excel . You don't need to be a master of Excel. Only basic prior experience in Excel or Spreadsheets is required to get the most out of this Excel course.

This course is also ideal for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals and students.

At the end of this Excel class you will be given a Certificate of Completion.

STUDENT REVIEWS:

"I highly recommend this course. It was exactly what I needed to jump start my career. I learned far more than I expected. The instructor is excellent !!!!!!!!" - Troy Newman

===================================================================

"A thorough tutorial on using all the Excel BI Toolkit,  to create dashboard reporting. Very well presented and explain complex issues in a simple way. It is clear and easy to understand and has helped me develop reporting dashboards. Excellent!" - Albert Loomer

===================================================================

"Andreas helps the viewer use Excel skills to produce truly useful dashboards. Highly recommend for those looking to learn data presentation." - David Anderson

===================================================================

Enrol now and enjoy!

Microsoft Excel – 333 Microsoft Excel Keyboard Shortcuts

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

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 7604, Price: Free

Students: 7604, Price:  Free

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

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

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

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

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

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

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

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

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

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

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

  1. Cell Formatting

  2. Drag & Drop

  3. Formulas & Functions

  4. Frequent  shortcuts

  5. Function Key   

  6. Making selections

  7. Ribbon Tab

  8. Cell Navigation

  9. Inside Ribbon 

  10. Macros & VBA

  11. Pivot Tables 

  12. Power BI 

  13. Power Pivot

  14. Other Shortcuts   

----------

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

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

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

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

...THEN THIS COURSE IS FOR YOU!

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

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

----------

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

Create a Dashboard in POWER BI in an Hour

In 60 mins create an awesome HR analytics dashboard in POWER BI

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 5782, Price: Free

Students: 5782, Price:  Free

This course is for anyone who wants to start exploring the POWER BI software. In this course, I have prepared a dashboard related to HR analytics. This is a beginner level course with an easy explanation. Perform ad-hoc analysis and dig deeper using the built-in analytics capabilities. I hope you will enjoy learning this skill set.

Power BI & Power Pivot: Introduction

Crash course on how to work effectively with Power BI and Power Pivot

Created by Bas Dohmen - BI Developer at DataTraining.io

"]

Students: 5690, Price: Free

Students: 5690, Price:  Free

________

From a normal pivot table to Power Pivot

  • Working with tables

  • Combining data the old way

  • Creating relationships in Power Pivot

  • Connecting a pivot table to the data model

Building a data model in Power Pivot

  • Importing data into Power Pivot

  • Data modeling and relationships

  • Creating a pivot table connected to a data model

Creating a dashboard using Power Pivot

  • Importing data

  • Data modeling

  • Report structure

  • Report filters

Building a report in Power BI

  • Introduction to Power BI

  • Loading data into Power BI

  • Creating relationships

  • Creating a date table

  • Visualizations- Area charts

  • Visualizations- Bar charts

  • Visualizations- Maps

  • Visualizations- Cards

Sales Analytics Dashboard in POWER BI

Learn to Create Sales Analytics Dashboard in POWER BI in 60 mins

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 5487, Price: Free

Students: 5487, Price:  Free

Using the Sales Analytics solution build on Power BI, you can connect to your sales data to see your sales performance and analyze the top-sellers, agents, locations, and categories, more interactive than ever before. Sales analytics is the process used to identify, model, understand and predict sales trends and sales results while helping in the understanding of these trends and finding improvement points. It is used to determine the success of a previous sales drive and forecast as well as determine how future ones will fare.

Top Tips for DAX users – Power BI and Excels Power Pivot

Tips for DAX users to help improve efficiency, modelling and much more in Power BI or Power Pivot

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

"]

Students: 5430, Price: Free

Students: 5430, Price:  Free

Are you looking to improve your efficiency, your modeling skills, and your general DAX usage skills for Power BI or Power Pivot?  IF so then this course is for you.

This course is a general tips course for those working with DAX in Power BI or Power Pivot.  You will learn tips and tricks that will both save you time and make you more efficient.  DAX is becoming a more sought after skill and this course has been designed to help you become on top of the game.

You will be given tips on the following topic and more

- Data Modelling

- Working with Date tables

- Keyboard shortcuts

- Model optimization

- Data transformation steps

- Using Power Query

- Much much more

This is a hands-on course, so you will find workbooks to download so that you can practice along

So if you are a DAX user and are looking to improve your general skills and efficiency then when don't you hope into the course and find out more.

Master DAX fundamentals : Power BI, Power Pivot & SSAS

The Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis Services

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

"]

Students: 4086, Price: $99.99

Students: 4086, Price:  Paid

Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.

Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions.

This is a hands on course

Course Overview

In the first section of this course you will be introduced to the use of the most common DAX expressions, such as SUM and SUMX, COUNT, ROUND, DIVIDE, MIN, MAX, IF Statements, TEXT expressions, Variables and More

In the next section of this course you will learn the fundamentals of how DAX works.  This section will include both theory and examples and it is of utmost importance that you understand how DAX works. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.

In the third section of this course you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE

Each section of this course contains Activities to complete. These Activities are of utmost importance.  When it comes to learning DAX, practice is a must.

Data Visualizations with POWER BI

Data Visualizations with POWER BI

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 3949, Price: Free

Students: 3949, Price:  Free

Visualizations (known as visuals for short) display insights that have been discovered in the data. A Power BI report might have a single page with one visual or it might have pages full of visuals. It's important to make the distinction between report designers and report consumers. If you are the person building or modifying the report, then you are a designer. Designers have edit permissions to the report and its underlying dataset. In Power BI Desktop, this means you can open the dataset in Data view and create visuals in Report view.

DAX Power Pivot – 10 Easy Steps for Beginners

Learn how to build DAX functions in PowerPivot with Excel 2016. Reinforce and embed with practice exercises/solutions

Created by Gilly Dow - IT Training Consultant

"]

Students: 3687, Price: $109.99

Students: 3687, Price:  Paid

If your goal is to enter the world of BI, Data Mining and or Data
Analysis you have to take this course.
All of these environments and roles demand the skills you are about to learn

Microsoft PowerPivot is an add on for Excel that provides Business
Intelligence functionality and reporting within the familiar environment of
Excel.

This capability enables manipulation of hundreds of millions of rows of
data with the capacity to provide business insights and shorter decision making
cycles laughing in the face of the million row threshold of regular Excel

Here's what others had to say about the course:

"This instructor is unbelievable. Not only were the course materials plentiful, but her instruction was full of enthusiasm and encouragement. The format was perfect for me. I never felt like I was being left behind. I'll take any course by Gilly Dow, if it's not completely relevant to something I'm working with at the moment. This course was really amazing."

- Mickey Thorpe

"I purchased your two courses as a review to brush up on my skills Dax Power Pivot 10 Easy Steps for beginners Dax Power Pivot Time intelligence 10 easy steps Both wonderfully explained with very good demonstrated examples. Great refresher courses. You really have a gift for teaching. I took PowerPivot Pro a couple of years back and I find your walk through and demonstrations of the Dax measures so much clearer and to the point. It has been a fun enjoyable refresher for me. This is great course for everyone getting started in PowerPivot Thanks well done."

- Stephen Davanzo

"Thank you so much for making DAX so simple and efficient. This is perfect for everyone would like to start their journey in DAX."

- Ravi Vijay

"she is too good . I would  like to do other courses  even if they are not available on Udemy. Request Udemy to get all her works small or big on the site. Every slide I see my learning and understanding increases by leaps and bounds. I simply love this instructor and my highest regards for her way of explaining the things."

- Vinay Kumra

"Great course, good testing, good exercises, easy to follow lessons. I'm about 60% complete and the further I go the better it gets. Love the practice exercises and how the instructor goes through the answers in video detail about how the solution was arrived at...great teaching techniques all around. And then, there is the 70+ page guide that is integrated into the lesson plan, makes following the videos and working independently on the practice sessions easy as everything is organized to just follow along and learn by doing. So, watch, listen read do, test, feedback, move to next lesson. Right pace, right tone, right encouragement. Excellent course! Looking forward to the advanced. Marty"

- Martin Rini

"I really loved this course because it gave a nice (IMHO) overview for a beginning DAX / Power Pivot course. The Instructor was very very good. She took time to walk-through each step. If she keeps that approach in the upcoming Intermediate and Advanced courses, they will be winners. (She even gave some "top-tips" for regular Excel which jogged my memory banks anyway.) I am eagerly looking forward to the release dates her subsequent courses."

- Walt Lierman

What You'll Learn

To start with the course focuses on importing data into Power Pivot to
create the Data Model. You will learn about calculated columns and other DAX
related concepts that will show you how to “shape”
the data.

Next, you will create relationships between tables of data negating the
need for VLOOKUP. Reducing the time it takes to “shape” your data -  is one of the major benefits of this
awesome tool.

With the data model in place, next you delve into the world of DAX
measures. These are Data Analysis EXpressions functions that build the formulas to provide the
business insights that decision makers and stakeholders dream of.

There is no programming involved with DAX - your Excel
formulas experience has set you up nicely for the next step in your Excel
journey.

Throughout the course we work together building the data model and measures.
At the end of each step you have an opportunity to practice creating your own
measures to help you consolidate, embed and reinforce everything you have
learned. I provide a solutions video lecture before moving on to ensure you’re
on track and ready to move on.

I provide all the files you need to follow along and a fully supporting,
screen-shot enriched 78 pg. user guide pdf packed with all the steps and practice
exercises with solutions.

Power Pivot is the perfect tool for those working in finance,
statistics, project, business and market analysis or any data reporting role
who have a need to create and produce Business Intelligence style dashboard
reports.

Thanks for taking the time to check out my course. I can't wait to help
you take the next step in developing your Excel skills. I have used Excel
2016
to demonstrate this fantastic tool but you can follow along in
Excel 2010 & 2013 - I'll do my best to point out the differences. If you
have any questions about the course, feel free to message me here or check out
the FREE preview lectures to learn more.

Take the first steps to a new and rewarding future by clicking on the TAKE
THIS COURSE
button, located on the top right corner of the page. 

DAX Power Pivot – 10 Easy Steps for Intermediates

Build Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next level

Created by Gilly Dow - IT Training Consultant

"]

Students: 2833, Price: $119.99

Students: 2833, Price:  Paid

This course builds upon the skills learned in the first
course in this series DAX Power Pivot –
10 Easy Steps for Beginners.

You have already gotten your hands dirty with Power Pivot and seen how awesome it is.
Now you are ready to take your skills to the next level by delving deeper and acquiring
a more thorough understanding of how “Disconnected
or “Parameter” tables can be utilised
to gain additional insights in your data models.

The first part of the course addresses Microsoft’s change to
the DAX engine that now makes
editing queries a challenge if you
aren’t an expert in SQL. Therefore, you learn to use Get & Transform to import data and in doing so, reduce the size
of your data model file size considerably.

You will draw upon your beginner DAX skills to delve deeper into the real meaning behind “Initial Filter Context”, “Filter Context” and “Context Transition” with explanations,
diagrams, examples and practice exercises.

To leverage the capabilities of “Disconnected” tables, I introduce you to the concept of thresholds, cut-offs and banding.
This really does open the door to a wealth of possibilities and you’ll learn
some useful techniques to gain some powerful new insights along the way.

Throughout the course, you are building your skills and understanding
– taking you to the next level at each Step
1-10.

I’ll have a couple of surprises
for you along the way – not only to boost your brownie-points at work but for
your own piece of mind around administration of your data models!

Here's what others said about the course:

Gilly. Did it again with the Addition of
Dax PowerPivot-10 easy steps for intermediate course. This intermediate Course
adds more formulas and Dax functions and even disconnected slicers and cube
formulas to add your learning base and continues to build off the previous two
courses. Gilly is a brilliant teacher who clearly has an in-depth understanding
of how power pivot works. She can break it down and simplify Dax so you know
how functions works and understand how to use it in your day-to-day excel work.
If you follow along and do the exercises when you’re done with a lesson you
fully understand how to complete and use the Dax formulas in your data work. If
you want to understand and learn Dax, Gilly courses are what you want to start
with. I recommend Gilly courses, you will be pleased with your results
afterwards. Well done Gilly. Thanks

- SD

"OUTSTANDING COURSE Love the exercises, really enforces the instruction Learning so much, will go over the course again reinforce learning Everything is explained in easy to understand terms"   

- JM

“A lovely paced course with the different
elements nicely segmented and of a good length. Certainly liked the extra
surprise of Cubes. Will aid in displaying data that does not fit well with the
confines of a pivot table. Cheers Gilly
!”

- GB

“Do Love the way you teach. Hope to learn
more from you for advanced DAX course with real world case studies. Bravo!

- HA

“Trainer explains concepts really well
without using too much tech talk. The many examples support the good
understanding of the subjects. The speed is ok for advanced users but too fast
if you did not follow the basic course. Course is complete and every important
subject is explained.”

- R

“Gilly does a great job of explaining
complex concepts and makes her points using thought-provoking analogies.
Excellent instructor!

- SA

“The course continued to build on the 10
Easy steps for Beginners. Detailed Instructions and real-world examples. Deep
dive into advanced Power Pivot Formulas.

- CJ

What you will learn
in this course:

  • Get & Transform – building the Data Model

  • DAX Iterators & Aggregator Functions

  • Initial Filter Context

  • Filter Context

  • Context Transition

  • VALUES()

  • ALL(), ALLSELECTED() & ALLEXCEPT()

  • IF() & HASONEVALUE()

Disconnected/Parameter Tables

  • Creating/Adding Disconnected tables

  • Harvester” Measures

  • Conversion Measures

  • Thresholds/Cut-offs

  • Banding

  • KPI’s

I provide examples
that we work through together. Then it’s over to you with practice exercises for you
to help embed and consolidate your skills. I always provide video solutions – so,
you’re never on your own.

Power Pivot is the perfect tool for those working in finance,
statistics, project, business and market analysis or any data reporting role
who have a need to create and produce Business Intelligence style dashboard and Insight reports.

I have used Excel
2016
to demonstrate this fantastic tool but you can follow along in
Excel 2010 & 2013 - I'll do my best to point out the differences. If you
have any questions about the course, feel free to message me here or check out
the FREE preview lectures to learn more.

Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your DAX skills. 

Take the first steps to a new and rewarding future by clicking on the TAKE
THIS COURSE
button, located on the top right corner of the page.

Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)

Visualise Data in Power Pivot for Excel or SSAS with DAX. 70-779, 70-768 exams. Business Intelligence PowerPivot tool.

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

"]

Students: 2796, Price: $89.99

Students: 2796, Price:  Paid

Reviews:

"In just the first few lessons, I have already been able to apply what I have learned at my job. Thank you for this course!" -- Cynthia Smith

"The Instructor is easy to understand and he gives exercises to test your understanding which is what I prefer rather than just listening to lectures. I will definitely take more of Mr Burton's classes as I like his teaching style." -- Tamuka Mazana

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

This course covers one of the most useful add-ins in Microsoft Excel, PowerPivot, and the Tabular model in SQL Server Analytical Services.

We'll activate PowerPivot if you have the right version of Excel, and if not, then we'll install SQL Server on your computer, which can do the same job. We'll install the Developer edition, which used to cost $100, for free.

After PowerPivot is activated, or SQL Server is installed, we'll create our first analysis in Excel in just a matter of minutes.

After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Power Pivot.

After this introduction, we'll go into some detail into PowerPivot or SSAS - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.

Then we'll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too.

By the end, you will be an Expert user of both PowerPivot and SSAS, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.

It will assist with the Model Data section of Microsoft exam 70-779 "Analysing and Visualizing Data with Microsoft Excel".

It will also assist with the "Design a tabular BI semantic model" and "Develop queries using Data Analysis Expressions (DAX)" section of Microsoft exam 70-768 "Developing SQL Data Models".

Microsoft Power BI – Master Power BI in 90 Minutes!

Master Microsoft Power BI, Power Query, Power Pivot & Power View! Power BI web or desktop. Power BI for Office 365.

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 2383, Price: $89.99

Students: 2383, Price:  Paid

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

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

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

  3. Use Power BI with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

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

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

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

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 straight away the following (in just 90 minutes):

  • Everything about Power BI Dashboards

  • Power Query

  • Power Pivot

  • Power View

In Just 90 Minutes You Will Walk Away With...

  • MORE TIME (Who doesn’t want that?)

  • Create your own Power BI Dashboard from scratch in just 90 minutes!

  • Understand the essence of the Power BI visualizations, and see them in action!

  • See how Power BI is used with real examples!

  • Understand how Power Query, Power View, and Power Pivot are used together!

After this class you will be able to:

  • Actually SMILE when you start creating Power BI Dashboards :-)

  • Get valuable data insights & answers anytime you want from your raw data!

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

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Power BI skills...

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

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

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

...THEN THIS COURSE IS FOR YOU!

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

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 ALL downloadable video tutorials, Exercises, 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 Microsoft Power BI

Power BI Gaming Dashboard for Beginners

Step by step development of Power BI Dashboard

Created by Muhammad Omer - Microsoft Certified Power BI Professional

"]

Students: 2341, Price: Free

Students: 2341, Price:  Free

In this course you will learn how to create a dashboard for Gaming retailer step by step. We will start from raw data and transform it into the way we need it for all kind of transformations and charts then we'll load it into the Power BI Model where we'll create charts based on the requirements. After all the charts are developed, it will be given a cool professional looking design. We'll also work to create a custom image slicer.

Microsoft Excel – Data Analytics Power Query and PivotTables

Clean, Transform and Summarize Microsoft Excel Data Quickly with Excel's Power Query and PivotTable Tools

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 2187, Price: $89.99

Students: 2187, Price:  Paid

Microsoft Excel's Power Query tool is the biggest feature Microsoft has added to Excel since PivotTables. Seriously, no joke. Read on to learn more about Excel Power Query and how you'll save loads of time as you take advantage of this powerful feature.

In Excel 2016, 2019 and Office 365, Power Query is built directly in the Excel interface through the GET AND TRANSFORM command on the Data tab. (Power Query is NOT available on the MAC release of Excel)

Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.

Lets face it, retrieving, cleaning and transforming data to report on can take hours of precious time. With Excel Power Query you can eliminate repetitive tasks freeing your time for other important tasks, like lunch and going home on time. Excel Power Query removes the hassle and complex formulas of manual tasks such as:

  • Finding the Data each time you need a report

  • Cleaning Columns of Data

    • Splitting or Joining Column Values

    • Removing unnecessary characters and extra spaces

    • Formatting data correctly

  • Filtering data needed for the report

  • Combining multiple Datasets into a master list

  • Manipulating the data layout to work with other tools, i.e. Excel PivotTables and Charts

In just 3 easy steps, you'll have a final report ready for presentation and your next raise.

  1. Get Data

  2. Transform/Clean Data

  3. Report on Data

Once you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.

Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.

This Excel Power Query Course Includes:

  • 6+ hours of video content

  • Downloadable exercise files to follow along

  • Access to the instructor through the QA section

Complete Introduction to Excel Power Pivot

Concise, yet effective course on Excel DAX, Data Models & Relationships and working with enormous data volumes

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

"]

Students: 2058, Price: $99.99

Students: 2058, Price:  Paid

With Excel's impressive Power Pivot, you can import millions of rows of data, create mashups from different data sources and build sophisticated data models with ease.  This allows you to analyse your data and share insights with just a few clicks of your mouse.  If you are eager to learn about Excel's Power Pivot without sitting through days of training, this is the course for you. 

WHAT STUDENTS ARE SAYING:

"A great set of content about DAX functions & Power Pivot. Easy to learn content & great way of explaining the Excel formulas."

"This course opened my eyes to new ways to use Power Pivot. There is so much information packed into this course. Thank you for a great course. Now, on to your Power Query course!"

"Great course, especially if you have some knowledge already with excel or Power BI, easy to follow and goes in the right amount of detail."

WHAT YOU CAN EXPECT:

  1. Introduction and Course Content

  2. Power Pivot & the Data Model

  3. Power Pivot & Pivot Tables

  4. Creating Calculated Columns - Basic calculations, using date fields and date tables

  5. Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula and Time Intelligence

  6. Case Studies

  7. Creating Relationships between tables and using relationship calculations

  8. Using KPIs visualizations in the data model

  9. Creating and using hierarchies

ABOUT THE TRAINER

Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight.

Ian has over 100,000 students and 50,000 reviews with an average course rating of over 4.5 stars out of 5. He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time.

WHY YOU SHOULD SIGN UP:

Learners buying this course get:

  • Full access to 4 hours of HD quality video

  • 5 downloadable resources and 10 articles

  • Lifetime access

  • Money-back guarantee (see Udemy terms and Conditions)

  • Certificate of completion upon course conclusion

We look forward to having you on the course!

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

DATA ANALYSIS COURSES ROADMAP:

You can see all of Ian's other Data Analysis courses by searching for his name on Udemy.

  • Excel

    • Complete Introduction to Excel Pivot Tables and Pivot Charts

    • Complete Introduction to Excel Power Pivot

    • Complete Introduction to Excel Power Query

    • Excel Interactive Dashboards and Data Analysis

    • Complete Introduction to Business Data Analysis

    • Tables and Formulas with Excel [2020 Edition]

  • Power BI

    • Complete Introduction to Microsoft Power BI [2020 Edition]

    • Power BI Master Class - Query Editor [2020 Edition]

    • Power BI Master Class-Data Models and DAX Formulas 2020

    • Power BI Master Class - Dashboards and Power BI Service 2020

    • Introduction to Data Analysis with Microsoft Power BI

  • Google Data Studio

    • Complete Introduction to Google Sheets Pivot Tables

    • Complete Introduction to Google Data Studio 2020 Edition

    • Google Analytics Reports and Dashboards with Data Studio

Joins and Append data techniques in Power Query & POWER BI

Joins and Append data techniques in Power Query & POWER BI

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 2033, Price: Free

Students: 2033, Price:  Free

Merge queries is one way to combine queries (or even different tables within the same query) in Power Query/M. Combining two data sets with each other can be done in multiple ways. One of the ways of combining data sets with each other is Merging data sets. Merge is similar to Join in relational databases. Merging two data sets with each other requires some joining fields, and the result will be a combined set of columns from both data sets. Append means results of two (or more) queries (which are tables themselves) will be combined into one query in this way: Rows will be appended after each other.