Udemy - MS Excel Exam Guide - Analyzing and Visualizing Data

seeders: 18
leechers: 18
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - MS Excel Exam Guide - Analyzing and Visualizing Data
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1 - Introduction
    • 1 - Welcome and Course Overview English.srt (5.7 KB)
    • 1 - Welcome and Course Overview.mp4 (18.8 MB)
    • 2 - Excel Versions and Addins English.srt (9.2 KB)
    • 2 - Excel Versions and Addins.mp4 (24.7 MB)
    • 3 - EXTRA Learning Path.html (1.4 KB)
    • 4 - Get the Materials.html (0.3 KB)
    2 - Consume and Transform Data Using Microsoft Excel
    • 10 - Transformations English.srt (25.2 KB)
    • 10 - Transformations.mp4 (154.3 MB)
    • 11 - Advanced Transformations Append and Merge English.srt (22.9 KB)
    • 11 - Advanced Transformations Append and Merge.mp4 (128.3 MB)
    • 11 - Join-Types.pptx (747.0 KB)
    • 12 - Advanced Transformations Pivot Unpivot and Group By English.srt (11.7 KB)
    • 12 - Advanced Transformations Pivot Unpivot and Group By.mp4 (64.5 MB)
    • 12 - Pivot-and-Group-By-Practice.xlsx (8.9 KB)
    • 13 - Importing CSVs and Multiple Files English.srt (21.5 KB)
    • 13 - Importing CSVs and Multiple Files.mp4 (204.8 MB)
    • 5 - Company Background and Business Case English.srt (8.5 KB)
    • 5 - Company Background and Business Case.mp4 (34.7 MB)
    • 6 - Manual Lookups using VLOOKUP and Tables English.srt (14.6 KB)
    • 6 - Manual Lookups using VLOOKUP and Tables.mp4 (111.3 MB)
    • 7 - Easier VLOOKUPs using Tables English.srt (8.3 KB)
    • 7 - Easier VLOOKUPs using Tables.mp4 (71.7 MB)
    • 8 - Limitations of Manual Lookups and Combinations English.srt (10.8 KB)
    • 8 - Limitations of Manual Lookups and Combinations.mp4 (91.4 MB)
    • 9 - Introduction to Queries English.srt (20.8 KB)
    • 9 - Introduction to Queries.mp4 (96.4 MB)
      • Excel 70-779 2019 Data
      • Q1 2019.xlsx (23.7 KB)
      • Q2 2019.xlsx (24.6 KB)
      • Q3 2019.xlsx (23.1 KB)
      • Q4 2019.xlsx (25.1 KB)
      2020 Data
      • Q1 2020.xlsx (24.5 KB)
      • Q2 2020.xlsx (23.9 KB)
      Lookups
      • Customers.xlsx (42.3 KB)
      • Employees.xlsx (10.7 KB)
      • Loan Types.xlsx (10.1 KB)
      • Office Locations.xlsx (10.8 KB)
      • Unit Descriptions.xlsx (10.4 KB)
      _Archive
      • 2017.csv (4.7 KB)
      • Q1 2018.csv (4.4 KB)
      • Q2 2018.csv (4.3 KB)
      • Q3 2018.csv (2.8 KB)
      • Q4 2018.csv (4.9 KB)
      3 - Modeling Data using Microsoft Excel
      • 14 - Introduction to Excels Data Model English.srt (18.6 KB)
      • 14 - Introduction to Excels Data Model.mp4 (206.8 MB)
      • 14 - Mortgages-Data-Model.xlsx (112.7 KB)
      • 15 - Enhancing your Data Model with Relationships English.srt (19.1 KB)
      • 15 - Enhancing your Data Model with Relationships.mp4 (98.4 MB)
      • 16 - Introduction to Measures and DAX English.srt (12.6 KB)
      • 16 - Introduction to Measures and DAX.mp4 (104.2 MB)
      • 17 - Common DAX Functions English.srt (29.0 KB)
      • 17 - Common DAX Functions.mp4 (306.6 MB)
      • 18 - Dates and Calendar Tables English.srt (28.8 KB)
      • 18 - Dates and Calendar Tables.mp4 (282.1 MB)
      • 19 - Advanced DAX Functions English.srt (22.7 KB)
      • 19 - Advanced DAX Functions.mp4 (238.4 MB)
      • 19 - Advanced-DAX-Formulas.pptx (767.8 KB)
      • 19 - Mortgages-Data-Model-Advanced-DAX-Starter.xlsx (1.0 MB)
      • 20 - Advanced DAX Functions Pt 2 English.srt (24.2 KB)
      • 20 - Advanced DAX Functions Pt 2.mp4 (206.6 MB)
      • 21 - Basic MDX Functions English.srt (15.4 KB)
      • 21 - Basic MDX Functions.mp4 (112.0 MB)
      • 22 - Creating KPIs English.srt (9.5 KB)
      • 22 - Creating KPIs.mp4 (69.8 MB)
      • 23 - Organizing Data using Hierarchies English.srt (7.0 KB)
      • 23 - Organizing Data using Hierarchies.mp4 (48.6 MB)
      • 24 - Optimizing your Data Model English.srt (8.2 KB)
      • 24 - Optimizing your Data Model.mp4 (74.3 MB)
      4 - Presenting and Visualizing Data with Microsoft Excel
      • 25 - Creating and Using Pivot Tables English.srt (17.2 KB)
      • 25 - Presenting-Data-Practice.xlsx (1.0 MB)
      • 26 - Presenting Data Using Pivot Charts English.srt (14.3 KB)
      • 26 - Presenting Data Using Pivot Charts.mp4 (89.8 MB)
      • 27 - Quick note around Power BI Publisher for Excel.html (0.5 KB)
      • 28 - How Microsoft Excel Integrates with Power BI English.srt (8.6 KB)
      • 28 - How Microsoft Excel Integrates with Power BI.mp4 (45.4 MB)
      • 28 - Power BI Publisher for Microsoft Excel addin download.txt (0.1 KB)
      5 - Additional Resources
      • 29 - Exam formats and question types reference.txt (0.1 KB)
      • 29 - Types of Questions on the Excel 70779 Exam.html (1.0 KB)
      6 - Congratulations Dont forget your Prize
      • 30 - BONUS Cloud Skills for ML AI COUPON inside.html (3.2 KB)
      • Bonus Resources.txt (0.4 KB)

