Get the App on

Advanced Excel Diploma Course

Certified Course
Accredited Course

Course Information

10 Modules
Lifetime Access
Study Group Access

Accreditations

US$141.37
0% Payment Plan Available
US$11.12 + 6 monthly payments of US$21.71
Select Payment Plan at Basket
Have a coupon?
What Will You Learn?

Data has always been important to businesses and will only become more so. Being able to effectively manipulate, learn from and display the information within spreadsheets so that you and others can gain insight from them, is a skill that any business will find desirable – making those who can do so, a real asset.

The Advanced Excel Diploma Course will elevate your expertise in the use of Excel – explaining advanced formulas, data manipulation, graphical representation, security, accuracy, and annotation, advanced statistical analysis tools and error fixing.

We’ll begin by exploring how to set up and use pivot tables and how to slice and filter the data for advanced analysis, using macros to automate repetitive tasks and increase efficiency and take an introductory look at VBA.

From there, we’ll move onto wildcard expressions and advanced functions such as SUMIF and COUNTIF, and using AVERAGEIF, IFS, SUMIFS and COUNTIFS for advanced analysis, along with how to use the LOOKUP function, and its variations, to search and reference data.

We’ll look at how to secure and protect data from unauthorised usage, how to make information more readable for others with comments and notes, and how to perform Find and Replace queries. The course also covers how to validate data and create drop-downs and spreadsheets with advanced features to limit the entry of invalid data. 

For those who require advanced statistical analysis, you’ll learn how to use Excel’s powerful statistical functions and the Analysis ToolPak add-in to extend functionality even further.

Lastly, the course covers the most common errors that you may come across in Excel and how to correct them.

By studying this course, you will:

  • Know how to navigate Excel, view and print Excel files, and be aware of which tools are at your disposal and how to find them
  • Understand how to effectively format and calculate within Excel
  • Understand what can be achieved with Excel regarding functions and advanced formulas
  • Be able to effectively present data using charts and graphs
  • Learn how to use advanced statistical analysis tools
  • Be able to avoid common Excel errors
A man working on business documents on a digital tablet

Course Syllabus

What will I learn on the course?

Certified Course
Accredited Course
  • Introduction
  • Part 1: Pivot Tables
  • Part 2: Advanced Pivot Table Functions
  • Practical Task
  • Practical Task Answers
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 1 Assessment
  • Part 1: What is a Macro?
  • Part 2: Creating a Macro
  • Part 3: Visual Basic
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 2 Assessment
  • Part 1: Wildcard Expressions
  • Part 2: Absolute Cell References
  • Practical Task
  • Practical Task Answers
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 3 Assessment
  • Part 1: AVERAGEIF Function
  • Part 2: IFS Function
  • Part 3: COUNTIFS Function
  • Practical Task
  • Practical Task Answers
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 4 Assessment
  • Part 1: Lookup Function
  • Part 2: HLOOKUP Function
  • Part 3: VLOOKUP Function
  • Practical Task
  • Practical Task Answers
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 5 Assessment
  • Part 1: Sharing a Workbook
  • Part 2: Protecting an Excel File
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 6 Assessment
  • Part 1: Data Validation
  • Part 2: Create Drop Down Menus Through Data Validation
  • Part 3: Circle Invalidated Data
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 7 Assessment
  • Part 1: Statistical Functions
  • Part 2: Add Ins
  • Practical Task
  • Practical Task Answers
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 8 Assessment
  • Part 1: Comments and Notes
  • Part 2: Search Functionality Within Excel
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 9 Assessment
  • Part 1: Errors are Inevitable
  • Part 2: Understanding What the Error Means
  • Conclusion
  • Test Your Knowledge
  • Key Learning Points Exercise
  • Module 10 Assessment
Who Would Benefit from This Course?

You could be looking for an office career and want to put yourself above other candidates and be able to offer instant value to an employer. You may have a basic understanding of Excel and want to learn how to be more effective, faster, and more secure when using the software.

If you have a working knowledge of Excel and want to unlock the true potential of the software that you know is there but don’t know how to use, the Advanced Excel Diploma Course is for you.

Side view of a businesswoman working on a spreadsheet at her desk
Accreditations

The Advanced Excel Diploma Course will take you up to 150 hours to complete, working from home. There is no time limit for completing this course, it can be studied in your own time at your own pace.

This is a Level 4 course and will give you 150 CPD (Continued Professional Development) points.

Upon completion of your course assessments, you receive 2 certificates. A certificate from the Centre of Excellence and a CPD certificate displaying the number of CPD points earned from the course.

This course is endorsed by the Quality Licence Scheme. Therefore, upon successful completion of this course, learners can also receive a certificate of achievement from Quality Licence Scheme and a Learner Unit Summary, which lists the details of all the units the learner has completed as part of the course. (This certificate is optional and costs an additional £25).

The Quality Licence Scheme is part of the Skills and Education Group, a charitable organisation that unites education and skills-orientated organisations that share similar values and objectives. With more than 100 years of collective experience, the Skills and Education Group’s strategic partnerships create opportunities to inform, influence and represent the wider education and skills sector.

