Excel 2021/365 Starter Pack: Beginner to Intermediate Course

Master Excel spreadsheets with this beginner to intermediate training course!

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

What Will I Learn?

• What’s new in Excel 2021
• Navigating the Excel 2021 interface
• Utilizing useful keyboard shortcuts to increase productivity
• Using basic and intermediate Excel formulas and functions
• Effectively applying formatting to cells and using conditional formatting
• Linking to other worksheets and workbooks
• Protecting and sharing workbooks
• Saving your workbook in different file formats
• Designing better spreadsheets and controlling user input
• How to use logical functions to make better business decisions
• How to use Excel tables to structure data and make it easy to update
• Sorting and filtering data using advanced features and new Excel formulas
• Working with date and time functions and extracting data using text functions
• How to control user input with data validation
• Importing data and cleaning it up before analysis
• Using WhatIf analysis tools to see how changing inputs affect outcomes.
• Analyzing data using PivotTables and representing data visually with charts and PivotCharts
• Adding interactions to PivotTables and PivotCharts
• Creating an interactive dashboard to present high-level metrics
• Auditing formulas and troubleshooting common Excel errors

Requirements

• Microsoft Excel 2021/365 desktop version for Windows installed and ready to use on your computer.
• Basic knowledge of Microsoft Excel is helpful but not required. This course is suitable for absolute beginners

Target audience

• Microsoft Excel novice
• Those who need an Excel refresher and want to improve their knowledge
• Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2021/365 knowledge.