![](/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.
The RANDARRAY Function – Master Excel Array Tools!
While Excel already had RAND and RANDBETWEEN functions, what was the need for another random number generating function? The RANDARRAY function was needed as it is not a mere random number generator but far more advanced and powerful. It allows…
XMATCH Functions – Master Excels Array Tools!
Most people using Excel, have used the very important MATCH function. However, with more features and flexibility, the XMATCH function is a successor to the MATCH function of Excel. It helps you look out for values and identify their position…
UNIQUE Function – Mastering Excels Array Tools
There are a number of functions to Excel that enable users to extract a list of distinct values. Ranging from highlighting duplicate values to advanced filters, the methods are many. However, laboring about the same old conventional methods and functions is…
Mastering VBA Special Cells In Excel
In this post, we are going to review the VBA Special Cells method in Excel. You can use the VBA Special Cells Method to select cells of a specific type or that match a certain criterion. In addition, the VBA…
SEQUENCE Function – Breakdown
SEQUENCE function is one of the most advanced and modern functions of Excel. It was introduced as a part of the dynamic array tools and is only accessible to Microsoft 365 users. To learn more about this intelligent array tool,…
Making A Gantt Chart In Excel (Quick & Easy!)
In this article, we will look at how to create a Gantt chart in Microsoft Excel. Gantt charts assist with project planning since they allow you to schedule and plan project activities. If you would like to learn more about…
Excel Facts & Statistics: Original Research
To inform how we teach our Excel training courses and find out more about how people are using Microsoft Excel in 2022 we have conducted some new, original research. In January & February 2022 we polled 1,000 office workers who…
Using the GROWTH Function in Excel
The GROWTH function in Excel is one of the most powerful and is very underused! Excel GROWTH Function The Excel GROWTH function is also known as the exponential GROWTH function. It is a statistical function that returns predictive values based…
Ultimate Guide to Advanced Filters in Excel
Excel Advanced Filters are one of the main reasons why people prefer using Microsoft Excel for most of their work – be it data recording, analysis, or presentation. But to your surprise, the simple filter of Excel is not even…
Office Computer Skills, Tips and Keyboard Shortcuts
Keyboard shortcuts make you to be a faster and more efficient computer user. When learning Microsoft applications mastering keyboard shortcuts should be high on your list of priorities. Optimising your workflow can be key – did you know 38%…
3 Excel Features for Accounting & Bookkeeping
Even after the emanation of automated bookkeeping software and technologies, Excel is still widely used for accounting and bookkeeping purposes. Many businesses and entrepreneurs continue to use Excel to record, store, analyze and manage their records. This is because Excel…
How To Take Advantage Of Logical Function In Excel!
Anyone that studied maths knows how powerful logical functions can be. And if it wasn’t, then this guide is all you need to become proficient in the logical functions in Excel. The details are given below, so let’s dive right…