News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
Master Union Queries & Select Statements – [SQL and Access]
Normally when bringing two sets of data together in a relational database the intention is for data in the two sources to be matched in some way. For example: Customers to Invoices, Suppliers to Parts, Staff to Absence. Occasionally, but…
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…
Introduction to VBA [Step-By-Step Guide]
VBA stands for Visual Basic for Applications. It is an object-orientated, event driven programming language. The VBA language can sound intimidating, but this step-by-step guide will walk you through each step smoothly. This article is an Excel VBA Tutorial…
Analysing Data In Excel (3 Quick Methods)
Data Analysis is the process of cleaning, collating, examining, and modelling data to deliver information and key insights. These insights can be used to assist with decision-making. Data Analysts look at providing answers, to specific business-related questions, by using data.…
PowerPoint: How To Zoom With Your Mouse
We recommend that all heavy users of PowerPoint learn the short cut keys. These speed up your work considerably as you don’t need to take your hands off the keyboard to then find the command that you want before resettling…
Excel’s Transpose Function – Syntax, Uses and Troubleshooting
The TRANSPOSE function inverts rows and columns. If you have ever had your data laid out and then realised it would be best the other way around: This is the function for you! It’s one of the best ways…
Transpose Data With Paste Special [1 Minute!]
Transposing is rotating or rearranging your data. Paste Special Transpose is a simple way to change the orientation of your data. This gives you much better control of your page layout! Paste Special Transpose We have a sample sales…
Excel Guide: Remove Blank Rows Or Cells
Occasionally you may find that it’s necessary to clean up your data and part of that cleaning up, may involve removing blank rows or blank cells. In this post, we are going to show you how to remove blank…
Excel Guide: Conditional Formatting [In 5 Minutes!]
Conditional Formatting formats a cell or group of cells based on your own conditions. There are a lot of options, but they are all simple to implement with this guide! On our Excel Courses, we teach a wide range…
Using Concatenate in Excel: A Complete Guide
Even expert excel users can sometime face issues with structuring data using the copy and paste function in excel. This is especially useful when you have tons of disaggregated data. To help with that, we’ve got the Excel concatenate function…
[Complete Guide] Tables In Adobe InDesign
We are all familiar with Tables from common applications such as Microsoft Word or Excel. Those of us who are involved in printing or in publishing need to know how to create and manage tables in InDesign. This guide will…
Creating A Simple Macro In Excel (Step-By-Step)
Creating a simple macro in Excel is easier than you think. Now, it may seem contradictory, but you do not need to learn Visual Basic for Applications (VBA) to record simple macros in Excel. VBA does, however, come in handy…