Location: Online course
Course Access: 12 Months
Exam Included: Yes
Entry Requirements: None
Compatibility: All major devices
Searching for an Excel course for beginners to experts? This online course has something for everybody, covering beginner, intermediate and advanced aspects in Excel.
In this Excel training online, you will discover the fundamental techniques including how to utilise mathematics, statistical, logic and text functions, arrange data by sorting and filtering, efficiently present your information in a number of chart formats and more. You will also discover intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.
Whether you use Excel for work or study, these modules will start you on your journey to becoming an Excel expert! Discover more about how a Harley Oxford Excel certification can boost your career.
As soon as you have enrolled, our friendly support staff and tutors are here to assist with any course-related queries.
Microsoft Excel – Beginners, Intermediate & Advanced Levels
This detailed course has been designed for anyone who wants to drive their career forward. The course covers a large variety of topics spanning over a number of detailed modules.
During the Microsoft Excel course, you will learn the fundamental techniques including how to utilise mathematics, statistical, logic and text functions.
In addition to this, you can learn how to arrange data by sorting and filtering, efficiently present your data in a number of chart formats and much more.
The great thing about this course is that there are no entry requirements. You don’t need any specific education or work experience, just the desire to learn, enhance your knowledge and skills and succeed in your desired career moving forward.
Once you select the Microsoft Excel course and your payment is received, you can start learning straight away. Everyone can study flexibly at different paces, which is why this course is such a great opportunity, enabling you to work and study in your available time. On completion of the course, you will need to complete a multiple-choice test and on passing, you will be issued a certificate that you can download and print which is recognised by industry professionals.
What you will learn in the Microsoft Excel Course
The Microsoft Excel beginners, intermediate & advanced levels comprise of a number often detailed modules for you to learn and gain knowledge from. In total the modules should take around thirty hours to complete, bearing in mind that everyone studies at different paces and some people will have more time to study than others.
The essential modules in this course include:
Create your first Excel file, enter data and create a table.
Format cells by selecting fonts and colour fill to make information more attractive.
Utilise the keyboard or mouse to select cells and ranges in a spreadsheet.
Benefits of the Microsoft Excel Course
The Microsoft Excel course will provide you with a host of skills and knowledge you will be able to use on a daily basis. There are a number of benefits to completing the Microsoft Excel course:
Learn at your own pace
Unlimited tests and exams
Get a certified qualification
Mobile (learn on-the-go)
Microsoft Excel Beginners
Before You Start
What is a Spreadsheet Program?
Getting Started with Microsoft Excel
Workbook Windows and Views
Basic Spreadsheet Skills
Using the Help System
Workbook File Formats
Creating New Workbooks
Auto Sum and AutoFill
Cells, Rows and Columns
Working with Worksheets
Edit, Copy and Move Cells
Printing and Previewing Worksheets
Microsoft Excel Intermediate
Before You Start
Sort Data and Remove Duplicates
More About Charts
Headers and Footers
Microsoft Excel Advanced
Before You Start
Text to Columns
What-if Analysis – Data Tables
What-if Analysis – Scenarios
Maths and Trig Functions
Getting External Data
Pivot Tables and Pivot Charts
Protecting and Sharing Worksheets and Workbooks
Workbook Properties and Inspection
Encrypting and Finalising Workbooks
An Introduction to Macros
Illustrations, TextBoxes and WordArt
Custom Number Formats
Working with Template