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
- And …
Course details
Publisher: Yudmi
teacher: Phillip Burton
English language
Training level: introductory to advanced
Number of courses: 226
Training duration: 18 hours and 22 minutes
Course headings
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
Microsoft Excel course introduction video: Pivot Tables, Power Query, Power Pivot/DAX
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 1080p
Version 1/2023 compared to 2020/5 has increased the number of 25 lessons and the duration of 2 hours and 22 minutes. Also, the course quality has been increased from 720p to 1080p.
download link
Password file(s): www.downloadly.ir
Size
13.0 GB
Be the first to comment