Description
Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX is an advanced training course 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 for writing formulas and functions DAX. and valuable skills are learned. This training will prepare you for the 70-779 certification held by Microsoft and teach you valuable skills in data analysis, collection and visualization. Collecting various combinations, group editing of collections, automating and performing various tasks in groups and unilaterally are some of 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’ll learn in Microsoft Excel: PivotTables, Power Query, Power Pivot/DAX
- Creating tables and pivot charts
- Creating 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: 226
Duration: 18 hours and 22 minutes
course topics
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 are using the PC version of Excel, including Parallel Desktop.)
You should also know how to open an Excel workbook and be interested in analysis.
It would also be nice if you had prior experience using Excel formulas, but it is not essential.
That’s it! The more experience you have using Excel, the better, but it is not essential.
Pictures
Microsoft Excel: PivotTables, Power Query, Power Pivot/DAX introductory video
installation guide
After the clip, watch with your favorite reader.
Subtitle: English
Quality: 1080p
Version 2023/1 compared to 2020/5 increased the number of 25 lessons and the duration by 2 hours and 22 minutes. Additionally, the course quality has been increased from 720p to 1080p.
Download link
File password(s): free download software
size
13.0 GB