![](/wp-content/uploads/2022/09/course-header.jpg.webp)
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.
![Screenshot showing the Freeze Panes option in the Window Group in the View Tab.](/wp-content/uploads/2022/02/3-1-768x78.png.webp)
Monitor Your Data With Freeze Panes In Excel!
In this post, we are going to review how to use the Freeze Panes feature in Microsoft Excel. Freeze Panes are a great tool to help you keep important data in view while scrolling around your sheet. Excel spreadsheets can…
![Excel User Level Graph](/wp-content/uploads/2023/04/Excel-AI-User-Level-Graph-768x475.png.webp)
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. Given the speed that AI is now being…
Introduction to Slicers in Excel
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…
Master The XLOOKUP Function In Excel!
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…
Recover Unsaved Files in Excel 2024
We all have been through the unfortunate instances of power disruption and system crashes that do away with all our unsaved work. Even if you take measures to plot against any unexpected power outage or system crash, sometimes Excel would…
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!
Lets say you are signing up for a loan – it is crucial to know the real interest rate! Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations can get…
The PMT Function – Master Excels Financial Tools!
Only a basic sense of the financial functions of Excel will help you get through most of your daily-life financial calculations. Excel offers multiple financial functions including PMT, IPMT, and PPMT, all of which are designed to cater to the…
Collections In VBA – The Ultimate Guide
In this tutorial, we will provide a comprehensive overview of Excel VBA Collections. You will frequently need to work with Collections in your VBA code. If you would like to learn more about VBA, then please consider joining our top-rated…
VBA Class Modules: A Step By Step Guide
In this tutorial, we will provide an introduction to VBA class modules. You can create your own custom objects by using VBA class modules. This allows you to take advantage of concepts, associated with object-oriented programming in your VBA code.…
The COUNTA Function – Use It In Your Own VBA Code!
In this post, we will review how to use the COUNTA Function in your VBA code. Excel allows you to use many of the built-in worksheet functions in VBA. This means that you don’t have to write the code for…
FILTER Function – Master Excels Array Tools!
The FILTER function from the Dynamic Array Tools of Excel is the very long-awaited substitute for the conventional filtering functions of Excel. How would you typically filter data in Excel? Using data filters. Or, if the situation takes a more…