News & Tips
Using Union Queries & Select Statements In 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…
Microsoft Word: Paragraph Formatting – Text alignment / line spacing / paragraph spacing / simple bullets
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…
Minute Taking: Tips For Creating Stress-free Minutes
Taking minutes at a meeting can be difficult. Whether you are taking them either to distribute to team members, or for your own personal record. You may struggle to work out what you have written as notes or minutes after.…
50 Essential Tips For A Great Interview
Job Interviews can be a nerve-wracking experience. However as standard practice worldwide they aren’t going anywhere soon. Sometimes the only thing standing between you and the job of your dreams – is the job interview. For this reason we have…
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 skimming…
Introduction To SQL Joins
Databases are commonly referred to as relational because they contain tables of data, some of which relates to data in other tables. For a SQL Server query to extract useful data from these related tables, you will need to understand…
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 appropriate…
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.…
3 More Top Office 365 Productivity Tips (Part 2)
This is part of our new series showing you how to make the most of Office 365. If you think these tips are helpful and want to expand your toolset even more, view our Office 365 Course Offerings here. For…
3 Top Office 365 Productivity Tips (Part 1)
There are two types of Office 365 users: The majority of Office 365 users continue to use Office applications as they did before they were moved across to Office 365. A growing minority of Office 365 users who embrace the…
Outlook Automatic Reply – 2 Minute Guide
If you are going to be out of the office for the day and you need to let others that are emailing you know then it is handy to set up an Automatic Reply. If you want to learn more…
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…