News & Tips
How To Use The Tools In Photoshop CC
The tools in Photoshop CC 2020 provide a variety of ways to perform your edit work process. We cover the tools used in Photoshop in detail in our Photoshop training courses. This article explores each tool and how to use…
Excel Power Query
The intelligent excel tool to structure, load, share and analyse data, Power Query, is one of the most powerful features of modern-day excel. If you are eager to learn how it works, you are in the right place. Below is…
[Quick Guide] Master The COUNTIF Function In Excel!
You often need to work out your data statistically by checking on particular portions of your data set that meet specific criteria. The COUNTIF function is designed to help you with that. Want to learn how to use the COUNTIF…
How can I convert text into a table format in Word?
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…
3 Top AutoCAD Tips From A Lifelong AutoCAD User
Author Note: This is a guest post by Nick Marchek. Nick is a Building Information Modeling (BIM) Specialist at Microsol Resources, a platinum Autodesk partner. He has a bachelor’s and a master’s degree in architecture from Pennsylvania State University. He…
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…
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…
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…
The Rise Of The Chief Content Officer
In 2016, the prevalence of content marketing was found to have grown a significant amount in big businesses. 89% of B2B businesses are using content marketing to grow their companies. Having a clear, documented content strategy is crucial for companies…
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…