Microsoft Excel 2021

As a component of the Microsoft Office suite, MS Excel extends far beyond simple data entry and management. It serves as a robust analysis tool, ideal for use by anyone, from financial analysis for accountants to researching survey results for students.

Course Description

Initially, Microsoft Excel might appear daunting, yet it remains one of the most essential digital skills to acquire.

Excel's capabilities in data analysis, charting, and graphing simplify the comprehension of extensive data sets. Its tabular sheets streamline project management, time management, and habit tracking.

Whether using Microsoft Excel for Mac or Excel for Windows, this course will guide you from beginner to proficient user, unlocking the full potential of MS Excel 2021.

Modules Covered

Course 1: Microsoft Excel 2021: Introduction 

This beginner-level Excel course introduces you to the fundamental operations and functionalities of Microsoft Excel. It consists of 34 online lessons, amounting to approximately 11-17 hours of study time.

Learning outcomes include:

  • Basic Microsoft Excel operations, such as opening and saving a new file
  • Manipulating and adjusting worksheets
  • Data entry and cells 
  • Copying and formatting, including conditional formatting
  • Creating tables 
  • Basic formulas
  • Charts and instant data analysis 
  • Pictures and printing in Excel 
  • Customisation of settings

Course 2: Microsoft Excel 2021: Intermediate 

The Microsoft Excel 2021 Intermediate course emphasises calculations, expanding on beginner knowledge with advanced skills in essential functions like series fills, sorting, and filtering. This online Excel course comprises 35 lessons, with a total study duration of 12-18 hours.

Learning outcomes include:

  • Manipulating sheets across multiple workbooks 
  • Advanced copying, pasting, and formatting
  • Using references in Excel functions
  • Advanced conditional formatting 
  • Function library and function applications
  • Cell errors and how to check them
  • Data validation 
  • Filtering and sorting 
  • Finding, replacing, and removing specific data
  • Splitting text into columns 
  • Flash fill 

Course 3: Microsoft Excel 2021: Advanced 

Microsoft Excel 2021 Advanced places a strong emphasis on creating charts and using macros. This online Excel course includes 29 lessons, with an estimated study time of approximately 9-15 hours.

Learning outcomes include:

  • Quick data analysis using sparklines
  • Creating and formatting charts
  • Insertion of graphical elements such as shapes and SmartArt
  • Use of review tools such as proofing, tracked changes, and comments
  • Various workbook views
  • Page setup
  • Workbook protection
  • Creating and using templates
  • File saving and compatibility
  • Macros

Course 4: Microsoft Excel 2021: Expert Tools 

In the course, you will master techniques for data importing, pivot chart usage, and advanced functions essential for processing and analysing data in larger databases. This course comprises 19 lessons, totaling approximately 6-10 hours of study time.

Learning outcomes include:

  • Advanced data validation and filters
  • Database functions
  • OFFSET function
  • SUBTOTAL function
  • Advances IF functions
  • VLOOKUP and HLOOKUP functions
  • INDEX and MATCH functions
  • Importing external data
  • Microsoft Power Query
  • XML data
  • PivotTable

Accreditation

Fully Accredited

This course is nationally accredited by Microsoft - Training and Certification Courses

Microsoft is a globally renowned company that needs little introduction. With a presence spanning over four decades, Microsoft has continuously innovated to redefine how we live, work, and connect through technology. Microsoft certifications are internationally recognised credentials that attest to an individual’s proficiency and technical expertise in Microsoft technologies.

Benefits

  • Achieve proficiency in the latest version of Microsoft Excel.
  • Enhance your data management skills and convert large amounts of unorganised data into valuable business assets.
  • Present information effectively using Microsoft Excel's graph and table functions, ensuring clarity and ease of understanding.
  • Boost efficiency – mastering MS Excel 2021 can save time by streamlining data entry and calculations.
  • Optimise your productivity using Microsoft Excel to improve personal performance both at work and home through trackers and tables with automated functions.
  • Delivery Method: Online
  • Assessment Included
  • Course Access: 12 months
  • Join a community of over 615,000

Eligibility

Please note this is a paid qualification, therefore you will have to pay the course fee in order to start studying.

Is the MS Excel 2021 online course right for me?

Whether you're a student, self-employed, or part of a business, Excel is an invaluable tool for tracking and managing tasks and finances. Its diverse functions enable you to transform performance metrics, targets, and survey results into easily understandable data, and to visualise large datasets with visual aids.

Course fee

£ 75 £ 55
or starting at £ 5 p.m.
Microsoft Excel 2021

As a component of the Microsoft Office suite, MS Excel extends far beyond simple data entry and management. It serves as a robust analysis tool, ideal for use by anyone, from financial analysis for accountants to researching survey results for students.

12 Months
Online Based
Accredited

Course fee

£ 75 £ 55
or starting at £ 5 p.m.
Visa
MasterCard
American Express
PayPal
Google Pay and Apple Pay supported

They were always just an email or phone call away which made everything so much more reassuring. For anyone struggling to understand their future I highly recommend giving this company a call, they can talk you through it, not make the decision for you, but make that choice a little easier!

Katie A

The process of getting on to my course was very quick and easy. This is the second time I've used The AIM Group and it definitely won't be the last.

J Richardson

I have done many different courses with The Aim Group, and they are amazingly easy to follow. The team always takes the time to phone to talk through the process and remembers who you are giving that personal touch to. I have really enjoyed my studying and have received the certificates quicker than advertised.

Georgina D

I have found the Aim Group extremely helpful in helping me access my course, giving a very thorough explanation of each course and answering any queries every time. They inspired me to continue my study path and I am nearly at the completion stage of my 5th Level 2 NCFE course which is going to look very good on my CV.

Jude B

The AIM group are punctual with their communication, clear and precise. I am on my third course and have really appreciated their support. Which in turn has improved my self-esteem, and self-confidence and given me extra qualifications to add to my CV!

Jo G

I’ve just finished my course with The Aim Group on Mental Health Awareness. Now I have good knowledge of how to deal with mental health issues and how to help other people in that situation. I'd like to thank all members of the Aim Group for this opportunity.

Cecilia A

The AIM Group went the extra mile to ensure that I was enrolled on the course that best suited my needs. Thank You!

James W