Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel 2021/365 for Beginners

Name: Microsoft Excel 2021/365 for Beginners
Rating: 4.2 (54 reviews)

Start your spreadsheet journey with this Excel 2021 training course for beginners!

Created bySimon Sez IT

Last updated 3/2024

English

What you'll learn

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

Course content

18 sections • 110 lectures • 13h 7m total length

Course Introduction2:19
WATCH ME: Essential Information for a Successful Training Experience2:11
DOWNLOAD ME: Course Exercise Files0:23
DOWNLOAD ME: Course Instructor Files0:23
DOWNLOADA ME: Course Transcript0:21
Free Keyboard Shortcut Guides0:18
Excel 2021 vs Excel for Microsoft 3655:39
Compare Excel 2021 and Excel for Microsoft 365, highlighting subscription versus one-time ownership, updates, and device limits. Learn how online access and pricing influence your choice.
Section Quiz

Launching Excel3:38
The Start Screen10:12
Master the Excel start screen to access templates, recent and pinned files, and the home, new, and open tools. Adjust settings in options for auto save and ribbons.
Exploring the Interface11:39
Explore Excel 2021/365 interface, create a blank workbook, and navigate the title bar, quick access toolbar, ribbons, and tabs. Understand the name box, formula bar, cells, worksheets, and workbook structure.
Understanding Ribbons, Tabs and Menus8:29
The Backstage Area4:40
Explore the backstage area by clicking file to access options like new workbooks, templates, and publish to Power BI service. Use the info page to protect and recover unsaved workbooks.
Customizing the Quick Access Toolbar9:43
Discover how to customize the Quick Access Toolbar in Excel 2021/365, including turning it on, relocating it under the ribbons, and adding frequent commands like undo, redo, save, and spelling.
Useful Keyboard Shortcuts9:41
Getting Help6:36
Exercise 012:19
Section Quiz

Working with Excel Templates9:02
Working with Workbooks and Worksheets7:34
Saving Workbooks and Worksheets8:44
Learn how to save and name workbooks in Excel 2021, use save versus save as, press Ctrl+S, and enable auto recover while understanding autosave differences with Microsoft 365.
Entering and Editing Data9:53
Navigating and Selecting Cells, Rows and Columns7:21
Learn to navigate large worksheets and select cells, rows, and columns using mouse and keyboard shortcuts such as ctrl+down arrow, ctrl+right arrow, and ctrl+shift+down, and ctrl+s to save.
Exercise 025:19
practice creating and saving an invoice template in the default templates folder. create a workbook with sheets named summary, sales data, calculations, and charts, and enter 2020 sales data.
Section Quiz

Formulas and Functions Explained11:42
Explore formulas and functions in Excel, learn to build calculations with cell references, master the sum function for ranges, and understand IntelliSense and the order of operations.
Performing Calculations with the SUM Function7:38
Counting Values and Blanks7:26
Finding the Average with the AVERAGE Function4:18
Learn to find the average with the AVERAGE function in Excel by selecting a cell range or using the dialog. Copy the formula down with autofill and observe relative referencing.
Working with the MIN and MAX Functions2:24
Discover how to use the min and max functions to find the lowest and highest values in a cell range such as c3 to f3. Copy formulas down with Ctrl+D.
Handling Errors in Formulas8:41
Absolute vs Relative Referencing6:57
Autosum and AutoFill9:41
Flash Fill5:02
Exercise 035:12
Section Quiz

How to Structure a List4:37
Sorting a List (Single-Level Sort)5:06
Sorting a List (Multi-Level Sort)5:06
Sorting Using a Custom List (Custom Sort)8:12
Using Autofilter to Filter a List6:45
Learn to apply autofilter in Excel to filter a dataset by one or more columns using text, number, and color filters, and to clear filters when needed.
Format as a Table10:18
Creating Subtotals in a List7:34
Exercise 074:37
Section Quiz

Looking up Information with VLOOKUP10:02
VLOOKUP Approximate Match5:08
Master VLOOKUP approximate match in Excel by using the true argument when the lookup value isn't exact. Explore age ranges, app preferences, hours per day, named ranges, and absolute references.
Error Handling Functions7:10
Basic Logical Functions (IF, AND, OR)12:24
Making Decisions with IF Statements4:32
Cleaning Data using Text Functions12:09
Learn to tidy messy data in Excel using text formulas such as left, mid, and right, plus trim, clean, and combine values for clean, consistent results.
Working with Time and Date Functions11:17
Exercise 0910:19
Apply vlookup and logical formulas to retrieve student scores and grades, select venues, and cleanse text using trim, proper, flash fill, and right functions.
Section Quiz

Requirements

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

Description

Microsoft has released its latest stand-alone Excel version, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.

If you are an absolute beginner who has never used Excel before, this course can give you a great foundation. Maybe you have some very basic Excel skills and want to improve your proficiency, or you are using an older version of Excel and want to check out what’s new. Well, this course can help you get the ball rolling.

This is an 11-hour course, with 100 bite-sized video lessons and exercises. You will also get course demo files and exercise files to download so you can follow along with the lessons and practice what you’ve learned at the end of each section.

In this course, you can learn how to:

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

This course includes:

11 hours of video tutorials
100 individual video lectures
Course and Exercise Files to follow along
Certificate of completion

Here's what our students are saying...

★★★★★ "It was very thorough. As a beginner, I had a lot to learn and it was very beneficial." -Karen Bruton

★★★★★ "I love everything about the Microsoft Excel 2021/365 for Absolute Beginners course. Definitely a great refresher for those who don't use Excel as much as they want." -Kristen Smith

★★★★★ "Very good beginning Course." -Marcello Dioguardi

Who this course is for:

Microsoft Excel novice.
No previous knowledge of Excel required. This course is created for absolute beginners.
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.

Microsoft Excel 2021/365 for Beginners

What you'll learn

Explore related topics

Course content

Introduction7 lectures • 12min

Getting Started in Excel 20219 lectures • 1hr 7min

Creating You First Excel Spreadsheet6 lectures • 48min

Introduction to Excel Formulas and Functions10 lectures • 1hr 9min

Using Named Ranges5 lectures • 23min

Formatting Numbers and Cells5 lectures • 33min

Formatting Worksheets5 lectures • 39min

Working with Excel Lists8 lectures • 52min

Moving and Linking to Data7 lectures • 44min

An Introduction to Intermediate Formulas8 lectures • 1hr 13min

Requirements

Description

Who this course is for: