merger merger

Welcome to your new course portal!

On October 15th, moved to - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show as: Mobile

Microsoft Excel – Beginner, Intermediate & Advanced

Oplex Careers
Course summary
600 GBP
Next available date: Contact for dates - Distance
e-learning / Online / Distance

Course description

Microsoft Excel – Beginner, Intermediate & Advanced:

The Microsoft Excel 2013 Beginner course is split into the following modules:

Introduction to Spreadsheets
Understanding Microsoft Excel
Excel Workbook Windows
Basic Spreadsheet Skills
Excel Help System
Opening and Closing Workbooks
Understanding Workbook File Formats
Creating New Workbooks
Selecting Cells
Auto Sum and Auto Fill Function
Cell Referencing and Request
Formatting Cells
Formatting Numbers
Placing Cell Alignment
Cell, Rows and Columns
Understanding Worksheets
Editing, Copying and Moving Cells
Page Layouts in Excel
Proofing Workbooks
Basic Options, Ribbons and Toolbar
Final Assessment

The Microsoft Excel 2013 Intermediate course is split into the following modules:

Introduction to Excel Spreadsheet Intermediate Level
Defining Names in Excel
Sorting Data
Using Excel Tables
Filtering Data in Excel
Understand Charts
Chart Design Options and Tools
Chart Format Tools
Combo Charts
Functions within Excel
Understanding Date Function
Information Functions
Logical Functions
Financial Functions
Find and Replace
Headers and Footers
Adding Comments
Conditional Formatting
Final Assessment

The Microsoft Excel 2013 Advanced course is split into the following modules:

Introduction to Excel Advanced
Using Text to Columns
The Paste Special Function
Data Validation
Subtotals and Grouping
Consolidating Data
Scenario Analysis
Data Tables in Scenario Analysis
What-if Analysis
Mats and Trig Functions
Text Functions in Excel
Using Lookup Functions
Using Statistical Functions
Databse Functions
Formaula Auditing and Error Tracing
Hyperlinks in Excel
Linking Data
Understanding Pivot Tables
Using Pivot Charts
Workbook Properties
Protecting and Sharing Worksheets
Data Encrypting and Finalising Workbooks
Understanding to Macros
Custom Number Formats in Excel
Using Custom Lists
Working with Templates
Tracking Changes in Excel
Merging and Compare Excel Workbooks
Final Assessment

Suitability - Who should attend?

The are no previous entry requirements

Outcome / Qualification etc.

Certificate of Attendance

About provider

Oplex Careers

Oplex Careers Training Courses

If you are thinking of taking a course but don’t have the time to attend a traditional college then take an Oplex Careers online course today. With the Oplex Careers courses you can study online, giving you the freedom and...

Read more and show all courses with this provider

Contact info

Oplex Careers

26 York Street
W1U 6PZ London


There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in's second annual U.K. L&D Report!


Learn more