Learning Outcomes

Introduction to Excel 2021

Launching Excel

Exploring the Interface

The Backstage Area

Useful Keyboard Shortcuts

Lesson Summary

This module will begin by helping you study an introduction into Excel 2021 covering in fullness information like: Excel 2021 vs Excel for Microsoft 365, and how to launch Excel 2021. You will also study the interface and receive answers to questions like: What is the difference between Excel 2021 and Excel? Why use Excel 2021?

Working with Excel Templates

Working with Workbooks and Worksheets

Saving Workbooks and Worksheets

Entering and Editing Data

Navigating and Selecting Cells, Rows and Columns

This module will help you examine creating your first Excel spreadsheet. Also, you will be able to understand working with Excel templates and analyze working with workbooks and worksheets. Studying this module will help you answer: How would you be able to save workbooks and worksheets? How can you edit and enter data?

Formulas and Functions Explained

Finding the Average with the AVERAGE Function

Absolute vs Relative Referencing

What are Named Ranges?

Formatting Numbers and Cells

This module will begin by helping you study what are the formulas and functions inside Excel 2021, covering in fullness information like: Absolute vs Relative Referencing. You will also study named ranges and receive answers to questions like: What are named ranges? How can you apply formating to numbers and cells?

Excel 2021 for Beginners - Course assessment

This free online course is a basic Excel 2021 tutorial that describes the essential functions and uses of the site.

Excel 2021 for Beginners

This spreadsheet course helps you learn Microsoft Excel 2021, a complete platform to help you organize data. You will see what it can do for you and examine all the features, including the uses of its interface. We provide information to assist you in creating a spreadsheet and using the dashboard. We explain the helpful keyboard shortcuts and answer questions such as: ‘What are the most used formulas in Excel?’ and ‘What is named ranges?’.

MS Excel Interface and File Menu

MS Excel Home and Insert Menus

MS Excel Page Layout and Formulas Menus

This module will provide you with the knowledge to master the basic features of Microsoft Excel. You will learn how to use the MS Excel interface and also understand how to use the main elements within Excel menus such as the File Menu, Home menu, Insert menu, Layout menu, Formulas menu, Data menu, Review menu, and View menu.

MS Excel Data, Review and View Menus

MS Excel Templates, Dates, Numbers and Text

MS Excel Calculations, Page Setup, Printing & File Saving

This module will continue helping you understand how to use Excel main menus. You will learn how to use the Data menu, the Review menu, and View menu. You will also learn how to enter and manipulate data in Excel by learning how to use templates; deal with text, numbers, and calculations; set up pages and configure printing settings.

MS Excel: Manage and Report with Microsoft Excel (Basic) - Course Assessment

Learn how to use Microsoft Excel to manage data and boost office productivity in this free online spreadsheet course.

MS Excel: Manage and Report with Microsoft Excel (Basic)

This Microsoft Excel tutorial from Crafty E-Learning provides the training you need to use this powerful spreadsheet program like a pro. We explain how to manage, analyse and interpret data and statistics efficiently. Knowing how to use Excel is a must-have skill for any modern professional. This course focuses on Excel 2016 but also covers other versions like the 2013, 2019 and 2021 editions. Sign up to improve your data management skills.

1 Getting started with Excel

2 Working with Data in Excel

3 Print and View options in Excel

4 Tables and Charts in Excel

Getting started with Excel can be daunting for many. There is so much to learn and knowing where to start can be difficult. What is a cell? What is the formula bar? Don’t you use ribbons for your hair? If all this jargon is foreign to you, don’t feel alone. We are here to help. This module is aimed at those looking at Excel for the first time.

By the end of this module you will be able to

· Open and Save Workbooks

· Navigate the Ribbons to find commands you need

· Enter Data and formulas

·

Practical Beginner Excel 365 - Assessment

Beginner level Excel 365 training course to get you working quickly and effectively with your Excel workbooks

Practical Excel 365 for Beginners

By the end of this free online course, you will be comfortable navigating an Excel workbook, entering and formatting data, setting print options and inserting objects into a worksheet. You will also learn how to sort and filter your data to make it work for you. This online course will enable you to use Excel 365 in your work or for any personal projects where you need to organise information.

[2025] 150+ Online Courses to Help Your Career

Unlock 800+ Free Certificates: Master Tech & Soft Skills with CodeSignal Learn

7 Best Reverse Engineering Courses for 2025

[2025] Massive List of Thousands of Free Certificates and Badges

9 Best GIS Courses for 2025: Navigating Spatial Data

Udacity’s 2021: Year in Review

25% of Coursera Courses Have Peer Reviews: Here Are the Best

[2025] 450+ Free Google Certificates and Badges

SEO Content Strategy Demystified: Coursera, MasterClass, and edX

The Rise of AI Search: ChatGPT Surpasses DuckDuckGo, Threatens Bing

Scaler Academy’s Big Lie: How India’s EdTech Darling Inflated Revenue by 15x

12 Best Data Structures & Algorithms Courses for 2025

10,000+ Free Courses from Tech Giants: Learn from Google, Microsoft, Amazon, and More

Chinese Edtech Pivots: Well-rounded Education, Hardware, Agriculture E-commerce, Fast-Food, Garments, and More

7 Best Climate Change Courses for 2025: Exploring the Science

A Decade of MOOCs: A Review of MOOC Stats and Trends in 2021