News & Tips
AllAdobe InDesignAdobe PhotoshopManagementMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordPublic SpeakingSQLTime Management
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…
Adobe InDesign: The Frames and Shapes tool
Frames and Shapes are used to create objects that appear in your InDesign document. Frames are designed to hold graphics or text that you want to appear in your document. They are basically containers or placeholders. Shapes can also hold…
Adobe InDesign: How To Create An Interactive Button
In this InDesign tutorial, we will cover create an interactive button that will take you to a URL when it is clicked. Working with interactive buttons and the like are covered in our step-by-step InDesign training classes. Create The…
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…
InDesign: Change The Bullet Character [Short & Simple]
You can very simply bring character to your lists by using different bullet characters. Good clear design will make your documents more memorable and stand out for readers. Customising bullets, fonts and the like on our InDesign course for complete…
Creating Ligatures & Colour Alternates [Adobe Fonts]
Before you start this tutorial, make sure you have the following as before: FontSelf Extension for either Adobe Illustrator or Adobe Photoshop or BirdFont is you are using a free alternative. As mentioned before, this is a four-part series of…