Udemy – Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX 2023-1

Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX is an advanced analysis training course with Excel software published by Udemy Academy. In the process of this training course, he has become familiar with the advanced and practical capabilities of Excel software in the field of analysis, such as Pivot Tables, Power Query, PowerPivot, and DAX formula writing and function writing language. and valuable skills are learned. This training course will prepare you for the certification of 70-779 held by Microsoft and will teach you valuable skills in the field of data analysis, collection and visualization. The collection of various combinations, group editing of collections, automation and performing various tasks in a group and one-sided manner 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

• 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 specifications

Publisher: Udemy
Instructors: Phillip Burton
Language: English
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 you begin 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.

Pictures

Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX introduction video

Installation guide

After Extract, watch with your favorite Player.

Subtitle: English

Quality: 1080p

Version 2023/1 compared to 2020/5 has increased the number of 25 lessons and the duration of 2 hours and 22 minutes. Also, the Quality of the course has increased from 720p to 1080p.

Download link

Download Part 1 – 3 GB

Download Part 2 – 3 GB

Download Part 3 – 3 GB

Download Part 4 – 3 GB

Download Part 5 – 1.02 GB

Size

13.0 GB