Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

Become a Microsoft Excel 2021/365 expert with this three-course bundle

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

What Will I Learn?

• Become familiar with what’s new in Excel 2021 and navigate the Excel 2021 interface
• Create your first Excel spreadsheet and use basic and intermediate Excel formulas and functions
• Utilize useful keyboard shortcuts to increase productivity
• Effectively applying formatting to cells and using conditional formatting
• Linking to other worksheets & workbooks and protecting & sharing workbooks
• 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
• 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
• Creating an interactive dashboard to present high-level metrics
• Auditing formulas and troubleshooting common Excel errors
• Using the NEW dynamic array functions to perform tasks
• Using statistical functions to rank data and to calculate the MEDIAN and MODE
• Importing and cleaning data using Power Query
• Recording and running macros to automate repetitive tasks
• Understanding and making minor edits to VBA code
• Predicting future values using forecast functions and forecast sheets

Requirements

• Microsoft Excel 2021/365 desktop version for Windows installed and ready to use on your computer.

Target audience

• Suitable for learners of all levels
• Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 2021/365 knowledge
• Excel users upgrading from a previous version and want to keep up to date with Excel 2021 developments