Udemy - Easy Excel Dashboards, Models, Visualizations & Power Que...

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 521.1 MB
  • Uploaded By coursedrive
  • Downloads 179
  • Last checked 5 minutes ago
  • Date uploaded 3 days ago
  • Seeders 1
  • Leechers 0

Infohash : DD60C223343CB44E16C97521B25C52381872C050

Easy Excel Dashboards, Models, Visualizations & Power Query Download

Build Professional Dashboards with No Formulas. Rapid Step by Step Beginner to Advanced. Get & Transform Data with Ease



What you'll learn

Rapidly build interactive dashboards which are robust and easy to update
Requirements
Basic Excel Skills

Description

Rapidly build robust dashboards in Excel by following a simple step by step process that requires no formulas. Beginners can get started easily due the lack of formulas. Advanced users will learn to structure their dashboards like software developers so that they become more automated with no additional work.

Not many people are aware how much can be done with no or very few formulas in Excel. This not only makes the design simpler it also makes it more robust, reduces risk and improve performance.

Jonathan trained as a Microsoft Certified Trainer and has used advanced Excel for over a decade.

Who this course is for:

If you currently build or wish to build dashboards in Excel




For More Tutorials Visit : freetutorials

Files:

Easy Excel Dashboards, Models, Visualizations & Power Query Easy Excel Dashboards, Models, Visualizations & Power Query 1. Introduction
  • 4. Tidy Data.mp4 (81.7 MB)
  • 1. Introduction.mp4 (22.9 MB)
  • 2. 20 Minute Dashboard - No Formula Required.mp4 (67.4 MB)
  • 2.1 Employees2017.csv.csv (2.4 MB)
  • 2.2 PivotDashboard.xlsx.xlsx (2.3 MB)
  • 3. Structure Like a Software Developer.mp4 (43.9 MB)
  • 5. Tables - Essential Step.mp4 (32.5 MB)
  • Must Read.txt (0.5 KB)
  • Visit Coursedrive.org.url (0.1 KB)
  • ReadMe.txt (0.5 KB)
  • Visit Coursedrive.org.url (0.1 KB)
  • 2. Get & Transform
    • 1. Automate Refresh with Power Query.mp4 (16.6 MB)
    • 2. Merging Data an Alternative to VLookups or DB Joins.mp4 (21.2 MB)
    • 2.1 MergingData.zip.zip (0.6 KB)
    • 3. Merge a Folder of Files.mp4 (24.8 MB)
    • 3.1 Employees2011to2017.zip.zip (3.6 MB)
    • 4. Transforming Pivot Data.mp4 (24.2 MB)
    • 4.1 PowerQueryUnpivot.xlsx.xlsx (10.7 KB)
    • 4.2 PowerQueryFill.xlsx.xlsx (17.0 KB)
    3. Modelling
    • 1. Input Driver Sheet with Named Ranges.mp4 (10.6 MB)
    • 2. Compensation Cost Modelling Intro.mp4 (4.3 MB)
    • 3. Power Query vs Worksheet Calculations.mp4 (14.2 MB)
    • 4. Driver Based Model.mp4 (12.0 MB)
    • 5. What If Analysis - Goal Seek, Solver, Scenario Manager.mp4 (15.0 MB)
    • 5.1 CompensationCostModel.xlsx.xlsx (1.9 MB)
    4. New Visualisations
    • 1. Excel Treemaps and Sunbursts vs Power BI.mp4 (22.8 MB)
    • 1.1 Treemaps.xlsx.xlsx (34.0 KB)
    • 2. 3D Maps.mp4 (15.7 MB)
    • 2.1 3dMaps.xlsx.xlsx (414.8 KB)
    5. Conclusion and Extra Resources
    • 1. How to Reach the Next Level.mp4 (18.9 MB)
    • 2. Bonus Move to the Next Level with a 95% OFF Discount.html (0.4 KB)
    • 2.1 R Tidyverse Reporting and Analytics for Excel Users - Only $9.99‚Äč!.html (0.2 KB)
    • 3. Vlookup vs Power Query vs DB Joins vs OLAP vs R.mp4 (61.7 MB)
    • ReadMe.txt (0.5 KB)
    • Visit Coursedrive.org.url (0.1 KB)
    • Visit Coursedrive.org.url (0.1 KB)
    • Course Downloaded from coursedrive.org.txt (0.5 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • UDP://TRACKER.LEECHERS-PARADISE.ORG:6969/ANNOUNCE