News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
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…
Where Is The Best Place To Work In The World? – Country Ranking
Few experiences enhance your professional expertise and strengthen your cultural awareness like living and working abroad. Learning how businesses operate in foreign countries and having the chance to build relationships with international peers creates lasting rewards. Working abroad also…
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 Facts & Statistics: Original Research
To inform how we teach our Excel training courses, we have conducted new, original research. We wanted to know just how many people are using Excel, and how confident they are with it. For full details of our sample…
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…