Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - MS Excel Exam Guide - Analyzing and Visualizing Data

Size
2.8 GB
Seeders
1
Leechers
0
Files
79
Category
Added
at 7:01pm GMT+1
Infohash
117ab0e14b7f1ac08d2f75fe9492076c18b55864
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ DevCourseWeb.com ] MS Excel Exam Guide: Analyzing and Visualizing Data



If You Need More Stuff, kindly Visit and Support Us -->> 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



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...



Image error



Image error

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

Rating
Not rated yet
Log in to rate

Comments

No comments yet.