News & Tips
AllAdobe InDesignAdobe PhotoshopManagementMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordPublic SpeakingSQLTime Management
[Quick Guide] Master The COUNTIF Function In Excel!
You will often need to work out your data by checking on particular portions of your data set that meet criteria. The COUNTIF a relatively simple function is designed to do just that and taught during our Excel Intermediate…
Converting Text Into A Table [Word Guide]
Converting Text Into A Table format can help you better organise your data for people reading it. It also allows you to easier transfer your data between Word and Excel, making it great for any user of both. If you…
Power BI: Quick Guide To Customising Themes In Power BI
Using Power BI Desktop themes, you can apply design changes to your entire report. This can include using corporate colours, and changing the default font size. This is one of the great features that you learn as you discover how…
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…
Master Your Paragraph Formatting [Word Skills]
Need to neaten up your Word documents? Luckily for you, we know just the trick! Follow our guide below on how to carry out simple paragraph formatting tasks in Word, such as text alignment, line spacing, paragraph spacing and bullet…
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 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…