Microsoft Excel 2021/365: Intermediate Level Training

Get more out of Microsoft Excel 2021/365 with our intermediate training course!

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I 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.

Requirements

• Microsoft Excel 2021/365 desktop version for Windows installed and ready to use on your computer.
• A beginner-level knowledge of Excel

Target audience

• Users who have a basic knowledge of Microsoft Excel and wants to advance their Excel 2021 skills