zandax online course logo
Info, Blogs, Contact & Login

Premiere Online Courses in Microsoft Excel

Great easy-to-follow courses for users of Microsoft Excel

All you need to transform your skills and knowledge from ZandaX

Microsoft Excel 365 (2021) Beginners
Microsoft Excel 365 (2021) Intermediate
Microsoft Excel 365 (2021) Advanced
Microsoft Excel VBA Beginners
Microsoft Excel VBA Intermediate
Microsoft Excel 2013/2016 Introduction
Microsoft Excel 2013/2016 Intermediate
Microsoft Excel 2013/2016 Advanced
Microsoft Excel 2013/2016 Professional

Home  >  Microsoft  >  Microsoft Excel

How Our Microsoft Excel Courses Will Benefit You

Microsoft Office Excel Training Courses

Microsoft Excel is used by pretty well anyone who analyzes data: whether it's summarizing sales figures or producing a business plan at work, or managing subscriptions or events for your social club. Maybe even for household budgets...

We run two sets of courses, at Introduction (beginner) to Advanced levels:
Our MS Excel 365/2021 courses cover the latest stand-alone release from Microsoft and include the features and functionalities currently available only in the subscription-based Excel 365. They are also extremely detailed, with each course giving you around 10 hours of interactive study.
Our MS Excel VBA courses really help you to supercharge your spreadsheets - they're based on Excel 2016, which uses VBA 7.1 and this hasn't changed since 2013. In fact, you can use much of what you learn here on other applications like Word, PowerPoint and Access.
Our MS Excel 2013/2016 courses are a great alternative for a lower-cost option (few of the basics have changed), for anyone looking for a speedy "crash course", and also for people who are using older versions of the software.

All our courses teach you the "right" way, using best practice and avoiding common pitfalls. By enhancing your data analysis skills, they will increase what you can do, the quality of your work -- and boost your productivity too!

CPD accredited courses

CPD Certified Courses

The CPD mark of approval means that not only have our courses been rigorously assessed in terms of content and quality, but there are options for you to get a CPD Certification certificate to keep.

See How You Can Learn About Microsoft Excel

Microsoft Excel 365 (2021) Beginners

A Great Foundation in Using Excel

A thorough guide to getting started with Microsoft Excel: whether you're a complete beginner, or someone who wants to learn the basics using best practice, this is the course for you.

It starts with the Excel 2021 interface and keyboard shortcuts, then introduces you to Excel formulas and functions before moving on to formatting cells and using Excel lists. We show you how to use charts, insert pictures, work with views, set page layout and a whole host more!

You'll now have a solid basis for understanding and using Excel confidently and effectively.

Microsoft Excel 365 (2021) Intermediate

Use Formulas, Functions and More

The course shows you how to use dynamic array functions as well as XLOOKUP, XMATCH, and FILTER.

It's a comprehensive guide on intermediate-level formulas, cleaning & analyzing data using PivotTables and Pivot Charts, controlling data input with validation rules, making decisions with WhatIf analysis, using the golden rules of best practice in spreadsheet design -- and a whole lot more!

Microsoft Excel 365 (2021) Advanced

Get the Advanced Data Analysis Tools You Need

The course takes advantage of the latest updates from Microsoft including the game-changing LET and LAMBDA functions. These exciting functions allow students to create their own variables and even their own Excel functions.

You'll be introduced to six brand-new dynamic array functions, learn how to build advanced Excel formulas, analyse data with advanced PivotTable skills, create macros to automate tasks, import and clean data with Power Query, forecast data, and so much more!

Microsoft Excel VBA Beginners

Learn How to Simplify and Automate Data Analysis

Are you spending too much of your time performing repetitive and laborious tasks in Excel? Our VBA Introduction course will save you time, by getting you up and running using macros and VBA fast!

We will show you how to create your own VBA programmes to automate complex tasks in Excel, and help you to gain a solid understanding of the main concepts of VBA.

Microsoft Excel VBA Intermediate

Supercharge Your Spreadsheets

This professionally produced course teaches you how to transform your spreadsheets.

You start with a great, easy-to-follow treatment of more advanced VBA language.

Next you learn about Event Patterns, and advanced tools for doing just about anything you need with VBA, and this is followed by a major section on Custom Objects.

There's plenty of information on making VBA work smoothly with Excel, before the course wraps up with a great tutorial on how to use References and Libraries.

This is the training you need to acquire advanced skills in using VBA.

Microsoft Excel 2013/2016 Introduction

A Great Foundation in Excel Skills

A thorough guide to getting started with Microsoft Excel: whether you're a complete beginner, or someone who wants to learn the basics using best practice, this is the course for you.

We show you how to get started, how to use the Excel interface and we outline the basics of running the software.

