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.
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…
Logical Functions in Excel – Individual Breakdown
If Computer Science were your major in High School, you would know 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…
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…
[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.…