Description
The Ultimate Microsoft Excel Mastery Bundle – 8 Courses, the comprehensive Microsoft Excel training course is published by Udemy Academy. Let’s take you from an Excel novice to an Excel expert with this amazing 8-course training package. By the end of this tutorial 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 functions, formulas and special tools that Excel has to help you perform data and data analysis. Next, we will take a look at three advanced features of Excel: 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 package is designed for students of all levels. If you are interested in Microsoft Excel, this course can put you on the right track. If you have a good knowledge of Excel, you can improve your skills with more advanced courses in this series. This is the only Excel training you will ever need. All courses include exercises and Excel files so you can apply what you learn immediately.
What you will learn
- Learn what’s new in Excel 2021 and explore the Excel 2021 interface.
- Creating the first Excel spreadsheet and using basic and intermediate Excel formulas and functions
- Use useful keyboard shortcuts to increase productivity
- Connect with other worksheets and workbooks and protect, share workbooks
- How to use logical functions to make better business decisions
- Create interactive dashboards to provide high-level metrics
- Use new dynamic array functions to perform tasks
- Record and run macros to automate repetitive tasks
- Forecast future values using forecast functions and forecast sheets
- Use statistical functions to rank data and calculate median and MODE
- Understanding and making 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
- Perform prediction smoothing and linear prediction in Excel
- And……
Who is this course suitable for?
- Suitable for learners at all levels
- Excel users of the previous version who want to be updated with the developments of 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 specifications The Ultimate Microsoft Excel Mastery Bundle – 8 Courses
- Publisher: Udemy
- teacher : Simon Sez IT
- English language
- Education level: all levels
- Number of courses: 507
- Training duration: 56 hours and 50 minutes
Head of the course seasons on 2023-10
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.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
33.16 GB
Be the first to comment