Microsoft Excel Training – Power Pivot, Power Query & DAX

seeders: 55
leechers: 59
updated:
Download torrent
Added by tutsnode in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 119
  • Language: English

Files

Microsoft Excel Training - Power Pivot, Power Query & DAX [TutsNode.net] - Microsoft Excel Training - Power Pivot, Power Query & DAX 9. Extras
  • 1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4 (555.5 MB)
  • 1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.srt (83.9 KB)
  • 2. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html (0.0 KB)
  • 2.1 PC Excel Most Used.pdf (2.2 MB)
1. Introduction
  • 1. Welcome and Overview.srt (2.9 KB)
  • 2. WATCH ME Essential Information for a Successful Training Experience.srt (2.0 KB)
  • 3. DOWNLOAD ME Course Exercise Files.html (1.0 KB)
  • 4. DOWNLOAD ME Course Demo Files.html (1.0 KB)
  • 7. Section 1 Quiz.html (0.2 KB)
  • 5. What is Power Query.srt (5.5 KB)
  • 6. What is Power Pivot.srt (3.8 KB)
  • 2. WATCH ME Essential Information for a Successful Training Experience.mp4 (37.9 MB)
  • 4.1 PowerQuery, PowerPivot and Dax Demo Files.zip (26.0 MB)
  • 5. What is Power Query.mp4 (16.9 MB)
  • 6. What is Power Pivot.mp4 (12.5 MB)
  • 1. Welcome and Overview.mp4 (12.3 MB)
  • 3.1 Exercise Files.zip (1.3 MB)
10. Bonuses
  • 1. Ten Excel Tips and Tricks - Part 1.srt (61.7 KB)
  • 2. Ten Excel Tips and Tricks - Part 2.srt (58.7 KB)
  • 3. Ten Excel Tips and Tricks - Part 3.srt (47.2 KB)
  • 1. Ten Excel Tips and Tricks - Part 1.mp4 (336.7 MB)
  • 3. Ten Excel Tips and Tricks - Part 3.mp4 (317.7 MB)
  • 2. Ten Excel Tips and Tricks - Part 2.mp4 (293.7 MB)
7. Using PivotTables and Slicers
  • 1. Create PivotTables and PivotCharts.srt (13.2 KB)
  • 3. Create a Top 10 PivotTable.srt (9.8 KB)
  • 2. Using Slicers with your PivotTables.srt (6.8 KB)
  • 4. Practise Exercise.srt (0.7 KB)
  • 5. Section 7 Quiz.html (0.2 KB)
  • 1. Create PivotTables and PivotCharts.mp4 (109.6 MB)
  • 3. Create a Top 10 PivotTable.mp4 (78.8 MB)
  • 2. Using Slicers with your PivotTables.mp4 (56.5 MB)
  • 4. Practise Exercise.mp4 (7.2 MB)
2. Getting Started with Power Query
  • 4. Import Multiple Files from a Folder.srt (13.1 KB)
  • 5. Connect to Data in Another Excel Workbook.srt (11.3 KB)
  • 3. Editing an Existing Query.srt (11.0 KB)
  • 2. Common Power Query Transformations.srt (9.5 KB)
  • 1. Exploring the Power Query Editor.srt (7.0 KB)
  • 7. Get Data From the Web.srt (6.2 KB)
  • 8. Practise Exercise.srt (0.9 KB)
  • 9. Section 2 Quiz.html (0.2 KB)
  • 6. IMPORTANT Checking the Location of your Query's Source.srt (4.0 KB)
  • 3. Editing an Existing Query.mp4 (92.5 MB)
  • 4. Import Multiple Files from a Folder.mp4 (86.3 MB)
  • 2. Common Power Query Transformations.mp4 (72.1 MB)
  • 5. Connect to Data in Another Excel Workbook.mp4 (69.0 MB)
  • 7. Get Data From the Web.mp4 (57.7 MB)
  • 1. Exploring the Power Query Editor.mp4 (47.0 MB)
  • 6. IMPORTANT Checking the Location of your Query's Source.mp4 (25.1 MB)
  • 8. Practise Exercise.mp4 (10.7 MB)
3. Useful Power Query Features
  • 5. Duplicating and Referencing Queries.srt (10.3 KB)
  • 6. Grouping and Aggregating Data.srt (8.7 KB)
  • 7. Conditional Columns in Power Query.srt (8.0 KB)
  • 2. Combine Data from Multiple Tables with Merge Queries.srt (7.4 KB)
  • 4. Stack Data into One Table with Append Queries.srt (6.8 KB)
  • 3. Use Merge Queries to Compare Two Tables.srt (5.7 KB)
  • 1. Unpivoting Columns.srt (5.5 KB)
  • 8. Practise Exercise.srt (1.2 KB)
  • 9. Section 3 Quiz.html (0.2 KB)
  • 5. Duplicating and Referencing Queries.mp4 (69.7 MB)
  • 6. Grouping and Aggregating Data.mp4 (61.5 MB)
  • 7. Conditional Columns in Power Query.mp4 (48.9 MB)
  • 1. Unpivoting Columns.mp4 (45.5 MB)
  • 4. Stack Data into One Table with Append Queries.mp4 (43.3 MB)
  • 2. Combine Data from Multiple Tables with Merge Queries.mp4 (39.0 MB)
  • 3. Use Merge Queries to Compare Two Tables.mp4 (32.6 MB)
  • 8. Practise Exercise.mp4 (10.4 MB)
