Microsoft Excel 2021/365 Masterclass: Advanced Excel Course
Go beyond the basics and supercharge your Excel knowledge with this Excel 2021/365 advanced training course!
4.62 (213 reviews)
1,090
students
12 hours
content
Mar 2024
last update
$74.99
regular price
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
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 together to create practical formulas to complete specific tasks
Related Topics
4616222
udemy ID
3/28/2022
course created date
4/15/2022
course indexed date
Bot
course submited by