Excel + Advanced Excel

Skillsology
4.4
14 reviews
  • Courses are tailored to individuals and you can study at your own pace. It’s a great deal for money since it has practical exercises and you can get a certificate on successful completion.
    ← | →
  • I bought Excel and Advanced Excel from Amazon. Although I started late, I called customer service and they helped me. Very good experience.
    ← | →
  • I chose the basic and advanced course. The courses are organized on a user-friendly platform that allows you to study at your own pace. I can’t wait to learn new formulas.
    ← | →

Course

Online

Save 70%
£ 29 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Class hours

    36h

  • Duration

    Flexible

  • Start date

    Different dates available

  • Online campus

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

The complete Excel training programme. With over 200 Excel training modules included, you will learn formulas, functions, graphs, PivotTables, macros and so much more. On completion of the course you receive a CPD UK accredited certificate of attainment and the option to test your Excel level with our Excel IQ testsThe complete Excel training programme.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Cut Excel down to size with our tailored online courses. Achieve certificated proficiency in hours. Available in all major PC and Mac versions.

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.

Open to all levels of professional and educational experience. Suitable for all levels of Excel user.

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
  • Courses are tailored to individuals and you can study at your own pace. It’s a great deal for money since it has practical exercises and you can get a certificate on successful completion.
    ← | →
  • I bought Excel and Advanced Excel from Amazon. Although I started late, I called customer service and they helped me. Very good experience.
    ← | →
  • I chose the basic and advanced course. The courses are organized on a user-friendly platform that allows you to study at your own pace. I can’t wait to learn new formulas.
    ← | →
100%
4.5
fantastic

Course rating

Recommended

Centre rating

Neil Duffill

4.5
02/10/2017
What I would highlight: Courses are tailored to individuals and you can study at your own pace. It’s a great deal for money since it has practical exercises and you can get a certificate on successful completion.
What could be improved: Nothing
Would you recommend this course?: Yes

Susan Norton

4.0
22/08/2017
What I would highlight: I bought Excel and Advanced Excel from Amazon. Although I started late, I called customer service and they helped me. Very good experience.
What could be improved: Nothing.
Would you recommend this course?: Yes

Manuel Fontenot

4.5
21/08/2017
What I would highlight: I chose the basic and advanced course. The courses are organized on a user-friendly platform that allows you to study at your own pace. I can’t wait to learn new formulas.
What could be improved: Nothing.
Would you recommend this course?: Yes

Mary Eun

4.5
09/08/2017
What I would highlight: I have completed the Excel intro and Excel Advanced to learn new skills about this useful software. I’m so happy I did it. Lessons are organized and service folks were very responsive.
What could be improved: Nothing
Would you recommend this course?: Yes

Blue White

4.5
05/08/2017
What I would highlight: I took my first course on Skillsology, so far the service is excellent. I can learn at my own pace and their customer service is amazing. I emailed them and received a respond within an hour. I’m trying to spend more time on my course and the fact that I can access it for a year is really handy. Thanks Skillsology.
What could be improved: Nothing.
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

  • PowerPivot
  • Excel
  • Advanced Excel
  • Graphics
  • Excel Formula
  • Excel for Accounting
  • Database
  • IT
  • Communication Skills
  • Calculus

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


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

Unit 3.7 - 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 - PowerPivot: Handling Big Data

Unit 5.7 - Formula Auditing

Unit 5.8 - Advanced Macros and VBA

Unit 5.9 - Modelling


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


Advanced Excel Syllabus:

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 Superpowers

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

Unit 4.6 - Working with External Data


Section 5: Turning Data into Decisions

Unit 5.1 - Advanced Uses of PivotTables

Unit 5.2 - PowerPivot

Unit 5.3 - Reporting with PowerPivot

See related categories

Excel + Advanced Excel

£ 29 VAT inc.

The best Excel courses

See all

See all