755 Students
Microsoft Excel 2021 Online Course teach you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Microsoft Excel 2021 Online Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To …
Microsoft Excel 2021 Online Course teach you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Microsoft Excel 2021 Online Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.
To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.
The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.
Anyone with a knack for learning new skills can take this Microsoft Excel 2021 Online Course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.
Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.
All of our courses, including this Microsoft Excel 2021 Online Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.
The detailed curriculum outline of our Microsoft Excel 2021 Online Course Course is as follows:
Excel Overview
Start Excel Spreadsheet
Enter Text and Numbers
Relative References
Working with ranges
Save and Save as Actions
File Extensions, Share, Export, and Publish files
Adding rows and columns to a table
Modifying Rows and Column lengths
Copy, Cut, and Paste
Copying Formulas
Page setup options
Fit to print on One Page
Print Workbooks
Sorting Data Ascending Order
Sorting Data Descending Order
Filter Data
Creating Basic Formulas
Datetime Formulas
Mathematical formulas phase1
Mathematical formulas phase2
VLOOKUP formula
HLOOKUP formula
XLOOKUP
Handling #NA and Approximates match in XLOOKUP
Split Text into columns
Flash Fill
Data Validation
Remove Duplicates
Import Data from Text files
Import Data from .CSV files
Formatting Font
Formatting Alignment
Formatting Numbers
Formatting Date
Formatting Tables
Pivot Tables
Pivot Charts
Excel Charts – Categories
Elements of a chart
Creating Charts
Column or Bar charts
Formatting Charts
Line Charts
Pie and Doughnut charts
| Section 01: Overview | |||
| Excel Overview | 00:06:00 | ||
| Section 02: Excel 2021: Basics | |||
| Start Excel Spreadsheet | 00:04:00 | ||
| Enter Text and Numbers | 00:07:00 | ||
| Relative References | 00:04:00 | ||
| Working with ranges | 00:07:00 | ||
| Save and Save as Actions | 00:08:00 | ||
| File Extensions, Share, Export, and Publish files | 00:07:00 | ||
| Section 03: Excel 2021: Rows, Columns, and Cells | |||
| Adding rows and columns to a table | 00:02:00 | ||
| Modifying Rows and Column lengths | 00:06:00 | ||
| Section 04: Excel 2021: Data Handling | |||
| Copy, Cut, and Paste | 00:07:00 | ||
| Copying Formulas | 00:03:00 | ||
| Section 05: Excel 2021: Page Setting Up and Print | |||
| Page setup options | 00:07:00 | ||
| Fit to print on One Page | 00:03:00 | ||
| Print Workbooks | 00:03:00 | ||
| Section 06: Excel 2021: Sorting and Filtering | |||
| Sorting Data Ascending Order | 00:04:00 | ||
| Sorting Data Descending Order | 00:02:00 | ||
| Filter Data | 00:04:00 | ||
| Section 07: Excel 2021: Writing Formulas | |||
| Creating Basic Formulas | 00:06:00 | ||
| Datetime Formulas | 00:06:00 | ||
| Mathematical formulas phase1 | 00:20:00 | ||
| Mathematical formulas phase2 | 00:12:00 | ||
| Section 08: Excel 2021: Advanced Formulas | |||
| VLOOKUP formula | 00:12:00 | ||
| HLOOKUP formula | 00:04:00 | ||
| Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 | |||
| XLOOKUP | 00:08:00 | ||
| Handling #NA and Approximates match in XLOOKUP | 00:11:00 | ||
| Section 10: Excel 2021: Data and Tools | |||
| Split Text into columns | 00:07:00 | ||
| Flash Fill | 00:07:00 | ||
| Data Validation | 00:07:00 | ||
| Remove Duplicates | 00:08:00 | ||
| Import Data from Text files | 00:07:00 | ||
| Import Data from .CSV files | 00:03:00 | ||
| Section 11: Excel 2021: Formatting data and tables | |||
| Formatting Font | 00:04:00 | ||
| Formatting Alignment | 00:06:00 | ||
| Formatting Numbers | 00:05:00 | ||
| Formatting Date | 00:03:00 | ||
| Formatting Tables | 00:02:00 | ||
| Section 12: Excel 2021: Pivot Tables | |||
| Pivot Tables | 00:07:00 | ||
| Pivot Charts | 00:02:00 | ||
| Section 13: Excel 2021: Charts | |||
| Excel Charts – Categories | 00:03:00 | ||
| Elements of a chart | 00:04:00 | ||
| Creating Charts | 00:02:00 | ||
| Column or Bar charts | 00:04:00 | ||
| Formatting Charts | 00:02:00 | ||
| Line Charts | 00:02:00 | ||
| Pie and Doughnut charts | 00:04:00 | ||
$125 Original price was: $125.$20Current price is: $20. ex VAT
SAVE 84% - OFFER ENDS SOON
![]() |


