|  

Microsoft Excel Training – Power Pivot, Power Query & DAX
Size :3.1 GB
Peers : Seeders : 0      Leechers : 0
Added : 1 year ago » by tutsnode » in Other
Language : English
Last Updated :6 months ago
Info_Hash :65019EE4FA5073829A6D11D82626C78B1C08AE3E

Torrent File Contents

Microsoft Excel Training – Power Pivot, Power Query & DAX
  [TutsNode.net] - 9. Extras/1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4
  -  555.48 MB

  TutsNode.net.txt
  -  63 Bytes

  [TutsNode.net] - 9. Extras/1. EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.srt
  -  83.88 KB

  [TutsNode.net] - 1. Introduction/1. Welcome and Overview.srt
  -  2.93 KB

  [TutsNode.net] - 10. Bonuses/1. Ten Excel Tips and Tricks - Part 1.srt
  -  61.74 KB

  [TutsNode.net] - 1. Introduction/2. WATCH ME Essential Information for a Successful Training Experience.srt
  -  1.97 KB

  [TutsNode.net] - 1. Introduction/3. DOWNLOAD ME Course Exercise Files.html
  -  989 Bytes

  [TutsNode.net] - 10. Bonuses/2. Ten Excel Tips and Tricks - Part 2.srt
  -  58.65 KB

  [TutsNode.net] - 1. Introduction/4. DOWNLOAD ME Course Demo Files.html
  -  990 Bytes

  [TutsNode.net] - 10. Bonuses/3. Ten Excel Tips and Tricks - Part 3.srt
  -  47.17 KB

  [TutsNode.net] - 7. Using PivotTables and Slicers/1. Create PivotTables and PivotCharts.srt
  -  13.23 KB

  [TutsNode.net] - 2. Getting Started with Power Query/4. Import Multiple Files from a Folder.srt
  -  13.06 KB

  [TutsNode.net] - 2. Getting Started with Power Query/5. Connect to Data in Another Excel Workbook.srt
  -  11.26 KB

  [TutsNode.net] - 2. Getting Started with Power Query/3. Editing an Existing Query.srt
  -  11 KB

  [TutsNode.net] - 1. Introduction/7. Section 1 Quiz.html
  -  203 Bytes

  [TutsNode.net] - 3. Useful Power Query Features/5. Duplicating and Referencing Queries.srt
  -  10.28 KB

  [TutsNode.net] - 7. Using PivotTables and Slicers/3. Create a Top 10 PivotTable.srt
  -  9.76 KB

  [TutsNode.net] - 6. More DAX Measures/1. Create a Date Table in Power Pivot.srt
  -  9.58 KB

  [TutsNode.net] - 3. Useful Power Query Features/6. Grouping and Aggregating Data.srt
  -  8.69 KB

  [TutsNode.net] - 2. Getting Started with Power Query/2. Common Power Query Transformations.srt
  -  9.5 KB

  [TutsNode.net] - 3. Useful Power Query Features/7. Conditional Columns in Power Query.srt
  -  7.98 KB

  [TutsNode.net] - 3. Useful Power Query Features/2. Combine Data from Multiple Tables with Merge Queries.srt
  -  7.42 KB

  [TutsNode.net] - 5. Introduction to DAX/3. Creating your First DAX Measure.srt
  -  7.02 KB

  [TutsNode.net] - 2. Getting Started with Power Query/1. Exploring the Power Query Editor.srt
  -  6.99 KB

  [TutsNode.net] - 7. Using PivotTables and Slicers/2. Using Slicers with your PivotTables.srt
  -  6.8 KB

  [TutsNode.net] - 3. Useful Power Query Features/4. Stack Data into One Table with Append Queries.srt
  -  6.77 KB

  [TutsNode.net] - 6. More DAX Measures/5. Calculate the Percentage of a Total.srt
  -  6.53 KB

  [TutsNode.net] - 2. Getting Started with Power Query/7. Get Data From the Web.srt
  -  6.21 KB

  [TutsNode.net] - 3. Useful Power Query Features/3. Use Merge Queries to Compare Two Tables.srt
  -  5.74 KB

  [TutsNode.net] - 5. Introduction to DAX/2. Creating Calculated Columns with DAX.srt
  -  5.6 KB

  [TutsNode.net] - 2. Getting Started with Power Query/8. Practise Exercise.srt
  -  940 Bytes

  [TutsNode.net] - 2. Getting Started with Power Query/9. Section 2 Quiz.html
  -  203 Bytes

  [TutsNode.net] - 3. Useful Power Query Features/1. Unpivoting Columns.srt
  -  5.49 KB

  [TutsNode.net] - 1. Introduction/5. What is Power Query.srt
  -  5.46 KB

  [TutsNode.net] - 4. Creating the Data Model/3. Creating Relationships Between tables.srt
  -  5.3 KB

  [TutsNode.net] - 5. Introduction to DAX/4. The COUNTROWS Function.srt
  -  4.97 KB

  [TutsNode.net] - 4. Creating the Data Model/2. Understanding the Power Pivot Window.srt
  -  4.93 KB

  [TutsNode.net] - 5. Introduction to DAX/5. SUMX and RELATED Functions.srt
  -  4.61 KB

  [TutsNode.net] - 4. Creating the Data Model/5. Creating a PivotTable from the Data Model.srt
  -  4.57 KB

  [TutsNode.net] - 4. Creating the Data Model/7. Grouping Queries.srt
  -  4.21 KB

  [TutsNode.net] - 2. Getting Started with Power Query/6. IMPORTANT Checking the Location of your Query's Source.srt
  -  4.02 KB

  [TutsNode.net] - 1. Introduction/6. What is Power Pivot.srt
  -  3.75 KB

  [TutsNode.net] - 4. Creating the Data Model/4. Managing the Relationships of the Model.srt
  -  3.56 KB

  [TutsNode.net] - 6. More DAX Measures/2. The CALCULATE Function.srt
  -  3.36 KB

  [TutsNode.net] - 4. Creating the Data Model/6. Hide Fields from Client Tools.srt
  -  3.35 KB

  [TutsNode.net] - 5. Introduction to DAX/1. Why use DAX.srt
  -  3.31 KB

  [TutsNode.net] - 6. More DAX Measures/3. The DIVIDE Function.srt
  -  3.19 KB

  [TutsNode.net] - 3. Useful Power Query Features/8. Practise Exercise.srt
  -  1.22 KB

  [TutsNode.net] - 3. Useful Power Query Features/9. Section 3 Quiz.html
  -  203 Bytes

  [TutsNode.net] - 6. More DAX Measures/4. Using the DATESYTD Function.srt
  -  2.33 KB

  [TutsNode.net] - 4. Creating the Data Model/1. Enable the Power Pivot Add-In.srt
  -  1.91 KB

  [TutsNode.net] - 8. Closing/1. Wrap Up.srt
  -  1.44 KB

  [TutsNode.net] - 6. More DAX Measures/6. Practise Exercise.srt
  -  909 Bytes

  [TutsNode.net] - 4. Creating the Data Model/8. Practise Exercise.srt
  -  739 Bytes

  [TutsNode.net] - 5. Introduction to DAX/6. Practise Exercise.srt
  -  710 Bytes

  [TutsNode.net] - 7. Using PivotTables and Slicers/4. Practise Exercise.srt
  -  676 Bytes

  [TGx]Downloaded from torrentgalaxy.buzz .txt
  -  585 Bytes

  [TutsNode.net] - 4. Creating the Data Model/9. Section 4 Quiz.html
  -  203 Bytes

  [TutsNode.net] - 5. Introduction to DAX/7. Section 5 Quiz.html
  -  203 Bytes

  [TutsNode.net] - 6. More DAX Measures/7. Section 6 Quiz.html
  -  203 Bytes

  [TutsNode.net] - 7. Using PivotTables and Slicers/5. Section 7 Quiz.html
  -  203 Bytes

  [TutsNode.net] - 9. Extras/2. EXTRA RESOURCE The Most Frequently Used Excel Shortcuts - Infographic.html
  -  25 Bytes

  .pad/0
  -  34.83 KB

  [TutsNode.net] - 10. Bonuses/1. Ten Excel Tips and Tricks - Part 1.mp4
  -  336.72 MB

  .pad/1
  -  284.59 KB

  [TutsNode.net] - 10. Bonuses/3. Ten Excel Tips and Tricks - Part 3.mp4
  -  317.67 MB

  .pad/2
  -  337.38 KB

  [TutsNode.net] - 10. Bonuses/2. Ten Excel Tips and Tricks - Part 2.mp4
  -  293.72 MB

  .pad/3
  -  287.36 KB

  [TutsNode.net] - 7. Using PivotTables and Slicers/1. Create PivotTables and PivotCharts.mp4
  -  109.61 MB

  .pad/4
  -  396.93 KB

  [TutsNode.net] - 2. Getting Started with Power Query/3. Editing an Existing Query.mp4
  -  92.54 MB

  .pad/5
  -  472.18 KB

  [TutsNode.net] - 2. Getting Started with Power Query/4. Import Multiple Files from a Folder.mp4
  -  86.28 MB

  .pad/6
  -  733.45 KB

  [TutsNode.net] - 7. Using PivotTables and Slicers/3. Create a Top 10 PivotTable.mp4
  -  78.76 MB

  .pad/7
  -  243.22 KB

  [TutsNode.net] - 2. Getting Started with Power Query/2. Common Power Query Transformations.mp4
  -  72.11 MB

  .pad/8
  -  911.97 KB

  [TutsNode.net] - 6. More DAX Measures/1. Create a Date Table in Power Pivot.mp4
  -  71.25 MB

  .pad/9
  -  767.79 KB

  [TutsNode.net] - 3. Useful Power Query Features/5. Duplicating and Referencing Queries.mp4
  -  69.75 MB

  .pad/10
  -  258.91 KB

  [TutsNode.net] - 2. Getting Started with Power Query/5. Connect to Data in Another Excel Workbook.mp4
  -  68.95 MB

  .pad/11
  -  51.17 KB

  [TutsNode.net] - 3. Useful Power Query Features/6. Grouping and Aggregating Data.mp4
  -  61.47 MB

  .pad/12
  -  538.79 KB

  [TutsNode.net] - 2. Getting Started with Power Query/7. Get Data From the Web.mp4
  -  57.75 MB

  .pad/13
  -  259.4 KB

  [TutsNode.net] - 7. Using PivotTables and Slicers/2. Using Slicers with your PivotTables.mp4
  -  56.51 MB

  .pad/14
  -  497.89 KB

  [TutsNode.net] - 3. Useful Power Query Features/7. Conditional Columns in Power Query.mp4
  -  48.93 MB

  .pad/15
  -  68.58 KB

  [TutsNode.net] - 2. Getting Started with Power Query/1. Exploring the Power Query Editor.mp4
  -  47 MB

  .pad/16
  -  3.43 KB

  [TutsNode.net] - 3. Useful Power Query Features/1. Unpivoting Columns.mp4
  -  45.53 MB

  .pad/17
  -  484.37 KB

  [TutsNode.net] - 6. More DAX Measures/5. Calculate the Percentage of a Total.mp4
  -  43.52 MB

  .pad/18
  -  495.71 KB

  [TutsNode.net] - 3. Useful Power Query Features/4. Stack Data into One Table with Append Queries.mp4
  -  43.26 MB

  .pad/19
  -  754.04 KB

  [TutsNode.net] - 5. Introduction to DAX/2. Creating Calculated Columns with DAX.mp4
  -  39.38 MB

  .pad/20
  -  637.46 KB

  [TutsNode.net] - 3. Useful Power Query Features/2. Combine Data from Multiple Tables with Merge Queries.mp4
  -  38.97 MB

  .pad/21
  -  35.23 KB

  [TutsNode.net] - 1. Introduction/2. WATCH ME Essential Information for a Successful Training Experience.mp4
  -  37.91 MB

  .pad/22
  -  90.35 KB

  [TutsNode.net] - 5. Introduction to DAX/3. Creating your First DAX Measure.mp4
  -  37.87 MB

  .pad/23
  -  132.45 KB

  [TutsNode.net] - 4. Creating the Data Model/7. Grouping Queries.mp4
  -  36.13 MB

  .pad/24
  -  891.81 KB

  [TutsNode.net] - 4. Creating the Data Model/2. Understanding the Power Pivot Window.mp4
  -  35.62 MB

  .pad/25
  -  392.66 KB

  [TutsNode.net] - 3. Useful Power Query Features/3. Use Merge Queries to Compare Two Tables.mp4
  -  32.6 MB

  .pad/26
  -  409.85 KB

  [TutsNode.net] - 5. Introduction to DAX/4. The COUNTROWS Function.mp4
  -  31.28 MB

  .pad/27
  -  741.45 KB

  [TutsNode.net] - 4. Creating the Data Model/5. Creating a PivotTable from the Data Model.mp4
  -  30.66 MB

  .pad/28
  -  351.82 KB

  [TutsNode.net] - 1. Introduction/4.1 PowerQuery, PowerPivot and Dax Demo Files.zip
  -  25.98 MB

  .pad/29
  -  20.64 KB

  [TutsNode.net] - 2. Getting Started with Power Query/6. IMPORTANT Checking the Location of your Query's Source.mp4
  -  25.07 MB

  .pad/30
  -  950.9 KB

  [TutsNode.net] - 5. Introduction to DAX/5. SUMX and RELATED Functions.mp4
  -  22.91 MB

  .pad/31
  -  87.1 KB

  [TutsNode.net] - 6. More DAX Measures/2. The CALCULATE Function.mp4
  -  20.99 MB

  .pad/32
  -  14.87 KB

  [TutsNode.net] - 6. More DAX Measures/3. The DIVIDE Function.mp4
  -  19.52 MB

  .pad/33
  -  491.57 KB

  [TutsNode.net] - 1. Introduction/5. What is Power Query.mp4
  -  16.92 MB

  .pad/34
  -  80.2 KB

  [TutsNode.net] - 4. Creating the Data Model/6. Hide Fields from Client Tools.mp4
  -  15.5 MB

  .pad/35
  -  509.69 KB

  [TutsNode.net] - 4. Creating the Data Model/3. Creating Relationships Between tables.mp4
  -  15.43 MB

  .pad/36
  -  585.11 KB

  [TutsNode.net] - 4. Creating the Data Model/4. Managing the Relationships of the Model.mp4
  -  14.57 MB

  .pad/37
  -  444.79 KB

  [TutsNode.net] - 4. Creating the Data Model/1. Enable the Power Pivot Add-In.mp4
  -  14.55 MB

  .pad/38
  -  460.14 KB

  [TutsNode.net] - 6. More DAX Measures/4. Using the DATESYTD Function.mp4
  -  14.28 MB

  .pad/39
  -  742.2 KB

  [TutsNode.net] - 1. Introduction/6. What is Power Pivot.mp4
  -  12.51 MB

  .pad/40
  -  504.19 KB

  [TutsNode.net] - 1. Introduction/1. Welcome and Overview.mp4
  -  12.28 MB

  .pad/41
  -  737.03 KB

  [TutsNode.net] - 5. Introduction to DAX/1. Why use DAX.mp4
  -  11.58 MB

  .pad/42
  -  424.97 KB

  [TutsNode.net] - 2. Getting Started with Power Query/8. Practise Exercise.mp4
  -  10.68 MB

  .pad/43
  -  326.56 KB

  [TutsNode.net] - 6. More DAX Measures/6. Practise Exercise.mp4
  -  10.47 MB

  .pad/44
  -  547.28 KB

  [TutsNode.net] - 3. Useful Power Query Features/8. Practise Exercise.mp4
  -  10.38 MB

  .pad/45
  -  634.06 KB

  [TutsNode.net] - 5. Introduction to DAX/6. Practise Exercise.mp4
  -  9.17 MB

  .pad/46
  -  851.41 KB

  [TutsNode.net] - 4. Creating the Data Model/8. Practise Exercise.mp4
  -  8.94 MB

  .pad/47
  -  62.69 KB

  [TutsNode.net] - 7. Using PivotTables and Slicers/4. Practise Exercise.mp4
  -  7.21 MB

  .pad/48
  -  808.74 KB

  [TutsNode.net] - 8. Closing/1. Wrap Up.mp4
  -  2.54 MB

  .pad/49
  -  475.3 KB

  [TutsNode.net] - 9. Extras/2.1 PC Excel Most Used.pdf
  -  2.18 MB

  .pad/50
  -  837.64 KB

  [TutsNode.net] - 1. Introduction/3.1 Exercise Files.zip
  -  1.27 MB



Torrent 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