The Skills and Education Group also includes two nationally recognised awarding organisations; Skills and Education Group Awards and Skills and Education Group Access. Through their awarding organisations they have developed a reputation for providing high-quality qualifications and assessments for the education and skills sector. They are committed to helping employers, organisations and learners cultivate the relevant skills for learning, skills for employment, and skills for life.

Their knowledge and experience of working within the awarding sector enables them to work with training providers, through the Quality Licence Scheme, to help them develop high-quality courses and/or training programmes for the non-regulated market.

A State of the Art
Learning Experience

We provide a state of the art online learning platform, accessible from anywhere, learning available 24/7.

  • Access Your Personalised Course Library

    View your courses in your online course library.

  • On-the-go Learning

    Learn on your mobile, tablet, laptop or via audio.

  • Join our thriving online community

    Over 1 million learners.

  • Lifetime access

    Learn in your own time at your own pace.

A State of the Art Learning Experience
Don’t just take our word for it
Richard Neftin
Richard Neftin
You are on top of it in terms of getting my courses to me and communicating. I appreciate the structure of your website and how accessible and easy to maneuver around in it. Cheers. 5 stars!
Kim Milich
Kim Milich
Centre of Excellence have been fantastic! I am really enjoying my course and finding the materials and videos really helpful. I would highly recommend Centre of Excellence.
Marianna D
Marianna D
The Spiritual Life Coach course was informative and easy to follow. I feel like it's a unique course and I'm proud to have this certificate in my profile now!
Paula
Paula
Spiritual courses are a great resource and provide an excellent foundation for moving forward on your spiritual journey.
Paul Routledge
Paul Routledge
Brilliant set of courses. I recently completed an Egyptology course with them and was so impressed I enrolled into Greek mythology diploma. (I'm doing a masters in classical studies so the Greek mythology course will help). I'd recommend them to anyone who wants to learn new things at their own pace
Bellinda Dunn
Bellinda Dunn
A great range of programs. Likeable and informative presenters. Found the course really reassuring and helpful.
Ed Hove
Ed Hove
Great information. I can take more courses if I get time and money to continue.
Celebrating Your Success
Here at Centre of Excellence we are supremely proud to be at the heart of a vibrant community of hard-working students. The determination and enthusiasm of our students never ceases to impress us and there is nothing better than seeing our graduates go on to succeed in further education, work, business or just life in general!
Best Business Award
Best Business Award
This award is aimed at those that have gone
Learner Of The Year
Learner Of The Year
Have you really pushed the boundaries with
Outstanding Therapist
Outstanding Therapist
Are you helping your clients to make positi
Entrepreneur Award
Entrepreneur Award
Drive, ambition and a mindset for success a
Shining Star Award
Shining Star Award
This award recognises those that have gone
Achievement Award
Achievement Award
Have you gone on to really push the boundar
Contribution Award
Contribution Award
Have you helped to make a big difference to

Frequently Asked Questions

Below you’ll find the answers to the questions that we get asked the most regarding Centre of Excellence

There is no time limit for completing your course it can be studied in your own time at your own pace.

All of our courses vary in length but most of our courses will take you between 50 - 250 hours to complete. The length of this course can be found in the Accreditations section above.

Once purchased your course is located in your Learning Centre on our website. Please log in using the same email address that you used when you purchased your course.

You can purchase a printed copy of your course materials at the checkout or from within your Learning Centre at any time after purchasing your course.

This week's Top Sellers

4K People Enrolled
Event Management Diploma Course

Event Management Diploma Course

9 Modules

0% Finance
US$330.61 Save US$189.24
US$141.37
View Course
4K People Enrolled
Excel Diploma Course

Excel Diploma Course

9 Modules

0% Finance
US$141.37
View Course
3K People Enrolled
Marketing & PR for Small Businesses Diploma Course

Marketing & PR for Small Businesses Diploma Course

5 Modules

0% Finance
US$330.61 Save US$189.24
US$141.37
View Course
1K People Enrolled
Public Speaking Diploma Course

Public Speaking Diploma Course

8 Modules

0% Finance
US$300.55 Save US$159.18
US$141.37
View Course
640 People Enrolled
Speed Reading Diploma Course

Related News

Acupuncture FAQs: Let’s Get to the Point!

Acupuncture FAQs: Let’s Get to the Point!

Acupuncture is an ancient Chinese treatment for various medical conditions, and is a popular alternative to conventional medical optio... Read More

The Best Candle Wax Types

The Best Candle Wax Types

There are multiple different candle wax types to make use of when you’re making candles, and choosing one to suit your project is po... Read More

Using Feng Shui in the Home & Garden

Using Feng Shui in the Home & Garden

Have you ever walked into a room and immediately felt a strong sensation of peace? The Chinese practice of arranging objects and space... Read More

Facts About Bees in the UK - Everything You Want to Know

Facts About Bees in the UK - Everything You Want to Know

Bees are essential pollinators that play an invaluable role within both our immediate food chains and the wider environment. In the Un... Read More

Advanced Excel Diploma Course
US$141.37
Advanced Excel Diploma Course
Advanced Excel Diploma Course
Trustpilot
Certified Course
Accredited Course
650 Users Enrolled
US$141.37