close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Microsoft Excel Training courses

accredited by

Microsoft Gold Partner, on behalf of Microsoft Partner

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft Excel Masterclass Course Outline

Module 1: Navigation of the Excel Interface

  • Starting Excel
  • The Excel Tab Interface
  • The Main Components of the Workbook Screen
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Changing the Location of the Bar
  • Adding a New Command to the Toolbar
  • Removing a Command from the Quick Access Bar
  • Understanding the Status Bar

Module 2: Use of Lists and Tables

  • Understanding Lists
  • Applying a Filter
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Creating a Table
  • Converting Selection to a Data Table
  • Inserting or Deleting Table Records
  • Deleting Table Records
  • Removing Duplicates
  • Modifying a Table
  • Sorting Data in a Table
  • Naming Tables
  • Resizing Tables
  • Converting a Table to a Range
  • Deleting a Table

Module 3: Conditional Formatting

  • Understanding Conditional Formatting
  • Highlight Cells Containing Values
  • Highlighting Cells Containing Text
  • Highlighting Duplicate Values
  • Using Top and Bottom Rules
  • Using Data Bars
  • Using Colour Scales
  • Using Icon Sets
  • Creating Custom Rules
  • The Conditional Formatting Rules Manager
  • Clearing Rules

Module 4: Using Formulas and Creating Pivot Tables

  • Using Sparklines
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Insert Function Button
  • Working with Names and Ranges
  • Creating a Named Reference
  • Removing a Named Reference
  • What If Formulas
  • Common Logical Functions
  • Arguments used within If Functions
  • Creating a PivotTable from an Excel Data List
  • Add/Remove/Reorganise Data Fields
  • Changing the PivotTable Design
  • Refresh Data/Change Data Source
  • Creating and Modifying a Pivot Chart
  • VLOOKUP
  • Zooming In and Out Quickly
  • Undo, Redo, and Repeat with Keystrokes

Enquire Now to Get Free Advice from The Knowledge Academy Excel Training Experts!

Show moredown

Who should attend this Excel Training Course?

The course is intended for anybody wishing to learn how to use Microsoft Excel.

Microsoft Excel Masterclass Prerequisites

There are no formal prerequisites, but you should have some familiarity with computers and Windows 10. 

Microsoft Excel Masterclass Course Overview

The Knowledge Academy is Globally Recognised as the Global Market Leader in Excel Training Courses. Our "Microsoft Excel Team” comprises of over 426 leading Microsoft Office Experts who on average have more than 21 years of industry recognised teaching experience. Our instructors have developed a unique teaching style to help aspiring Excel Learners to master the art of successfully using Excel as a spreadsheet tool. Our Award-Winning Excel Masterclass Training Course Trainers will guide you step by step on how to use Excel spreadsheet tool successfully. All the topics and units are broken down in an easy to learn manner, making the course extremely enjoyable and our friendly instructors delight all our learners to use excel comfortably in their daily work life.

This Microsoft Excel Masterclass is designed to equip you with the vital skills required to effectively use Excel to create and edit workbooks and spreadsheets. Tailored especially to professionals who wish to use Excel in their work on a regular basis, the course focuses on practical tips for getting the most out of the program while improving productivity. Suitable for both those new to Excel and those with some previous experience, over 1 day of training, the course will show how to fully unlock Excel’s powerful capabilities for sorting and manipulating data. The course concludes with an exam to test your knowledge.

Enquire Now to Get Free Advice from The Knowledge Academy Excel Training Experts!​

Show moredown

What’s Included in this Excel Training Course?

Our Microsoft Excel Masterclass includes:

  • The Knowledge Academy Microsoft Excel Masterclass Manual
  • Experienced Microsoft Excel Trainer
  • Certificate of Completion
  • Refreshments

Show moredown

accredited by

Microsoft Gold Partner, on behalf of Microsoft Partner

Online Instructor-led (1 days)

Classroom (1 days)

Online Self-paced (8 hours)

Microsoft Excel VBA and Macro Training 

The Microsoft Excel VBA and Macro training course will explore the following modules:

Module 1: Introduction

  • What is a Macro?
  • Types of Macros
  • Command Macros
  • Function Macros
  • Macro Formatting
  • Run a Pre-Recorded Macro
  • VBA
  • Accessing VBA Editor
  • VBA – Excel Macros

Module 2: Event Handling

  • VBA – Events
  • Worksheet Events
  • Workbook Events

Module 3: Functions

  • Functions Overview
  • Calling a Function
  • User Defined Functions

Module 4: ERROR Statements

  • Error Statements Overview
  • Terms of Error Statements
  • Untrapped Errors

Module 5: Forms

Module 6: Referencing Other Applications

Module 7: Messages and Variables

  • Messages
  • Variables

Module 8: Simple IF Conditions

Module 9: Three Main Types of Loop

  • Loops Overview
  • While Wend Loops
  • Do While Loops
  • Do Until Loops

Module 10: Recording Macros and Buttons

  • An Introduction to Macro Recorder
  • Recording a Macro

Module 11: The Excel Object Model

  • Excel Object

Module 12: Debugging and Error Handling

  • Error Handling Routine
  • Handling Errors

Show moredown

Who should attend this Excel Training Course?

This training course is designed for those who have Microsoft Excel experience and would like to build upon this.

Prerequisites

There are no formal prerequisites, thus anyone can attend. We recommend that delegates can confidently navigate Excel, and are familiar with its main features, although this is not compulsory. No prior knowledge of Excel macros or VBA is required.

Microsoft Excel VBA and Macro Training Overview

This 1-day Microsoft Excel VBA and Macro training course are designed to bring delegates up to speed with the VBA programming language in Excel. The course is instructor-led and involves a number of practical, hands-on examples, and exercises within a workshop environment. Intended for those with some experience of Microsoft Excel, the course builds on previous skills to provide you with powerful techniques for editing macros and using Excel more efficiently.

During this VBA (Visual Basic for Applications) and Macros course, delegates will learn how to utilise Excel to achieve the best possible programming results. Primarily, delegates will discover how the automated features of Excel can ease their workload, therefore, this course is particularly useful for those who are consistently performing repetitive actions on worksheets. Individuals will also learn how to create their own macros, use and define variables, and work with a variety of objects. Essentially, this Microsoft Excel training course will enable you to do a lot more with your software, which is widely used within all areas of business.

This training course is suitable for all versions of Microsoft Excel.

Show moredown

What’s Included in this Excel Training Course?

This course includes:

  • The Knowledge Academy Microsoft Excel VBA and Macro Training Manual
  • Experienced Instructor
  • Certificate of Completion
  • Refreshments
 

Show moredown

Not sure which course to choose?

Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on +64 800 446148 or Enquire.

Package deals

Our training experts have compiled a range of course packages to compliment a variety of categories in order to help fast track your career. The packages consist of the best possible qualifications in each industry and allows you to purchase multiple courses at a discounted rate.

Swipe for more. Don’t miss out!

What our customers are saying

Frequently asked questions

FAQ's

Microsoft Excel is an industry-leading spreadsheet program for storing, manipulating and analysing data.
Our Microsoft Excel courses include a courseware book, refreshments, certificate upon completion and 1 day of tuition from an expert trainer.
Our Excel training courses are available across the world in thousands of locations, making it easy to find a course near you.
There are no formal prerequisites for attending our Excel courses, but you should have some knowledge of how to use a computer and Windows.
The Knowledge Academy is the Leading global training provider in the world for Microsoft Excel Training.
The price for Microsoft Excel Training certification in New Zealand starts from NZD495.

Why we're the go to training provider for you

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

Looking for more information on Microsoft Excel Training