We then move to editing your workbook, printing and viewing your work, and we show you how to create and use Charts.

You will now have a solid basis for understanding and using Excel confidently and effectively.

Microsoft Excel 2013/2016 Intermediate

Use Formulas, Functions and More

Take your Excel skills to the next level with formulas & functions, tables, spreadsheet data tools and charts.

We start you off with advanced Excel file tasks, then move on to working with Functions and Formulas.

You than learn how to manage Tables, Data Tools and Charts, and finish with a great feature called Sparklines.

Your Excel skills will now enable you to produce impressive apreadsheets with little effort.

Microsoft Excel 2013/2016 Advanced

Get the Advanced Data Analysis Tools You Need

Are you ready to take your work from good to downright impressive?

You learn about Grouping, Outlining and Subtotals, and how to use What-If Analysis, Pivot Tables and Pivot Charts.

Then we introduce you to HLOOKUPS and VLOOKUPS, and finish with an introduction to Macros which will make your spreadsheets FLY!

You will now be able to produce spreadsheets that not only display your data, but analyse and play tricks with it too...

Microsoft Excel 2013/2016 Professional

Look at What You'll Learn

This course will enable you to get more out of Excel than most people will think possible!

You begin with Advanced Conditional Formatting, Form Controls and Templates, then learn about Advanced LOOKUP Functions

We teach you Advanced Functions, Array Formulas and Advanced Pivot Table Tools before introducing you to User Defined Functions and VBA.

But please don't rush to this level: make sure you have mastered the content of our other three courses first!

Recent reviews for our Microsoft Excel courses

review score of 5.0
Microsoft Excel 2013/2016 Intermediate
course was great and i had learnt from it.
Marc Bingham
review score of 4.0
Microsoft Excel 2013/2016 Advanced
I like the bite-sized videos. It's very easy to digest the techniques being taught.
Aaron Lim Kang Wei
review score of 5.0
Microsoft Excel 2013/2016 Intermediate
Brilliant content. Extremely easy to follow the presenter . Easy understandable format. Iím not easily pleased but this training was 5/5 for me.
Shamima Chowdhury
review score of 4.0
Microsoft Excel 2013/2016 Intermediate
I never thought of learning more for basic excel but i guess i am wrong. Good job i learned a lot from this.
Vanessa Espejo
review score of 5.0
Microsoft Excel 2013/2016 Advanced
The content is very well explained and demonstrated.
Andrew Pace
review score of 5.0
Microsoft Excel 2013/2016 Professional
Thank you great course
Samiur Rahman
review score of 4.5
Microsoft Excel 2013/2016 Advanced
it is really a nice course! The PDF guide was very useful for me to find alternative exercises to do
Giulia Mancini
review score of 4.5
Microsoft Excel 2013/2016 Intermediate
I found the course excellent content and easy to follow. A great insight into Excels capabilities.
David Bartholomew
review score of 5.0
Microsoft Excel 2013/2016 Advanced
The course content is Fantabolus , moreover pace on which the course is drafted is excellent
Sandeep Thakur
review score of 3.5
Microsoft Excel 2013/2016 Advanced
Good, full of valuable tips in easy explanations to understand for data analysis skills using Excel. The PDF file is pretty detailed. Thanks a lot for this informative course!
Seohyeon Lee

Student feedback scores


More About Our Microsoft Excel Courses

Master Spreadsheets with the Best Excel Training

