Microsoft Excel 2021/365 Masterclass: Advanced Excel Course
Microsoft Excel 2021/365 Masterclass: Advanced Excel Course
**This course includes downloadable course instructor files and exercise files to work with and follow along.**
With this ten-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial data.
This is the third part of our Excel 2021 course series, where you can build on the skills learned in the beginner and intermediate courses and fast-track your way to being an Excel power user.
This course covers the latest updates from Microsoft, including the LET and LAMBDA functions, which allow you to create your own variables and even Excel functions.
Excel 2021 Advanced will show you how to use the most business-relevant functions and formulas you might need, such as dynamic array functions, forecasting, statistical functions, PivotTables, PivotCharts, Power Query, Macro VBA, and so much more!
This course is designed to inspire you to approach problem-solving differently and encourage you to combine Excel’s myriad of functions to complete practical tasks.
This Excel 2021 masterclass is for students who already have a good understanding of Excel and want to take their capabilities to the next level. It’s also suitable for students with significant experience in an older version of the software.
What we cover in this course:
Using the NEW dynamic array functions to perform tasks
Creating advanced and flexible lookup formulas
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Producing accurate results when working with financial data using math functions
Creating variables and functions with LET and LAMBDA
Analysing data with advanced PivotTable and PivotChart hacks
Creating interactive reports and dashboards by incorporating form controls
Importing and cleaning data using Power Query
Predicting future values using forecast functions and forecast sheets
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Combining functions to create practical formulas to complete specific tasks.
This course includes:
10 hours of video tutorials
87 individual video lectures
Course and exercise files to follow along
Certificate of completion
Here's what our students are saying...
★★★★★ "So far, it is a good match for me. Everything is explained in better detail and is simple to understand." -Kirsten Morales
Go beyond the basics and supercharge your Excel knowledge with this Excel 2021/365 advanced training course!
Url: View Details
What you will learn
- Using the NEW dynamic array functions to perform tasks
- Creating advanced and flexible lookup formulas
- Using statistical functions to rank data and to calculate the MEDIAN and MODE
Rating: 4.5
Level: Expert Level
Duration: 12 hours
Instructor: Simon Sez IT
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap