Microsoft Excel

Cut Excel down to size with our tailored online course. Achieve certificated proficiency in hours.

We reviewed Excel's 500 functions, ruthlessly stripping out all non-essentials, to arrive at our highly refined syllabus. Our diagnostic tool then focuses your time on those parts of that syllabus that will be most valuable to you. Our regularly updated course consists of a carefully balanced combination of text, illustrations, videos and end-of-unit tests to measure your progress.

Our CPD UK certified online course covers what-you-need-to-know-in-business rather than what-Excel-can-do and covers all major versions of Excel including Excel 2016.

Highlights

Consists of 38 business focused Excel units from our distilled syllabus
Contains 100 hours of learning materials but can be completed in as little as 12 hours of dedicated study
Provides 24/7 access to all learning materials from the date you register
Is available in all the main versions of Excel (PC: 2003, 2007, 2010 and 2013, 2016 / 365; Mac: 2011)
Generates a Certificate of Attainment and a Test Certificate (useful for CPD fulfilment)
Is taught through a blend of text-based articles, practice spreadsheets, video tutorials and podcasts
Comes with email support from our experts.

Section 1: Foundation

Unit 1.1 - Excel Introduction

Unit 1.2 - The Excel Interface

Unit 1.3 - Basic Navigation and Editing

Unit 1.4 - Getting Going

Section 4: Data Handling

Unit 4.1 - Sorting and Filtering
Unit 4.2 - Controlling User Input
Unit 4.3 - Working with Dates & Times
Unit 4.4 - Working with Text
Unit 4.5 - Lookup and Reference
Unit 4.6 - Logical Functions

Syllabus

Section 2: Orientation & Efficiency

Unit 2.1 - Editing
Unit 2.2 - Viewing
Unit 2.3 - Spreadsheet Structure
Unit 2.4 - Cell References
Unit 2.5 - Named Ranges
Unit 2.6 - Basic Macros
Unit 2.7 - Design

Section 5: Data Analysis

Unit 5.1 - Working with Numbers
Unit 5.2 - Summarising Data
Unit 5.3 - PivotTables 1 - Simple Summaries
Unit 5.4 - PivotTables 2 - Manipulating Data
Unit 5.5 - PivotTables 3 -

Interpreting Data
Unit 5.6 - Formula Auditing
Unit 5.7 - Advanced Macros

and VBA
Unit 5.8 - Modelling

Section 3: Administration

Unit 3.1 - Customising Excel
Unit 3.2 - Housekeeping
Unit 3.3 - Connecting Workbooks
Unit 3.4 - Documentation
Unit 3.5 - Protecting and Sharing
Unit 3.6 - Excel Troubleshooting

Section 6: Presentation

Unit 6.1 - Cell Formatting
Unit 6.2 - Number Formatting
Unit 6.3 - Conditional Formatting
Unit 6.4 - Graphs and Charts
Unit 6.5 - Page and Print setup