
Microsoft Excel
Our Excel articles below show clearly and simply how to use specific aspects of Microsoft Excel. We also cover these in our Excel training courses.

Complete Guide To Percentages in Excel!
In this article, we will demonstrate how to calculate a percentage in Microsoft Excel, Word and PowerPoint. Additionally, we will go through some other important percentage related calculations. What is a Percentage? A percentage is defined, as a part or…

Finding Outliers In Excel: A Detailed Guide
Microsoft Excel is an incredibly powerful data analysis tool that empowers users to store, analyse, and visualise data to derive valuable insights out of it. With so many basic and advanced level data analysis tools, Excel provides you with almost…

Mastering Excel’s LEN Function
The LEN function calculates the number of characters in a text string. For example, using “=LEN(‘Excel Magic’)” would yield the result “11”. This function is essential for data analysis and validation. LEN Function Details Available in: All versions of…

Monitor Your Data With Freeze Panes In Excel!
Freeze Panes isolate a section of your worksheet, so that it is always in view. They are a great tool to help you keep important data in view while scrolling around. It’s an important way to keep your data…

Excel AI – New Usage Data & Statistics Q2 2024
Everyone is talking about artificial intelligence. But how many people are actually using artificial intelligence day-to-day? To find out, we surveyed Excel users across the spectrum, from beginners to experienced professionals. With how useful they are, we may even…
Slicers In Excel – Why Are They So Useful?
Slicers in Excel are often used together with Excel tables and Pivot tables. What are they used for? Quick filtering of data from huge, densely packed data sets. What distinguishes Slicers from ordinary data filters is their visual appeal and…
Learn To Use XLOOKUP [2 Full Examples!]
It’s time we introduce you to the new member of the modern function family of Excel – the XLOOKUP function. XLOOKUP is the successor to the conventional VLOOKUP, INDEX & MATCH, LOOKUP, and the HLOOKUP function. You must have heard…
3 Quick Ways To Recover Unsaved Files [Excel 2024]
We’ve all been there – working on an Excel file, only to have it disappear after a crash! Panic sets in, and you start to worry everything is gone. But you still have options. These methods are very important…
Create And Personalise Your Excel Dashboard!
In this tutorial, we will take you through the steps needed to create an Excel Dashboard. We will also review some best practices when it comes to dashboard creation and visualization. An Excel Dashboard is a powerful visualization tool that…
The EFFECT Function – Master Excels Financial Tools!
Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations can get super challenging. However you are all covered as long as you can use the EFFECT function in Excel.…
The PMT Function – Master Excels Financial Tools!
Excel’s financial functions are here to help you with your daily finances. The PMT function is all about calculating payments for a loan. People on our Excel courses always want to know how their skills can apply to real…
Collections In VBA – The Ultimate Guide
If you have ever used VBA, you’ve used Collections. They are an object that can store multiple values. If you need a crash course on VBA from the ground up – check out our VBA Excel courses! Starting Off…