All courses available in-class and remotely.

Excel Tips

Just how easy is power maps?

Everyone knows about the incredible business capabilities of Excel. Although considered an application for “number people” it can be a powerful visualisation tool. Take Power Maps – the handy tool that maps data.

Financial Analyst Career
How to become a Financial Analyst

A Financial Analyst uses financial data to predict business outcomes which help their organisations make better business decisions.

FAQs about Learning Excel Online

Knowing how to effectively use Excel is a game-changer in workplace productivity, so it's time to ask the question: What is the best way to learn Excel online? Find this and other FAQs here

BERT - Combining Excel and R

One of our recent discoveries is BERT aka the Basic Excel R Toolkit. This is a package for working with the R programming language functions from Excel. It's a wonderful resource for adding functionality to Excel and best of all, it is free!

Excel Cheat Sheet
A Microsoft Excel Cheat Sheet
We have compiled a cheat sheet with some quick shortcuts you should make sure you have in your Excel skill set.
What is xlookup?
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?
Excel spreadsheet
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.

List of employee names in a spreadsheet
How to create a drop-down list in Excel

Drop-down lists are a great way to work as efficiently as possible with data entry in Excel. This short guide will show you how to make your own custom drop-down list in five easy steps.

Excel and AI
Where AI and Excel Meet – Ignite Updates

Microsoft has just made AI and Excel a thing. The new updates from the Microsoft Ignite festival is something you don't want to miss. Check it out now.

Excel for Mac
5 Tips for Excel 2016 for Mac

If you are a Mac user and also delve into Excel then read on for some tips and tricks that could save you a ton of time!

Excel table
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.

 

The Most Useful Function in Excel
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.

13 tips for using excel efficiently from nexacu
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.

Tips To Troubleshoot VLOOKUP in Excel
Tips To Troubleshoot VLOOKUP in Excel

In this blog, we will troubleshoot the most common mistakes made while using VLOOKUP in ExcelI and provide some quick and easy solutions.


Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 41623 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us