Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

**This bundle includes practice exercises, downloadable files, and LIFETIME access**

Learn all the tools you'll need to become a Microsoft Excel 2021/365 power user with this great value 3-course training bundle for beginner to advanced users from Simon Sez IT.

Let us take you on a journey from being an Excel novice to an Excel guru. By the end of these training courses, you will be able to clean, summarize, and analyze data easily, as well as create PivotTables, charts, macros, and so much more!

All courses include practice exercises and follow-along instructor files so you can immediately apply what you learn.

This Excel ultimate bundle is designed for students of all levels. If you are brand new to Microsoft Excel or are upgrading from a previous version and want to keep up to date with Excel 2021 developments, then this bundle is for you.

If you already have a good understanding of Excel, you might want to check out the intermediate and advanced sections where our expert instructor will help you take your spreadsheet skills to the next level.

What's included?

Excel 2021 for Beginners

• Become familiar with what’s new in Excel 2021

• Navigate the Excel 2021 interface

• Utilize useful keyboard shortcuts to increase productivity

• Create your first Excel spreadsheet

• Use basic and intermediate Excel formulas and functions

• Effectively apply formatting to cells and use conditional formatting

• Use Excel lists and master sorting and filtering

• Work efficiently by using the cut, copy, and paste options

• Link to other worksheets and workbooks

• Analyze data using charts

• Insert pictures in a spreadsheet

• Work with views, zooms, and freezing panes

• Set page layout and print options

• Protect and share workbooks

• Save your workbook in different file formats

Excel 2021 Intermediate

• 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.

Excel 2021 Advanced

• 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

• Analyzing 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 to create practical formulas to complete specific tasks.

This bundle includes:

1. 30+ hours of video tutorials

2. 270+ individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion

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

Url: View Details

What you will 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

Rating: 4.16667

Level: All Levels

Duration: 32.5 hours

Instructor: Simon Sez IT