Content Awareness in Adobe Photoshop has been around since the release of Photoshop CS5. Content-Aware Fill was created to enable you to remove distracting areas or objects from photos. It allows you to select an area, and Photoshop will select…
The Object Selection tool was first introduced in Photoshop CC 2020 (November 2019). It simplifies the way you can select an object or even part of an object in an image. Photoshop already has a Subject Selection tool, but it…
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…
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 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…
This is a guest post by Nick Marchek, a lifelong AutoCAD user. Check out his credentials here! Over my years I have worked as a drafter and designer for many architecture businesses. I have also been an AutoCAD consultant…
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…
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…
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…
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…
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…
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.…