6. More DAX Measures
  • 1. Create a Date Table in Power Pivot.srt (9.6 KB)
  • 5. Calculate the Percentage of a Total.srt (6.5 KB)
  • 2. The CALCULATE Function.srt (3.4 KB)
  • 3. The DIVIDE Function.srt (3.2 KB)
  • 4. Using the DATESYTD Function.srt (2.3 KB)
  • 6. Practise Exercise.srt (0.9 KB)
  • 7. Section 6 Quiz.html (0.2 KB)
  • 1. Create a Date Table in Power Pivot.mp4 (71.3 MB)
  • 5. Calculate the Percentage of a Total.mp4 (43.5 MB)
  • 2. The CALCULATE Function.mp4 (21.0 MB)
  • 3. The DIVIDE Function.mp4 (19.5 MB)
  • 4. Using the DATESYTD Function.mp4 (14.3 MB)
  • 6. Practise Exercise.mp4 (10.5 MB)
5. Introduction to DAX
  • 3. Creating your First DAX Measure.srt (7.0 KB)
  • 2. Creating Calculated Columns with DAX.srt (5.6 KB)
  • 4. The COUNTROWS Function.srt (5.0 KB)
  • 5. SUMX and RELATED Functions.srt (4.6 KB)
  • 1. Why use DAX.srt (3.3 KB)
  • 6. Practise Exercise.srt (0.7 KB)
  • 7. Section 5 Quiz.html (0.2 KB)
  • 2. Creating Calculated Columns with DAX.mp4 (39.4 MB)
  • 3. Creating your First DAX Measure.mp4 (37.9 MB)
  • 4. The COUNTROWS Function.mp4 (31.3 MB)
  • 5. SUMX and RELATED Functions.mp4 (22.9 MB)
  • 1. Why use DAX.mp4 (11.6 MB)
  • 6. Practise Exercise.mp4 (9.2 MB)
4. Creating the Data Model
  • 3. Creating Relationships Between tables.srt (5.3 KB)
  • 2. Understanding the Power Pivot Window.srt (4.9 KB)
  • 5. Creating a PivotTable from the Data Model.srt (4.6 KB)
  • 7. Grouping Queries.srt (4.2 KB)
  • 4. Managing the Relationships of the Model.srt (3.6 KB)
  • 6. Hide Fields from Client Tools.srt (3.4 KB)
  • 1. Enable the Power Pivot Add-In.srt (1.9 KB)
  • 8. Practise Exercise.srt (0.7 KB)
  • 9. Section 4 Quiz

Description


Description

**This course includes practice exercises and LIFETIME access**

In this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.

We first look at how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.

If you’ve reached a point where you need Excel to work with data at scale, then these tools will unlock that capability. This course also includes practice exercises and follow-along files so you can build your data models as we go.

In this course you will learn:

How to get started with Power Query
How to connect Excel to multiple workbooks
How to get data from the web and other sources
How to merge and append queries using Power Query
How the Power Pivot window works
How to set up and manage relationships in a data model
How to create a PivotTable to display your data from the Power Pivot data model
How to add calculated columns using DAX
How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
All about creating Pivot Charts and PivotTables and using your data model
How to use slicers to adjust the data you display

This course includes:

3+ hours of video tutorials
44 individual video lectures
Exercise files to practice what you learned
Certificate of completion

This course was recorded using Excel from Office 365. It’s also relevant to those using other, recent versions of Microsoft Excel.

Here’s what our students are saying…

“The instructor speaks with a great deal of clarity and breaks down the concept in a simple manner. Enjoying the course so far! :-)”

– Kamal Yusuf

“It’s been an amazing experience! Worth to try it… There are so many things I didn’t know about, and it’s a good opportunity to remind some basic steps. EXCELLENT WORK !!! HIGHLY RECOMMEND IT!!!”

– Andriana

Did you know?

Simon Sez IT teaches all sorts of software, including:

– Microsoft Excel

– Microsoft PowerPoint

– Microsoft Word

– Microsoft Project

– Microsoft Outlook

– QuickBooks

– Photoshop Elements

– Web Development Languages

– And so much more!
Who this course is for:

Advanced Excel Users

Requirements

You’ll need a copy of Microsoft Excel that is compatible with the Power Pivot tool.
A good understanding of MS Excel. This is an advanced level course.

Last Updated 12/2022



Download torrent
3.1 GB
seeders:55
leechers:59
Microsoft Excel Training – Power Pivot, Power Query & DAX

Trackers

tracker name
udp://open.stealth.si:80/announce
udp://tracker.tiny-vps.com:6969/announce
udp://fasttracker.foreverpirates.co:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://explodie.org:6969/announce
udp://tracker.cyberia.is:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.uw0.xyz:6969/announce
udp://opentracker.i2p.rocks:6969/announce
udp://tracker.birkenwald.de:6969/announce
udp://tracker.torrent.eu.org:451/announce
udp://tracker.moeking.me:6969/announce
udp://tracker.dler.org:6969/announce
udp://9.rarbg.me:2970/announce
µTorrent compatible trackers list

Download torrent
3.1 GB
seeders:55
leechers:59
Microsoft Excel Training – Power Pivot, Power Query & DAX

Torrent hash: 65019EE4FA5073829A6D11D82626C78B1C08AE3E