Download Udemy – The Ultimate Microsoft Excel Mastery Bundle

Description

The Ultimate Microsoft Excel Mastery Bundle – 8 Courses is a comprehensive Microsoft Excel training course published by Udemy Academy. Let’s take you from an Excel novice to an Excel expert with this amazing 8-course training bundle. By the end of this training, you will be able to easily clean, summarize, and analyze data, as well as create PivotTables, charts, macros, and much more. In this course, we will introduce you to the specific functions, formulas, and tools that Excel has to help you perform data analysis and data visualization. Next, we will take a look at three advanced Excel features: Power Pivot, Power Query, and DAX. This set of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. This comprehensive Excel training bundle is designed for students of all levels. If you are a Microsoft Excel enthusiast, this course can set you on the right path. If you have a good understanding of Excel, you can enhance your skills with the more advanced courses in this set. This is the only Excel training you will need. All courses include practice and Excel files so you can immediately apply what you learn.

What you will learn

• Learn what’s new in Excel 2021 and explore the Excel 2021 interface.
• Create your first Excel spreadsheet and use basic and intermediate Excel formulas and functions.
• Use useful keyboard shortcuts to increase productivity
• Connect to other worksheets and workbooks and protect, share workbooks
• How to use logical functions for better business decision making
• Create interactive dashboards to present high-level metrics
• Using new dynamic array functions to perform tasks
• Record and run macros to automate repetitive tasks
• Predict future values ​​using forecast functions and forecast worksheets
• Using statistical functions to rank data and calculate median and MODE
• Understand and make minor edits to VBA code
• How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
• How to standardize and clean data ready for analysis in Excel
• Performing smoothing and linear forecasting in Excel
• And……

Who is this course suitable for?

• Suitable for learners at any level
• Previous version Excel users who want to stay up to date with the developments in Excel 2021.
• Business analysts or those looking to perform data analysis using Excel
• Beginner Excel users who want to learn how to use Pivot Tables
• Advanced Excel users who want to learn Power Pivot and Power Query
• Those who want to create visually appealing dashboards in Excel

Course Details The Ultimate Microsoft Excel Mastery Bundle – 8 Courses

• Publisher: Udemy
• Instructor: Simon Sez IT
• Language: English
• Education level: All levels
• Number of lessons: 589
• Training duration: 66 hours and 34 minutes

Course chapters

Course prerequisites

• Microsoft Excel 2021/365 desktop version for Windows for the Excel 2021 courses
• You’ll need a copy of Microsoft Excel that is compatible with the Power Pivot tool for the Power Pivot, Power Query & DAX course
• The PivotTable courses were created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.

Pictures

Sample video

Installation Guide

After Extract, view with your favorite player.

Subtitles: English

Quality: 720p

The 2024/3 version has increased the number of lessons by 82 and the duration by 9 hours and 44 minutes compared to the 2023/2 version.

Download link