News & Tips
AllAdobe InDesignAdobe PhotoshopManagementMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordSQLTime Management
3 Quick Ways To Recover Unsaved Files [Excel 2024]
We’ve all been there – working on an Excel file, only to have it disappear after a crash! Panic sets in, and you start to worry everything is gone. But you still have options. These methods are very important…
How Do Until Loops Can Help You – Power Automate
There is often a need to execute certain actions or instructions repeatedly. This can be achieved by using loops in Power Automate. A loop in Power Automate is a control that can automate actions. In this article, we look in…
Create And Personalise Your Excel Dashboard!
In this tutorial, we will take you through the steps needed to create an Excel Dashboard. We will also review some best practices when it comes to dashboard creation and visualization. An Excel Dashboard is a powerful visualization tool that…
The EFFECT Function – Master Excels Financial Tools!
Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations can get super challenging. However you are all covered as long as you can use the EFFECT function in Excel.…
The PMT Function – Master Excels Financial Tools!
Excel’s financial functions are here to help you with your daily finances. The PMT function is all about calculating payments for a loan. People on our Excel courses always want to know how their skills can apply to real…
Collections In VBA – The Ultimate Guide
If you have ever used VBA, you’ve used Collections. They are an object that can store multiple values. If you need a crash course on VBA from the ground up – check out our VBA Excel courses! Starting Off…
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…