- Location: Online course
- Certification: Included
- 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
- Selecting Cells
- Cell Referencing
- Auto Sum and AutoFill
- Formatting Numbers
- Formatting Cells
- Cells, Rows and Columns
- Working with Worksheets
- Edit, Copy and Move Cells
- Proofing Workbooks
- Printing and Previewing Worksheets
- Basic Options
- E-Mailing Workbooks
Microsoft Excel Intermediate
- Before You Start
- Defined Names
- Sort Data and Remove Duplicates
- Chart Basics
- Chart Design
- Chart Layout
- Chart Format
- More About Charts
- Date Functions
- Logical Functions
- Information Functions
- Financial Functions
- Headers and Footers
- Adding Comments
- Conditional Formatting
Microsoft Excel Advanced
- Before You Start
- Text to Columns
- Paste Special
- Data Validation
- Consolidate Data
- What-if Analysis – Data Tables
- What-if Analysis – Scenarios
- Text Functions
- Lookup Functions
- Maths and Trig Functions
- Statistical Functions
- Database Functions
- Linking Data
- 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
- Custom Lists
- Working with Template
About the School
Whether you’re looking to learn new skills, gain a qualification or to start a business, Harley Oxford can help you. Our school’s reputation has thrived by word of mouth; to us, we couldn’t ask for a ... Read More