Descriptions
The Ultimate Microsoft Excel Mastery Bundle – 8 Courses. Let us take you on a journey from Excel novice to Excel expert with this amazingly affordable 8-course training bundle. By the end of this training, you’ll be able to easily clean, summarize, and analyze data, as well as create PivotTables, charts, macros, and more! We’ll take you on a straightforward journey to learn specific functions, formulas, and tools Excel requires to perform business or data analysis. We’ll also look at three advanced Excel features: Power Pivot, Power Query, and DAX. This suite of Excel features will allow you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. This ultimate Excel course bundle is designed for students of all levels. If you’re new to Microsoft Excel, this course can help you get started. If you already have a good knowledge of Excel, you can further your knowledge with the more advanced courses in this bundle. This is the only Excel training you’ll ever need! All courses include practice exercises and instructor-led resources so you can apply what you learn right away.
What you will learn
- Get to know what’s new in Excel 2021 and navigate the Excel 2021 user interface
- Create your first Excel spreadsheet and use basic and advanced Excel formulas and functions
- Use useful keyboard shortcuts to increase productivity
- Linking to other worksheets and workbooks, and protecting and sharing workbooks
- How to use logical functions to make better business decisions
- Create an interactive dashboard to display general metrics
- Using the NEW dynamic array functions to perform tasks
- Record and run macros to automate recurring tasks
- Predict future values using forecast functions and forecast sheets
- Using statistical functions to rank data and calculate MEDIAN and MODE
- Understand and make minor changes to the VBA code
- How to combine data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH and XLOOKUP
- How to standardize and clean data for analysis in Excel
- Performing linear forecasting and forecast smoothing in Excel
Who is this course suitable for?
- Suitable for learners of all levels
- Excel users who are upgrading from a previous version and want to stay up to date with Excel 2021 developments
- Business analysts or those who want to perform data analysis using Excel
- Excel beginners 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
Specifications of the Ultimate Microsoft Excel Mastery Bundle – 8 Courses
- Publisher : Udemy
- Teacher: Simon says IT
- Language: English
- Level: All levels
- Number of courses: 507
- Duration: 56 hours and 50 minutes
Content from 2023-10
Requirements
- Microsoft Excel 2021/365 Desktop version for Windows for the Excel 2021 courses
- For the Power Pivot, Power Query and DAX course, you will need a copy of Microsoft Excel that is compatible with the Power Pivot tool
- The PivotTable courses were created using Excel 2019/365 for Windows. All code used in this course, except for one property, is compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Excel 2019.
Pictures
Sample clip
installation Guide
Extract the files and watch them with your favorite player
Subtitles: English
Quality: 720p
Download links
Password file(s): free download software
File size
33.16GB