Advanced Excel

Skillsology
4.4
13 reviews
  • I really liked the course. The staff is helpful and promptly answers to your questions, price is reasonable and I can extend it without paying much more money too. Thanks for this, Skillsology.
    ← | →
  • An excellent learning platform for people that enjoy studying at their own pace. If you have any inquiry they answer quickly.
    ← | →
  • I took the Advance excel course, I’m not new to the program but I have never built a site from the beginning. I attended half of the course and so far it has been very useful and interesting. I strongly recommend it to anyone who is looking to improve their skills.
    ← | →

Course

Online

£ 49 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Class hours

    12h

  • Duration

    Flexible

  • Start date

    Different dates available

  • Online campus

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

This course is suitable for people with a good understanding, including analysts and number crunchers that want to get the most out of Microsoft Excel.

It consists of 20 business focused Advanced Excel units from our distilled syllabus.

Using advanced graphs and presentation techniques to maximise impact.

How macros and VBA automate your spreadsheets and increase interactivity.

How superpower functions can solve complex problems
Using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

In this course you will learn:
To use advanced graphs and presentation techniques
How macros and VBA automate your spreadsheets and increase interactivity
How superpower functions can solve complex problems
To use PivotTables and PowerPivots to turn raw data into key decisions

Accelerate your Excel knowledge and career by becoming an advanced Excel user.

Open to all levels of professional and educational experience.

Certification of Attainment. CPD accredited.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.4
fantastic
  • I really liked the course. The staff is helpful and promptly answers to your questions, price is reasonable and I can extend it without paying much more money too. Thanks for this, Skillsology.
    ← | →
  • An excellent learning platform for people that enjoy studying at their own pace. If you have any inquiry they answer quickly.
    ← | →
  • I took the Advance excel course, I’m not new to the program but I have never built a site from the beginning. I attended half of the course and so far it has been very useful and interesting. I strongly recommend it to anyone who is looking to improve their skills.
    ← | →
100%
4.5
fantastic

Course rating

Recommended

Centre rating

Cennet Cooper

3.5
22/08/2017
What I would highlight: I really liked the course. The staff is helpful and promptly answers to your questions, price is reasonable and I can extend it without paying much more money too. Thanks for this, Skillsology.
What could be improved: Nothing.
Would you recommend this course?: Yes

Martin Phillips

4.0
21/08/2017
What I would highlight: An excellent learning platform for people that enjoy studying at their own pace. If you have any inquiry they answer quickly.
What could be improved: Nothing.
Would you recommend this course?: Yes

Rachel Barron

4.5
10/08/2017
What I would highlight: I took the Advance excel course, I’m not new to the program but I have never built a site from the beginning. I attended half of the course and so far it has been very useful and interesting. I strongly recommend it to anyone who is looking to improve their skills.
What could be improved: Nothing.
Would you recommend this course?: Yes

Thelma Wilson

4.5
05/08/2017
What I would highlight: The courses are great and their customer service is excellent. Keep up the great work!
What could be improved: Nothing.
Would you recommend this course?: Yes

Gustavo Alexis Onsalo Guevara

4.5
20/07/2017
What I would highlight: Their customer service is excellent, I had a problem and they immediately resolved it. The course is well structured and full of videos. I’m looking forward for the next course!
What could be improved: Everything was ok.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

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

Subjects

  • Excel
  • Graphics
  • Database
  • IT
  • Communication Skills
  • Calculus
  • Maths
  • Data analysis
  • Statistics
  • Writing Skills

Teachers and trainers (1)

Simon Hurst

Simon Hurst

Accountant

Course programme

Section 1: Design and Risk


Unit 1.1 - Templates

Unit 1.2 - Efficiency and Risk

Unit 1.3 - Data Validation


Section 2: Advanced Techniques


Unit 2.1 - Functions and Super Powers

Unit 2.2 - Array Formulae

Unit 2.3 - Tables

Unit 2.4 - Advanced Range Names

Unit 2.5 - What If?

Unit 2.6 - Problem Solving


Section 3: Excel Interactivity


Unit 3.1 - Form Controls

Unit 3.2 - Visual Basic and Macros


Section 4: Spreadsheet Impact


Unit 4.1 - Practical Interactivity with VBA

Unit 4.2 - Conditional Formatting

Unit 4.3 - Charts that Inspire

Unit 4.4 - Sparklines

Unit 4.5 - Graphics Tricks and Techniques


Section 5: Turning Data into Decisions

See related categories

Advanced Excel

£ 49 VAT inc.

The best Excel courses

See all

See all