All courses available in-class and remotely.

Excel Insights

What is xlookup?
March 12, 2020

What is XLOOKUP and how to use it

XLOOKUP is the newest addition to the Excel lookup functions. You may have already heard of VLOOKUP, but how does it differ from its younger and more versatile brother?
Read More >
Person holding phone and paper with charts
July 10, 2019

Office 365 – the productivity powerhouse

The team at Microsoft is always implementing new tools to make sure your important data is properly integrated into your digital systems. Read on for three simple, yet smart features that help make this happen.

Read More >
Excel spreadsheet
February 05, 2019

How to create Pivot Tables in Excel

Pivot Tables are one of the most powerful tools in Excel. A Pivot Table is a table of statistics that summarises data from a more extensive table. Here’s a quick overview of how to create your own Pivot Table.

Read More >
Visual Basic terminology
January 25, 2018

Excel VBA Terminology

Visual Basic for Applications is a derivative of the programming language Visual Basic. Each Office application has its own particular kind of VBA depending on the objects and operation of the application.

Read More >
Reading glasses in front of computer screens
October 30, 2017

4 Tips for VBA Excellence

If you are trying to automate an Excel spreadsheet using VBA programming the following tips and tricks will help you become more proficient.

Read More >
Excel table
June 05, 2017

Applying Conditional Formatting

I’ve been conducting Excel Courses for Excel Consulting for a couple of years now. Excel Intermediate is our most frequently offered course. In that course, Conditional Formatting seems to be the most favorite topic for most groups that I’ve come across.

 

Read More >
The Most Useful Function in Excel
May 23, 2017

The Most Useful Function in Excel

The most common function in Excel would most likely be the SUM function, but our vote is that the excel IF function is definitely the most useful.  This tutorial explains how to use the IF function and how this can become an integral part to simplifying your formula editing.

Read More >
13 tips for using excel efficiently from nexacu
May 18, 2017

13 Excel Shortcuts You Need to Know

If you are looking at increasing your workplace productivity then learning how to use Microsoft Excel efficiently is a great step. We present 13 Microsoft Excel shortcuts that you need to know and will supercharge your skills.

Read More >

Topics

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 36005 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us