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.
AllAdobe InDesignAdobe PhotoshopManagementMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordSQLTime Management
VBA Class Modules: A Step By Step Guide
VBA Class Modules let you create your own custom objects. You can then combine this with object-oriented programming tools. This is one of the most advanced concepts we teach on our Excel courses, so take it step-by-step! What Is…
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, which are on the syllabus of our Excel VBA courses. This…
XMATCH Functions – Master Excels Array Tools!
Most people using Excel, have used the MATCH function. However, with more features and flexibility, the XMATCH function is much more powerful. It helps you look out for values and identify their position from a given range or array. Learn…
Master VBA Special Cells In Excel! [Advanced Guide]
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. It is also…
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’s GROWTH Function [2 Minute Guide!]
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…
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…
3 Ways To Use Excel For Accounting And Bookkeeping
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 is easy to use, cost-efficient, and one of the most…
How To Take Advantage Of Logical Functions 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 – Excel Forecasts
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…
[Quick Guide] Master The COUNTIF Function In Excel!
You will often need to work out your data by checking on particular portions of your data set that meet criteria. The COUNTIF a relatively simple function is designed to do just that and taught during our Excel Intermediate…
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…