| 0 | 31.3 KB | ||
| 1 | 167.6 KB | ||
| 1 - Why do we need to use Power Query Power Pivot.mp4 | 10.9 MB | ||
| 10 - Checking errors and remove columns and rows in Power Query.mp4 | 106.1 MB | ||
| 11 - How to add Index number in Power Query.mp4 | 73.4 MB | ||
| 12 - Merging Queries in Power Query.mp4 | 74.1 MB | ||
| 13 - Basic way to Append Queries.mp4 | 93.5 MB | ||
| 14 - Best way to Append Queries using Folder with Auto Update.mp4 | 71.3 MB | ||
| 15 - Creating a Custom Calendar Table in Power Query.mp4 | 142 MB | ||
| 16 - Better way to Create a Date Table in Power Query Auto Update.mp4 | 50.5 MB | ||
| 17 - How to Move data into Power Pivot from Worksheet.mp4 | 34.9 MB | ||
| 18 - Important Data Source Settings in Power Query.mp4 | 50.3 MB | ||
| 19 - Data view vs Diagram view.mp4 | 48.6 MB | ||
| 2 - Advanced Process to a Better Dashboard Creation.mp4 | 6.4 MB | ||
| 2 | 849.6 KB | ||
| 3 | 673.7 KB | ||
| 4 | 969.2 KB | ||
| 20 - Understand Database Normalization.mp4 | 30.2 MB | ||
| 21 - Creating Relationships in Power Pivot.mp4 | 93.4 MB | ||
| 22 - How to Edit Relationships in Power Pivot.mp4 | 65 MB | ||
| 23 - Power Pivot view vs Normal Excel Pivot Table.mp4 | 68.3 MB | ||
| 24 - Power Query and Data Modelling conclusion.mp4 | 5.8 MB | ||
| 25 - Introduction to DAX in Excel Power Pivot.mp4 | 6.5 MB | ||
| 26 - How to add DAX Calculated Column.mp4 | 133.2 MB | ||
| 27 - Calculated Column with Dax If function.mp4 | 63.8 MB | ||
| 28 - Calculated Column with Dax Switch function.mp4 | 48.6 MB | ||
| 29 - Total Revenue with Calculated Column.mp4 | 67.8 MB | ||
| 3 - All-Resources.zip | 30.5 MB | ||
| 3 - Course Materials.mp4 | 3.2 MB | ||
| 30 - Introduction to DAX Measures in Power Pivot.mp4 | 173.8 MB | ||
| 31 - How to write DAX using the Measure BOX.mp4 | 45.1 MB | ||
| 32 - Implicit vs Explicit Measures.mp4 | 52.5 MB | ||
| 33 - How to create a Separate Measures Table.mp4 | 89.3 MB | ||
| 34 - How to calculate COGS and Gross profit.mp4 | 27.7 MB | ||
| 35 - Calculating returned Rate using DAX.mp4 | 121.1 MB | ||
| 36 - How to use DAX All Function.mp4 | 71.4 MB | ||
| 37 - How to use the DAX Filter Function.mp4 | 63.9 MB | ||
| 38 - Filtering Table with DAX Function.mp4 | 74.6 MB | ||
| 39 - How to mark your Date Table.mp4 | 7.3 MB | ||
| 4 - All-Resources.zip | 30.5 MB | ||
| 4 - Complet-Dashboard.zip | 4.9 MB | ||
| 4 - Complet-Dataset-for-practice.zip | 8.2 MB | ||
| 4 - Customer-Dashboard-and-dataset.zip | 10.6 MB | ||
| 4 - Project Overview.mp4 | 44.9 MB | ||
| 5 | 448.7 KB | ||
| 5 - How to Activate Microsoft Excel Power Pivot.mp4 | 23 MB | ||
| 6 | 221.2 KB | ||
| 7 | 406.2 KB | ||
| 9 | 1.6 KB | ||
| 10 | 275.6 KB | ||
| 11 | 990.3 KB | ||
| 12 | 282.8 KB | ||
| 13 | 279.3 KB | ||
| 15 | 626.5 KB | ||
| 16 | 511.3 KB | ||
| 17 | 800.4 KB | ||
| 18 | 171.4 KB | ||
| 19 | 258.2 KB | ||
| 20 | 969.6 KB | ||
| 21 | 283.1 KB | ||
| 22 | 9.5 KB | ||
| 23 | 441.5 KB | ||
| 24 | 798.9 KB | ||
| 25 | 873 KB | ||
| 26 | 592 KB | ||
| 27 | 67.4 KB | ||
| 28 | 751.9 KB | ||
| 29 | 202.9 KB | ||
| 30 | 489 KB | ||
| 31 | 635.9 KB | ||
| 32 | 770.1 KB | ||
| 33 | 682.8 KB | ||
| 34 | 312.9 KB | ||
| 35 | 771 KB | ||
| 36 | 938.4 KB | ||
| 37 | 440.2 KB | ||
| 38 | 871.9 KB | ||
| 39 | 902.8 KB | ||
| 40 | 403.7 KB | ||
| 40 - Time Intelligence YTD MTD and QTD DAX Function.mp4 | 137.5 MB | ||
| 41 - Last month Revenue and MoM percentage Change.mp4 | 148.7 MB | ||
| 41 | 564.1 KB | ||
| 42 | 621.4 KB | ||
| 42 - How to calculate 10Days Rolling total.mp4 | 42.6 MB | ||
| 43 | 610.2 KB | ||
| 43 - How to calculate 10 Days Transactional Average.mp4 | 36.5 MB | ||
| 44 - Better to Count using DAX.mp4 | 73.6 MB | ||
| 44 | 751.6 KB | ||
| 45 - Dashboard overview.mp4 | 24.2 MB | ||
| 45 | 548.5 KB | ||
| 46 | 810 KB | ||
| 46 - Setting Dashboard Canvas.mp4 | 33.8 MB | ||
| 47 | 220.8 KB | ||
| 47 - How to add MCode Last Update date code.mp4 | 70.5 MB | ||
| 48 | 276.6 KB | ||
| 48 - Adding values to cards.mp4 | 53.3 MB | ||
| 49 - Adding Icons.mp4 | 24.5 MB | ||
| 49 | 735.2 KB | ||
| 50 | 994.7 KB | ||
| 50 - Adding new cards with Gradient colors.mp4 | 74.1 MB | ||
| 51 | 200.6 KB | ||
| 51 - How to create a Dynamic Top N in Excel.mp4 | 161 MB | ||
| 52 | 11.3 KB | ||
| 52 - Creating a dynamic Title.mp4 | 62.7 MB | ||
| 53 - How to create multiple Doughnut chart.mp4 | 131.7 MB | ||
| 53 | 100.3 KB | ||
| 54 - Inserting a Bar charts.mp4 | 114.7 MB | ||
| 54 | 220.9 KB | ||
| 55 - How to create a Map chart.mp4 | 108.6 MB | ||
| 55 | 306.9 KB | ||
| 56 - 5 Less and Top Profitable Cities.mp4 | 37.6 MB | ||
| 56 | 561.5 KB | ||
| 57 - How to connect Slicers to PivotTables.mp4 | 62.5 MB | ||
| 57 | 69.3 KB | ||
| 58 | 41.4 KB | ||
| 58 - Adidas-Dataset.zip | 458.4 KB | ||
| 58 - Adidas-dashboard.zip | 1.7 MB | ||
| 58 - Dashboard Overview.mp4 | 55.4 MB | ||
| 59 - Transforming and Cleaning data with Power Query.mp4 | 153 MB | ||
| 6 - Importing data into Power Query.mp4 | 57.9 MB | ||
| 59 | 611 KB | ||
| 60 - Inserting PivotTable and Advanced Number formatting.mp4 | 72.4 MB | ||
| 60 | 652.3 KB | ||
| 61 - Adding Month Filter.mp4 | 83.2 MB | ||
| 61 | 714.7 KB | ||
| 62 - Dynamic way to show previous Month revenue with Percentage Change.mp4 | 170.6 MB | ||
| 62 | 516.8 KB | ||
| 63 - Quantity Ordered and Transaction Cards.mp4 | 21.6 MB | ||
| 63 | 155.2 KB | ||
| 64 - Which Product contributed more to Revenue.mp4 | 175.6 MB | ||
| 64 | 507 KB | ||
| 65 - Which State should we push more Products to.mp4 | 201.2 MB | ||
| 66 | 195.8 KB | ||
| 66 - What is the peak month for 2020 and 2021.mp4 | 176.1 MB | ||
| 67 | 362.1 KB | ||
| 68 - Revenue trend by Weekday.mp4 | 110 MB | ||
| 68 | 389.4 KB | ||
| 69 - Connecting Slicers to PivotTables.mp4 | 68 MB | ||
| 7 - Power Query Transform vs Add Columns explained.mp4 | 138.4 MB | ||
| 65 | 715.7 KB | ||
| 67 - Whats our top Region Sales Channel.mp4 | 102.9 MB | ||
| 70 | 455.2 KB | ||
| 70 - How to create a Single Button that clear all filters.mp4 | 54.4 MB | ||
| 71 - New way to save your work.mp4 | 15.4 MB | ||
| 71 | 918.7 KB | ||
| 72 | 101 KB | ||
| 72 - Formatting Slicers.mp4 | 160.7 MB | ||
| 73 | 392.1 KB | ||
| 73 - Cleaning up your dashboard.mp4 | 106.2 MB | ||
| 74 | 398.4 KB | ||
| 74 - Animated-Images.zip | 1.6 MB | ||
| 74 - Complet-HR-Dashboard.zip | 2.6 MB | ||
| 74 - Dashboard Overview.mp4 | 22.4 MB | ||
| 74 - HR-Dataset.zip | 523.6 KB | ||
| 75 - Importing data into Excel Power Query.mp4 | 142.7 MB | ||
| 76 - Removing unwanted columns in Power Query.mp4 | 93.2 MB | ||
| 77 | 155.9 KB | ||
| 78 - Cleaning the Dashboard area Canvas.mp4 | 19.4 MB | ||
| 8 - Importing Multiple tables into Power Query.mp4 | 51.8 MB | ||
| 9 - Updating your current Workbook Settings to get proper Dates and Time.mp4 | 48 MB | ||
| 75 | 492.8 KB | ||
| 76 | 109.4 KB | ||
| 77 - Transforming Hr data in Excel Power Query.mp4 | 201.3 MB | ||
| 78 | 111.4 KB | ||
| 79 | 546.9 KB | ||
| 79 - Formatting your DataTable.mp4 | 99.3 MB | ||
| 80 | 546.9 KB | ||
| 80 - 06 Employees KPI.mp4 | 69.7 MB | ||
| 81 - Adding shapes to the dashboard environment.mp4 | 29.1 MB | ||
| 81 | 848.6 KB | ||
| 82 | 874.6 KB | ||
| 82 - How to download Gif animated images to Excel.mp4 | 69.8 MB | ||
| 83 | 295.7 KB | ||
| 83 - Creating chart for attrition and current employees.mp4 | 78.1 MB | ||
| 84 | 207 KB | ||
| 84 - Employees by performance Status.mp4 | 105.4 MB | ||
| 85 | 504.2 KB | ||
| 85 - How to create an icon slicer in Excel.mp4 | 93.8 MB | ||
| 86 | 776.4 KB | ||
| 86 - Attrition by distance from work with dynamic legend.mp4 | 84.7 MB | ||
| 87 - Attrition by job role visual.mp4 | 131.8 MB | ||
| 87 | 10.7 KB | ||
| 88 | 600.3 KB | ||
| 88 - Formatting legends.mp4 | 30.9 MB | ||
| 89 - Job role average Attrition.mp4 | 24.8 MB | ||
| 89 | 400.8 KB | ||
| 90 - Attrition by Education types.mp4 | 56 MB | ||
| 90 | 650.4 KB | ||
| 91 | 624.1 KB | ||
| 91 - How to create a custom chart in Microsoft Excel.mp4 | 161 MB | ||
| 92 | 121.9 KB | ||
| 92 - Attrition by age Bucket and Gender.mp4 | 70.2 MB | ||
| 93 | 418.9 KB | ||
| 93 - Custom chart for Gender.mp4 | 192.3 MB | ||
| 94 - Average Age for employees.mp4 | 47.6 MB | ||
| 94 | 808.1 KB | ||
| 95 | 720.9 KB | ||
| 95 - How to format Excel Slicers.mp4 | 228.5 MB | ||
| 96 - Final formatting.mp4 | 48.8 MB | ||
| TutsNode.net.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| 96 | 494.9 KB | ||
| 97 | 566.6 KB | ||
| 98 | 183.7 KB | ||
| 99 | 130.6 KB | ||
| 100 | 769.1 KB | ||
| 101 | 436.9 KB | ||
| 102 | 312.6 KB | ||
| ▲ 208 total files | |||
Description
If you are really new to Excel dashboards or data analytics in general or you want to advance your knowledge, this is the course for you. We have provided you with the fundamentals you need to work with Excel efficiently and effectively.
This dashboard is going to take you through Power Query, Power Pivot, Modeling, and DAX (Data Analysis Expression).
Learning this advanced Excel Dashboard will make you use Power BI with ease as it uses DAX for computation and Power Query for cleaning and data transformation.
Our aim in this course is to show you how to analyze data and create a visualization from the different tables without you using Xlookup, VLOOKUP or Index and Match but just with simple data Modeling in Power Pivot.
This course is 100% practical
Microsoft Excel is the most commonly used data analysis tool available on the market today. In this course, we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)
Say no to a boring dashboard. With this course, you will start creating a very powerful interactive and dynamic Excel dashboard from day one.
If you are ready to learn with me, let’s join the class and see how creative you could be in the few days to come as you begin the class.
Remember you have life Time access to this course.
This course will be updated frequently with the new dashboard.
be free to ask questions should you got stuck in any of the steps.
I am already waiting for you in the class, nice to have you.
Who this course is for:
A data analyst
Anyone working with data
A manager
Business owners
Students
Requirements
Have Microsoft Excel installed
Excel 2016, 2019 ,2021 or Excel 365 would do. Other than this please, upgrade the version of your Excel
Analytics mind-set
Time (You need to invest time for practicing your new skill)
Last Updated 3/2023
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
| 3.8 GB | freecoursewb | 1 month | 19 | 5 | |
| 1.5 GB | freecoursewb | 2 months | 8 | 1 | |
| 1.1 GB | freecoursewb | 2 months | 16 | 6 | |
| 3.8 GB | freecoursewb | 3 months | 11 | 0 |
All Comments