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.
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: New Research 2024
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! You may also want to learn more about our Microsoft Excel courses available here. Excel GROWTH Function The Excel GROWTH function is also known as…
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…
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. If you would like to learn more about forecasting, then please join…
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…