Save 61%

Excel

4.4
30 opinions
  • The course is great. It’s a professional site and easy to follow. Staff is very helpful, I must say I'm glad I've chosen this centre.
    |
  • Currently taking the online Excel course and I’m pleased since it’s easy to understand and very detailed.
    |
  • I took the excel course and I’m very pleased with it. I can’t wait to take the next level. The course is well structured and there are a lot of exercises to practice what you have learned. Great experience!
    |

Course

Online

£ 19 VAT inc.

Description

  • Typology

    Course

  • Methodology

    Online

  • Class hours

    12h

  • Duration

    Flexible

  • Start

    Different dates available

  • Online campus

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Description

Unlock the secrets of Excel and learn:
How Excel works, how to navigate and design a spreadsheet.
The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF.

To use PivotTables, Pivot Charts and Basic Macros.
To create beautiful looking graphs and charts.
Formatting, including; conditional, cell and number formatting.
How to print what you want.

The Skillsology Excel course is your one stop shop for Excel knowledge. Covering a range of business essential Excel skills, it is accessible 24/7, as many times as you like.

Facilities

Location

Starts

Online

Starts

Different dates availableNow taking bookings

To take into account

Consists of 38 business focused Excel units from our distilled syllabus Contains 32 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 It is available in all the main versions of Excel (PC: 2003, 2007, 2010, 2013 & 2016 / 365; Mac: 2011) Generates a Certificate of Attainment and a Test Certificate (useful for CPD fulfilment) It is taught through a blend of text-based articles, practice spreadsheets, video tutorials, and podcasts Comes with email support from our experts.

This course is aimed at beginner to intermediate Excel users. If you are brand new to Excel or have a limited knowledge set you want to expand, then this course is for you. The course starts by covering the basics of Excel and then goes into essential formulas and functions. It then takes you through all the tools you will need to perform Data Analysis, including PivotTables and ends by looking at how you present and print your spreadsheets.

Open to all levels of professional and educational experience.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Opinions

4.4
fantastic
  • The course is great. It’s a professional site and easy to follow. Staff is very helpful, I must say I'm glad I've chosen this centre.
    |
  • Currently taking the online Excel course and I’m pleased since it’s easy to understand and very detailed.
    |
  • I took the excel course and I’m very pleased with it. I can’t wait to take the next level. The course is well structured and there are a lot of exercises to practice what you have learned. Great experience!
    |
100%
4.5
fantastic

Course rating

Recommended

Centre rating

Ruth Gaddess

4.0
01/10/2017
What I would highlight: The course is great. It’s a professional site and easy to follow. Staff is very helpful, I must say I'm glad I've chosen this centre.
What could be improved: Nothing
Would you recommend this course?: Yes

Denise Felder

4.5
04/09/2017
What I would highlight: Currently taking the online Excel course and I’m pleased since it’s easy to understand and very detailed.
What could be improved: Nothing
Would you recommend this course?: Yes

Patrice Diana

4.5
25/08/2017
What I would highlight: I took the excel course and I’m very pleased with it. I can’t wait to take the next level. The course is well structured and there are a lot of exercises to practice what you have learned. Great experience!
What could be improved: Nothing.
Would you recommend this course?: Yes

Funmi Elegbe-Odunaike

4.5
22/08/2017
What I would highlight: I’m doing the Excel course and I must say it has been amazing. Videos, exercises and notes at the end of the chapter are excellent. I think your job is great and I’ll totally recommend it to my friends.
What could be improved: Nothing.
Would you recommend this course?: Yes

Susan Dutton

4.0
22/08/2017
What I would highlight: Even thought I have taken only the first Excel course I’ve learnt many things so far. It is priceless to do the exercises at your own version of Excel. Brilliant course.
What could be improved: Everything OK
Would you recommend this course?: Yes
See all
Reviews gathered by Emagister & iAgora

Achievements for this centre

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 3 years

Subjects

  • Excel
  • Spreadsheet
  • Design
  • Graphics
  • Database
  • Data analysis
  • IT
  • Communication Skills
  • Calculus
  • Maths

Course programme

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

Takes a quick look at a first ‘real’ spreadsheet, in order to introduce the concept of functions and formulas, and give a feel for how Excel can be useful.


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 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 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


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

Excel

£ 19 VAT inc.