Udemy - Easy Excel Dashboards, Models, Visualizations & Power Query [Course Drive]

seeders: 0
leechers: 3
updated:
Download torrent
Added by coursedrive in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 152
  • Language: English

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)

Description

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



Download torrent
521.1 MB
seeders:0
leechers:3
Udemy - Easy Excel Dashboards, Models, Visualizations & Power Query [Course Drive]

Trackers

tracker name
UDP://TRACKER.LEECHERS-PARADISE.ORG:6969/ANNOUNCE
µTorrent compatible trackers list

Download torrent
521.1 MB
seeders:0
leechers:3
Udemy - Easy Excel Dashboards, Models, Visualizations & Power Query [Course Drive]

Torrent hash: DD60C223343CB44E16C97521B25C52381872C050