![](/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.
All You Need To Know About Forecasts In Excel
Microsoft Excel provides quite a few built-in tools to assist with forecasting. Forecasting refers to the process of predicting a possible future result/future results based on historical data. What Is A Forecast In Excel? Forecasts are models that contain predicted…
The Microsoft Skills Gap
Searching for a job can be difficult, similarly, working toward advancement in your organisation is also demanding. According to Inc, Microsoft is the most widely-used business software in the world and will go a long way in helping you…
Excel Power Query
The intelligent excel tool to structure, load, share and analyse data, Power Query, is one of the most powerful features of modern-day excel. If you are eager to learn how it works, you are in the right place. Below is…
[Quick Guide] Master The COUNTIF Function In Excel!
You often need to work out your data statistically by checking on particular portions of your data set that meet specific criteria. The COUNTIF function is designed to help you with that. Want to learn how to use the COUNTIF…
How To Make A Stacked Bar Or Column Chart (5 Minutes Or Less!)
Charts and graphs are efficient ways of data presentation that help users visualize data. They help a user to decode and readily understand data, big or small. Visualizing data in the form of a picture is always easier than skimming…
Introduction to VBA: Step-By-Step Guide
VBA stands for Visual Basic for Applications. It is an object-orientated, event driven programming language. The VBA language can sound intimidating, but this step-by-step guide will walk you through each step smoothly. This article is an Excel VBA Tutorial appropriate…
Analysing Data In Excel (3 Quick Methods)
Data Analysis is the process of cleaning, collating, examining, and modelling data to deliver information and key insights. These insights can be used to assist with decision-making. Data Analysts look at providing answers, to specific business-related questions, by using data.…
How to Use the Transpose Function in Excel
There may be times when you’ll need to switch the layout of your data set around. In situations like these you can use the Excel transpose function! Excel Transpose Function To change the layout of your data set from horizontal…
Excel Guide: Remove Blank Rows Or Cells
Occasionally you may find that it’s necessary to clean up your data and part of that cleaning up, may involve removing blank rows or blank cells. In this post, we are going to show you how to remove blank rows…
Applying Conditional Formatting In Excel
Conditional Formatting allows you to format a cell or group of cells based on a certain condition or conditions being met. Excel provides a wide range of conditional formatting options, and they are simple to implement in your worksheets. …
Using Concatenate in Excel: A Complete Guide
Even expert excel users can sometime face issues with structuring data using the copy and paste function in excel. This is especially useful when you have tons of disaggregated data. To help with that, we’ve got the Excel concatenate function…
Creating A Simple Macro In Excel (Step-By-Step)
Creating a simple macro in Excel is not a daunting task. Now it may seem contradictory, but you do not need to learn Visual Basic for Applications (VBA) to record simple macros in Excel. VBA does however, come in handy…