News & Tips
UNIQUE Function – Mastering Excels Array Tools
There are a number of functions to Excel that enable users to extract a list of distinct values. Ranging from highlighting duplicate values to advanced filters, the methods are many. However, laboring about the same old conventional methods and functions is…
Mastering VBA Special Cells In Excel
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. In addition, the VBA…
10 Tips For Delivering Professional Presentations
Many people describe presenting and public speaking as their greatest fears. Like most things in life presenting is a skill. It has to be practised and developed over time, no-one is born a great presenter. To help you learn…
SEQUENCE Function – Breakdown
SEQUENCE function is one of the most advanced and modern functions of Excel. It was introduced as a part of the dynamic array tools and is only accessible to Microsoft 365 users. To learn more about this intelligent array tool,…
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: New Research 2024
To inform how we teach our Excel training courses and find out more about how people are using Microsoft Excel in 2022 we have conducted some new, original research. In January & February 2022 we polled 1,000 office workers who…
The Ultimate Guide To Effective To-Do Lists
To-do lists are as old as writing. They are one of the most widely used and easily learned time management strategies. In this article, we take a detailed look at them to see how you can make the most…
Using the GROWTH Function in Excel
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 based…
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…
A Guide to Setting SMART Goals
Goals provide a sense of purpose, direction, motivation, and focus. SMART goals add extra dimensions to the goal-setting process to help you set and achieve your goals every time. Many team leaders and managers find the SMART framework very useful…
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 Illustrator: Creating a hilly scene with a sense of depth
This tutorial will show you how to create a landscape scene which has depth to it. You can learn how to do this and more in our Illustrator course which runs in Guildford and London. Set Up Swatches The…