If you use Microsoft Excel (and who doesn't?) we have the training course for you - giving you the education to boost your skills and your career.

We take you from understanding the Excel interface, through Functions, Formulas and Formatting, to data analysis tools like Pivot Tables and Lookups, and on up to automating spreadsheets using Macros.

If you're an advanced Excel user, we can take you through VBA programming from first principles up to a level where you may surprise yourself with what you can do!

In fact, if you're looking for a crash course in Excel, our online Excel training courses are the best way to get it, because you also get extended 24/7 access that allows you to go back as often as you like to review and revise your learning.

You have total flexibility ... you can work through all the course content so you have a thorough knowledge from start to finish. Or treat the content as your "library" - to refer to and learn as you need.

Either way, you'l find all our courses easy to watch and available 24/7 to upgrade your Microsoft Excel skills.

Save money with multi-course packages

Microsoft Excel

POWER pack: Microsoft Excel Beginner to Professional (Four courses)

You do not require any experience of using Excel, but you do need to be familiar with using a PC with Microsoft Windows.

More information

ZandaX online training course logo
ZandaX – Change Your Life ... Today
All content © ZandaX 2022
Close menu element
See how you score on a range of skills that are critical to your well-being and performance
Communication Skill test
Communication Skills
How Can You Communicate Better?
Would you like to see what kind of communicator you are? And how you can improve the effectiveness of your communications?
Likeability test
How Much Do People Like You?
Do you sometimes wonder just how likeable you are? And wouldn't you like to see how you can (genuinely) become more likeable?

Time Management test
Time Management
How Can You Make More Use Of Your Time?
Are you frustrated by how easily time slips away? Do you get frustrated when things don't get done just because you run out of time?
Assertiveness test
Are you Passive, Aggressive or Assertive?
Would you like to know where you fall on the behavior spectrum? Does your response to events sometimes surprise you?

Close menu element
Information & Resources
ZandaX information
Read more about us, our Privacy Policy and our Terms of Service
See how we want to help you, and how we make everything easy for everyone
Callback request
ZandaX Blogs
Articles to increase your knowledge and understanding in key areas of your life and career.
Read our blogs on Personal Development, Business Skills and Leadership & Management

Time Management test
Log In
Log in to your online dashboard
View your courses, review what you want and download your workbooks and certificates
Assertiveness test
Contact Us
An easy online form to get in touch
With options for More Information, Customer Service and Feedback

Close menu element
Learn About:
Personal Development
Leadership & Management
Sales & Presentations
Microsoft Office
Microsoft Project
Microsoft Visio

[NOTE: Mouse over the titles above,
then to visit the website pages you want,
click on the links in the right hand panel]
Our courses
We have everything covered: learn all applications at all levels!   All courses are CPD certified.
Microsoft Excel courses
Microsoft Excel 2021 / 365
Introduction to Advanced
Microsoft Excel 2013 / 2016
Introduction to Professional
Microsoft Powerpoint courses
Microsoft Powerpoint Introduction
Microsoft Powerpoint Advanced
Microsoft Word courses
Microsoft Word Introduction
Microsoft Word Intermediate
Microsoft Word Advanced
Microsoft Powerpoint courses
Microsoft Access Introduction
Microsoft Access Intermediate
Microsoft Access Advanced
Microsoft Outlook courses
Microsoft Outlook Essentials
Microsoft Project
Enhance your project management with our two intensive but very easy-to-follow CPD certified Microsoft Project courses.
Microsoft Project courses
Microsoft Project Introduction
Get a solid foundation in Project software to create solid, resilient project plans.
You don't need prior experience with Project: just be able to use a PC with Microsoft Windows.
Microsoft Project Advanced
The Advanced course takes you to a level that will put you in complete control of your projects.
You should, of course, be fully conversant with the skills and concepts taught in the Introduction course.
Microsoft Visio
Become a Visio master with our two intensive but very easy-to-follow CPD certified Microsoft Visio courses.
Microsoft Visio courses
Microsoft Visio Introduction
Get a solid base for using Visio to create high quality, impressive diagrams.
You don't need prior experience with Visio: just be able to use a PC with Microsoft Windows.
Microsoft Visio Advanced
This course will enable you to use Visio to design graphics at the highest level.
You should, of course, be fully conversant with the skills and concepts taught in the Introduction course.
Take a look at our new Marketing section which we begin with two great books on Copywriting
... there will be more to follow, so stay tuned!
Copywriting books
Copywriting for Results
A two-book set that will give you all you need to write great copy every time.
Get the first book to learn the process, then the second to see how to apply it to all media types.
  • Copywriting for Results: Your Complete Guide
  • Copywriting for Results: Putting It Into Action
Watch This Space
We have more in the pipeline so be sure to check back soon to see what's new!
More marketing books
Take a look at our new Leadership & Management section which we begin with a superb course on Managing Teams
... there's lots more to follow, so keep in touch!
Team Leadership courses
Team Leadership & Line Management
For practical advice on managing teams for results.
Make your team successful and more positive with tons of real-world techniques that work.
  • Team Management for Line Managers & Supervisors
  • Building High Performing Teams (in production)
Watch Out For More!
We have more courses in the pipeline so check back soon to see what's new!
More team leader courses
Great, easy-to-follow courses on how to succeed in sales and presentations
Drive Your Sales to New Levels
Selling Skills course
Learn how to sell more, to more people
Deliver Presentations that Get Results
Presentation Skills course
Build and deliver great presentations
Your Keys to Success are here!
Sales Management course
Manage your team for great results
Great, easy-to-follow CPD certified courses on skills that will change your life!
Learn How to Stop Wasting Time!
Time Management course
Get more out of every day of your life ...
Boost Your Self Esteem: Be Assertive
Assertiveness course
Learn how to deal with bad behavior
Great Communications = A Happy Life!
Communication Skills course
Supercharge your communications
Improve Your Relationships
Building Relationships course
Learn how to be more likeable!
Get a Plan to Beat Your Stress
Stress Management course
Learn how to reduce & manage your stress
It's the Behavior, Not the Anger!
Anger Management course
Control anger in yourself and other people
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we'll assume you're OK to continue.

I'm fine with this