Microsoft Excel 2021/365: Intermediate Level Training
Get more out of Microsoft Excel 2021/365 with our intermediate training course!
4.45 (138 reviews)
602
students
11.5 hours
content
Mar 2024
last update
$69.99
regular price
What you will learn
Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
Constructing functional and flexible lookup formulas
How to use Excel tables to structure data and make it easy to update
Extracting unique values from a list
Sorting and filtering data using advanced features and new Excel formulas
Working with date and time functions
Extracting data using text functions
Importing data and cleaning it up before analysis
Analyzing data using PivotTables
Representing data visually with PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
How to control user input with data validation
Using WhatIf analysis tools to see how changing inputs affect outcomes.
Related Topics
4554244
udemy ID
2/16/2022
course created date
3/11/2022
course indexed date
Bot
course submited by