Udemy Microsoft Excel - Excel with Power Pivot & DAX Formulas

Udemy Microsoft Excel - Excel with Power Pivot & DAX Formulas

Learn Microsoft Excel Power Pivot, DAX Formulas, Measures & Relationships in Excel 2010 - Excel 2019 & Office 365 by: John Michaloudis. Microsoft Excel - Excel with Power Pivot & DAX Formulas. 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. In July 2018, Microsoft announced that Excel Power Pivot will now be available in all Windows editions of Excel, which is awesome news and a step in the right direction.

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!

Previously in the 2016 version of Office 365, you needed to have purchased the Office Pro Plus or Office 365 E3 to have access to Power Pivot within Excel. So now you can get Power Pivot in Excel 2010, Excel 2013 and all Office 2016 products, such as: Office 365 Home, Office 365 Personal, Office 365 Business Essentials, Office 365 Business, Office 365 Business Premium, Office 365 Enterprise E1.

Prerequisites for this power pivot course

You need at least an understanding of what Pivot Tables are and how to insert a Pivot Table and create a few calculations.

I am using Excel 2010 in this course but the layout is very similar to Excel 2013, 2016 & 2019. Any variations in versions between Excel 2010 and the other versions, I explain in each tutorial.

In this course we will go through the following Power Pivot features:

Import/Load Data

- Import From Workbook.

- Import From Worksheet.

- Import From Separate Workbooks.

Table Relationships

- Create Relationships.

- Create Relationships via the Diagram View.

Pivot Tables & Slicers

- Create a Pivot Table.

- Insert a Slicer.

Intro to DAX Formulas

- Intro to DAX Formulas.

- Intro to DAX Formulas: Measures vs Calculated Columns - Part 1.

- Intro to DAX Formulas: Measures vs Calculated Columns - Part 2.

- List of various DAX Formulas.

Measures & calculated columns

- DISTINCTCOUNT().

- Create a Unique Order Dates Measure.

- SUM() - Create a Total Sales Measure.

- Combine 2 Measures to get Average Sales Per Date.

- CALCULATE().

- Show Largest Sales Values.

- Calculated Column Extract Years from Order Date.

- CALCULATE().

- Group Years.

- Link a Calendar Table.

- Sort Month Dates Into The Correct Order.

- Add a Hierarchy to the Calendar.

- Combine a Calculated Column with a Measure.

- Net Profit Analysis.

Look, if you are really serious about getting better at excel and advancing your Microsoft Excel level & skills, saving hours each day, day 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 four you! Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

Who this course is for?

Intermediate & Advanced Excel Users.

Course content

- Power Pivot is now available in all versions of Excel.

- Installing Power Pivot in Excel 2010.

- Enabling Power Pivot in Excel 2013.

- Enabling Power Pivot in Excel 2016, Excel 2019 and Office 365 Subscription.

- How do you enable Power Pivot in Excel 2016, 2019 and Office 365.

- Downloadable Workbooks.

- Import From Workbook.

- Import From Worksheet.

- Import From Separate Workbooks.

- Which external data sources can you import data from?

- Downloadable workbooks.

- Create Relationships.

- Create Relationships via the Diagram View.

- When creating a Relationship using Power Pivot, where do the unique values go?

- Downloadable Workbooks.

- Create a Pivot Table.

- Insert a Slicer.

- How do you insert a Slicer?

- Intro to DAX Formulas.

- Intro to DAX Formulas: Measures vs Calculated Columns - Part 1.

- Intro to DAX Formulas: Measures vs Calculated Columns - Part 2.

- DAX Syntax.

- Date and Time Functions.

- Time Intelligence Functions.

- Filter Functions.

- Information Functions.

- Logical Functions.

- Math and Trig Functions.

- Statistical Functions.

- Text Functions.

- Other Functions.

- Where can you write DAX Formulas?

- Downloadable Workbooks.

- DISTINCTCOUNT() - Create a Unique Order Dates Measure.

- SUM() - Create a Total Sales Measure.

- Combine 2 Measures to get Average Sales Per Date.

- CALCULATE() - Filter & Show Individual Product Sales.

- CALCULATE() - Show Largest Sales Values.

- Calculated Column - Extract Years from Order Date.

- CALCULATE() - Group Years.

- Link a Calendar Table.

- Sort Month Dates Into The Correct Order.

- Add a Hierarchy to the Calendar.

- Combine a Calculated Column with a Measure - Net Profit Analysis.

- How do you create a Measure?

- Bonus offer: My other Udemy course: Excel with the A-Z of Excel povot tables.

Udemy Microsoft Excel - Excel with Power Pivot & DAX Formulas