In this Excel beginner course, you will become familiar with the basic operation of Microsoft Excel and how it functions. There are 34 online lessons to complete, totalling 11-17 hours of study.
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
The Microsoft Excel 2021 Intermediate course will focus mainly on calculations. It will build on beginner knowledge by expanding skills in useful functions such as series fills, sorting, and filtering. Within this online Excel course are 35 lessons, totalling 12-18 hours of study time.
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
Microsoft Excel 2021 Advanced focuses largely on chart creation and usage of macros. There are 29 online Excel lessons to study, consisting of approximately 9-15 hours.
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
In the course MS Excel 2021: Expert Tools, you will learn how to import data, how to use pivot charts, and learn advanced functions that will help you process and perform data analysis in larger databases. There are 19 lessons, equating to approximately 6-10 hours of study.
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
At the end of each Excel training course, you will sit a final test where your knowledge across all modules will be checked. You will have 30 minutes to complete 40 multiple-choice questions in each test.
Is the MS Excel 2019 online course right for me? Whether you're a student, self-employed, or working in a business, excel is a fantastic tool to track and manage tasks and finances. It has a variety of functions that allow you to convert performance, targets, and survey results into easy-to-read data and illustrate large amounts of data into visual aids.
Become competent in the latest version of Microsoft Excel.
Improve your data management and transform large quantities of unorganised data into a valuable business asset.
Display information clearly using Microsoft Excel’s graph and table functions, making it easy to digest.
Maximise efficiency – being competent in MS Excel 2021 can save you time by streamlining data entry and calculation.
Optimise your time using Microsoft Excel to enhance your personal performance at work and home by using trackers and tables with automated functions.
Learn at your own pace by taking MS Excel online training, giving you the opportunity to study when and where you want.
Microsoft Excel has a variety of uses, including but not limited to formatting; organising; data entry; data analysis; database collection; calculations; and tracking.
Yes, with the right training, learning MS Excel is straightforward.
We are an official training partner for Microsoft Excel courses, meaning you can be sure you’re getting the highest quality training materials.
The fastest way to learn Excel is by enrolling in a Microsoft Excel course with an official Microsoft Training partner.
The best Microsoft Excel training course is one that fits your needs.
The average person learning MS Excel can master it in a few weeks when they dedicate time to learning and practice.
Yes. You can learn the functionality of Microsoft Excel 2021 in 3 days; however, you may need to practice longer to become efficient in all Excel tasks.
Yes. Despite the rise of alternative analysis tools, MS Excel remains the most popular choice for data management because of its reliability and vast array of functions and uses.
Online! As Microsoft Excel is a digital tool, the best way to learn is at a computer studying an Excel course.
While - as with anything - you can teach yourself Microsoft Excel, it is quicker, easier, and more effective to enrol in an MS training course, avoiding picking up bad practice and less efficient ways of carrying out tasks.
From creating pivot tables to data analysis, this spreadsheet program has a huge variety of functions to learn. If you're a beginner level student, you can work your way up to having advanced excel skills. If you already have knowledge of Excel you can build upon that foundation and use your skills for financial analysis, data science, data visualisation, business analytics and so much more. Microsoft Excel skills are an essential for any professional toolkit.
Yes. Although there is a free version of Excel online, Microsoft excel as a desktop app still has many useful basic-level and advanced features. Microsoft Excel skills will translate to whichever you decide to use.
While some Microsoft Excel courses teach more advanced Excel skills, this starts from the basics making it perfect for a Microsoft excel beginner.
Being such a versatile platform, Microsoft Excel allows you to do almost anything a professional, student or employer would need to do. From complex formulas, to creating charts and graphs, interactive reports, data analytics and more advanced features. You can even import data from survey platforms such as Microsoft Forms and perform data analysis.
Choose any one from a HP Laptop, Fitbit Versa 2 or Apple Airpods*.
*Special terms and conditions apply to certain courses. See product page for details. View Deals