The description
Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX is advanced training in analysis with Excel software published by Udemy Academy. During this training, he became familiar with the advanced and practical capabilities of Excel software in the field of analysis, such as pivot tables, Power Query, PowerPivot and the language of writing formulas and functions. DAX. and valuable skills are learned. This course will prepare you for the 70-779 certification held by Microsoft and teach you valuable skills in the field of data analysis, collection, and visualization. Collecting various combinations, editing collections in groups, automating and performing various tasks in groups and unilaterally are some of the most important skills taught in this series of trainings.
Excel software is one of the best office suite software supported by Microsoft. Excel has played a very important role in the field of business data storage and analysis, and along with the Python programming language, it is one of the most important tools used in this profession.
What you will learn in Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX
- Create tables and pivot tables
- Creation of advanced charts and graphs
- Formatting numbers and dates in Excel software
- Perform advanced calculations in Excel software
- Receive, store and work with different sets of information
- Merge and merge multiple files and datasets together
- Build and define information models
- Useful and important functions of DAX
- And …
Course specifications
Editor: Udemy
Instructors: Phillip Burton
French language
Level: Introductory to Advanced
Number of lessons: 201
Duration: 16 hours
Course topics on 2021/11
Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX prerequisites
Before starting this course, you must have a PC with Microsoft Excel 2016 or later.
The first part of this course will work with Macs, but the second and third parts are not compatible with the Mac version of Excel. (This will work if you’re using the PC version of Excel, including using Parallel Desktop.)
You should also know how to open an Excel workbook and have an interest in analysis.
It would also be nice if you had previous experience using Excel formulas, but that’s not essential.
That’s it! The more experience you have using Excel the better, but it’s not essential.
Pictures
Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX Intro Video
Installation guide
After ripping, watch with your favorite player.
english subtitle
Quality: 720p
** 4 videos are missing.
Download link
File password(s): ngaur.com
Cut
7.13 GB