Description
Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX is an advanced training course on data analysis with Excel software, published by Udemy Academy. During the process of this training course, he became familiar with the advanced and practical capabilities of Excel software in the field of data analysis, such as Pivot Tables, Power Query, PowerPivot, and DAX formula writing and function writing language.
And you will learn valuable skills. This training course will prepare you for the 70-779 certification exam held by Microsoft and will teach you valuable skills in the field of data analysis, collection, and visualization. Integration of different information sets, group editing of data sets, automation, and performing various tasks in groups and unilaterally are among the most important skills taught in this training series.
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 training course:
- Creating tables and pivot charts
- Creating advanced charts and graphs
- Formatting numbers and dates in Excel software
- Perform advanced calculations in Excel software
- Receiving, storing, and working with different sets of information
- Merging and merging multiple files and data sets together
- Building and defining information models
- Useful and important functions of DAX
See Also:
Udemy – FPGA Embedded Design, Part 1 – Verilog 2020
Udemy – Unity C# Mobile Game Development – Make 3 Games From Scratch 2022
Udemy – Semiconductors & its Application in Analog Electronics 2021
Udemy – Blender Environment Artist: Create 3D Worlds 2022
Udemy – Learn the Fundamentals of VHDL and FPGA Development 2020
Microsoft Excel Course details
Publisher: Udemy
Instructor: Phillip Burton
Language: English
Education level: Introductory to advanced
Number of lessons: 201
Duration of education: 16 hours
Course topics on 11/2021
Microsoft Excel course prerequisites: Pivot Tables, Power Query, Power Pivot/DAX
Before you start this course, you should 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. (It will work if you are 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 good if you had prior experience in using Excel formulas, but that is not essential.
That’s it! The more experience in using Excel, the better, but it is not essential.
Course images
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
** 4 video files from the total educational videos of this course have been removed due to failure.
download link
Download part 1 – 2 GB
Download part 2 – 2 GB
Download part 3 – 2 GB
Download part 4 – 1.13 GB
file password link
Follow On Tumblr
Follow On pinterest
Visit our blog