Description

MS Excel Exam Guide: Analyzing and Visualizing Data

https://DevCourseWeb.com

Duration: 4h 14m | Video: .MP4, 1920x1080 30 fps | Audio: AAC, 44.1kHz, 2ch | Size: 2.82 GB
Genre: eLearning | Language: English

Gain Skills in Data Analysis with Excel. Pass the Microsoft 70-779 Exam. Grow Your Career with an Excel Certification.

What you'll learn
Building queries in Excel
Combining data from multiple files
Modeling data in Excel’s Data Model
Transforming and cleaning data
Splitting data
Merging data
Pivoting data
Building relationships between data sets
Calculating implicit DAX measures
Calculating explicit DAX measures
Building Basic and Advanced DAX functions
Creating KPIs in Excel
Creating Hierarchies in Excel
Building and formatting Pivot Tables
Building and formatting Pivot Charts
Creating and using calendar tables
Understanding Question styles and formats for the Excel certification exam
Using both Excel with Power BI

Requirements
PC with internet connection
Description
Microsoft Excel is one of the most important software programs ever created. Businesses large and small, in countries all around the world, run off of systems and processes built on and around Excel. With so many people using Excel as part of their day-to-day jobs, it is more important than ever for you to stand out from the crowd and certify your Excel skills so you can contribute and be entrusted with these business-critical opportunities.
Enter this course. Designed directly off the study guides and outlines for the Excel 70-779 Exam, this course provides not only the theory but also the practical and foundational skills needed to pass the certification exam and stand out from the crowd. Not only will you be well prepared for the exam, but you’ll also build out a skill set that will be in demand for years to come.
When you’re ready to professionally certify your Excel skills, this is the course for you.
Who this course is for
Data Analysts who want to expand their analytical toolkit
And Business Analysts looking to further their technical abilities



Download torrent
2.8 GB
seeders:18
leechers:18
Udemy - MS Excel Exam Guide - Analyzing and Visualizing Data

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
2.8 GB
seeders:18
leechers:18
Udemy - MS Excel Exam Guide - Analyzing and Visualizing Data

Torrent hash: 117AB0E14B7F1AC08D2F75FE9492076C18B55864