Excel 2021/365 Starter Pack: Beginner to Intermediate Course

About Excel 2021/365 Starter Pack: Beginner to Intermediate Course

***Exercise and demo files included***

We've combined our Excel 2021/365 for Absolute Beginners and Excel 2021/365 Intermediate courses to give you the ultimate starter pack to jump-start your spreadsheet journey!

Whether you're an Excel novice or already have some Excel knowledge, this course can help you get the ball rolling. This course bundle will give you a great Excel foundation or build on those skills you already have. It’s also perfect for students who have beginner to intermediate skills in an older version of Excel and are looking to explore the newest features.

Excel 2021 is Microsoft's latest stand-alone version of Excel, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.

The only prerequisite for this course is a working copy of Excel 2021 or Excel 265.

This course covers:

Becoming familiar with what’s new in Excel 2021

Navigating the Excel 2021 interface

Utilizing useful keyboard shortcuts to increase productivity

Creating your first Excel spreadsheet

Using basic and intermediate Excel formulas and functions

Effectively applying formatting to cells and using conditional formatting

Using Excel lists and master sorting and filtering

Working efficiently by using the cut, copy, and paste options

Linking to other worksheets and workbooks

Analyzing data using charts

Inserting pictures in a spreadsheet

Working with views, zooms, and freezing panes

Setting page layout and print options

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

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.

This course includes:

20+ hours of video tutorials

180+ individual video lectures

Course and exercise files to follow along

Certificate of completion