Ben Richardson

Power Automate allows you to automatically send emails when certain things take place. Although not all emails can be automated, […]

We all have been through the unfortunate instances of power disruption and system crashes that do away with all our […]

There is often a need to execute certain actions or instructions repeatedly. This can be achieved by using loops in […]

Being assertive means being confident and self-assured while being respectful of others. It is a great trait. It means that […]

To inform how we teach our assertiveness training courses we carried out some research into how assertive and confident people […]

At various points in your career, you’ll find yourself having to have a difficult conversation with somebody. Sometimes at the […]

What does the word assertive mean to you? It will mean different things depending on your own personal behaviours, beliefs […]

While being assertive is seen as a strong trait in a line manager, there are other skills you’ll need to […]

Assertiveness is a brilliant trait to have as a manager. When you are being assertive, you are communicating your needs […]

In this tutorial, we will take you through the steps needed to create an Excel Dashboard. We will also review […]

Lets say you are signing up for a loan – it is crucial to know the real interest rate! Interest […]

Only a basic sense of the financial functions of Excel will help you get through most of your daily-life financial […]

In this tutorial, we will provide a comprehensive overview of Excel VBA Collections. You will frequently need to work with […]

In this tutorial, we will provide an introduction to VBA class modules. You can create your own custom objects by […]

In this post, we will review how to use the COUNTA Function in your VBA code. Excel allows you to […]

The FILTER function from the Dynamic Array Tools of Excel is the very long-awaited substitute for the conventional filtering functions […]

While Excel already had RAND and RANDBETWEEN functions, what was the need for another random number generating function? The RANDARRAY […]

  Few experiences enhance your professional expertise and strengthen your cultural awareness like living and working abroad. Learning how businesses […]

Most people using Excel, have used the very important MATCH function. However, with more features and flexibility, the XMATCH function […]

There are a number of functions to Excel that enable users to extract a list of distinct values. Ranging from […]

In this post, we are going to review the VBA Special Cells method in Excel. You can use the VBA […]

  Many people describe presenting and public speaking as their greatest fears.  Like most things in life presenting is a […]

SEQUENCE function is one of the most advanced and modern functions of Excel. It was introduced as a part of […]

In this article, we will look at how to create a Gantt chart in Microsoft Excel. Gantt charts assist with […]

To inform how we teach our Excel training courses and find out more about how people are using Microsoft Excel […]

The GROWTH function in Excel is one of the most powerful and is very underused! Excel GROWTH Function The Excel […]

Excel Advanced Filters are one of the main reasons why people prefer using Microsoft Excel for most of their work […]

Goals provide a sense of purpose, direction, motivation, and focus.  SMART goals add extra dimensions to the goal-setting process to […]

This tutorial will show you how to create a landscape scene which has depth to it. You can learn how […]

Frames and Shapes are used to create objects that appear in your InDesign document. Frames are designed to hold graphics […]

In this InDesign tutorial, we will cover create an interactive button that will take you to a URL when it […]

  Keyboard shortcuts make you to be a faster and more efficient computer user. When learning Microsoft applications mastering keyboard […]

This is part 4 of a four-part blog series on working with fonts in Adobe Creative Cloud. In this article […]

Even after the emanation of automated bookkeeping software and technologies, Excel is still widely used for accounting and bookkeeping purposes. […]

Anyone that studied maths knows how powerful logical functions can be. And if it wasn’t, then this guide is all […]

You can very simply bring character to your lists by using different bullet characters. Good clear design will make your […]

Before you start this tutorial, make sure you have the following as before: FontSelf Extension for either Adobe Illustrator or […]

There are so many settings in a document that you may want to access quickly. InDesign provides you with a […]

How technology and creativity brings better and more innovative opportunities for creatives. What most people fail to realize at first […]

The Patch Tool can help remove imperfections from an image. Whether its a painting or a photograph. You might just […]

In this Photoshop tutorial we’re going to give you a taste of the type of skill that you would pick […]

Photoshop can create countless artistic and attractive images. One such example is creating images partly in Black and White, and […]

In this Adobe Photoshop article, I will show you how to change you are one of your friends into a […]

The Pen Tool is very basic but a very important tool in Photoshop and InDesign. This tool will be used […]

Glyphs are the actual symbols you see when you press a key on the keyboard and it gets typed. Alternates, […]

Microsoft Excel provides quite a few built-in tools to assist with forecasting. Forecasting refers to the process of predicting a […]

This tutorial will show you how to create block 3D letters in Illustrator without using the 3D tool, our trainer […]

This tutorial is going to show you how to create a simple building using the perspective grid. Come on our […]

This Photoshop article will show you how to create a half woman half tiger picture using Layer masks. This technique […]

Initally the InDesign interface can be a little overwhelming. Navigating its menus to find the specific tool that you need […]

There are 3 different ways you can create a geometric low poly image. One of the ways can be very […]

Illustator is a great tool to create an edit images with. However sometimes you may want to have the drawings […]

This Adobe Photoshop tutorial will show you how to create a double exposure effect. These techniques are covered in detail […]

  Searching for a job can be difficult, similarly, working toward advancement in your organisation is also demanding. According to […]

Content Awareness in Adobe Photoshop has been around since the release of Photoshop CS5. Content-Aware Fill was created to enable […]

The Object Selection tool was first introduced in Photoshop CC 2020 (November 2019). It simplifies the way you can select […]

The tools in Photoshop CC 2020 provide a variety of ways to perform your edit work process. We cover the […]

The intelligent excel tool to structure, load, share and analyse data, Power Query, is one of the most powerful features […]

You often need to work out your data statistically by checking on particular portions of your data set that meet […]

Converting Text Into A Table format can help you better organise your data for people reading it. It also allows […]

Author Note: This is a guest post by Nick Marchek. Nick is a Building Information Modeling (BIM) Specialist at Microsol […]

Using Power BI Desktop themes, you can apply design changes to your entire report. This can include using corporate colours, […]

Taking minutes at a meeting can be difficult. Whether you are taking them either to distribute to team members, or […]

Need to neaten up your Word documents? Luckily for you, we know just the trick! Follow our guide below on […]

Normally when bringing two sets of data together in a relational database the intention is for data in the two […]

In 2016, the prevalence of content marketing was found to have grown a significant amount in big businesses. 89% of […]

Job Interviews can be a nerve-wracking experience. However as standard practice worldwide they aren’t going anywhere soon. Sometimes the only […]

Charts and graphs are efficient ways of data presentation that help users visualize data. They help a user to decode […]

Databases are commonly referred to as relational because they contain tables of data, some of which relates to data in […]

VBA stands for Visual Basic for Applications. It is an object-orientated, event driven programming language. The VBA language can sound […]

Data Analysis is the process of cleaning, collating, examining, and modelling data to deliver information and key insights. These insights […]

This is part of our new series showing you how to make the most of Office 365. If you think […]

There are two types of Office 365 users: The majority of Office 365 users continue to use Office applications as […]

If you are going to be out of the office for the day and you need to let others that […]

We recommend that all heavy users of PowerPoint learn the short cut keys. These speed up your work considerably as […]

In Outlook MailTips are turned on by default, this guide shows you how to disable them. For advanced Outlook users, […]

Mail Merge is linking together a document with a source of data which could be names and addresses.  Only one […]

When you group together talented, passionate people; differences of opinion are unavoidable. Capable, assertive people will express their opinions clearly, […]

This page simply hosts the images used in our blog post on creating textile print designs in Photoshop. The three […]

There may be times when you’ll need to switch the layout of your data set around. In situations like these […]

Occasionally you may find that it’s necessary to clean up your data and part of that cleaning up, may involve […]

The To do Bar is the panel on the right of the Outlook screen. By default, it is not turned […]

Conditional Formatting allows you to format a cell or group of cells based on a certain condition or conditions being […]

Even expert excel users can sometime face issues with structuring data using the copy and paste function in excel. This […]

We are all familiar with Tables from common applications such as Microsoft Word or Excel. Those of us who are […]

Creating a Contact Group allows you to email a specific group of people easily at any time. This guide will […]

Creating a simple macro in Excel is not a daunting task. Now it may seem contradictory, but you do not […]

If you frequently email your colleagues Excel files (and how doesn’t) this is a quick tip to speed things up […]

Seeking to extract a sample out of a diversified population? Or working on some stuff and looking for ways to […]

Removing a white background from an image in Adobe InDesign is a straightforward and important process. The same process can […]

How would your data look if it had clear written descriptions instead of general titles? It would be easier to […]

When I started using InDesign, I thought something was wrong. All my images were blurry and low-res. I couldn’t understand […]

What is this unknown and brilliant Microsoft PowerPoint view I hear you cry? It’s the PowerPoint Outline view, found in […]

Learning to present the data in your spreadsheets clearly is extremely important. Unclear and poorly laid out spreadsheets are much […]

Although some people use the space bar to format their documents, things rarely line up correctly. Whilst this may be […]

Columns are a great way to format your text in a unique way in Microsoft Word and an important part […]

When using Microsoft Word, there will be times you want to re-use a certain picture or text in different documents. […]

Although you can easily navigate through Word documents with your keyboard and mouse, if you’ve got pages and pages to […]

You may have slides in other presentations that you would like to use.  In PowerPoint, there is a tool called […]

When creating a PowerPoint presentation it can be tempting to just select print slides and get your hands on a […]

Adobe Illustrator is full of handy tools to make sophisticated and detailed art. Learning how and when to use them […]

Backup and Restore are critical concepts to understand when working with databases in SQL and SQL Server. Whether you are […]

Folders in Outlook are a great feature to help you organize your workflow. EMail services can often get messy with […]

For those of you who know how to create a Pivot Table, have you ever considered turning your list into […]

VLookup is used to look up information in a list and extract the data into another list. It can also […]

Font formatting makes your Excel Spreadsheet stand out. This is often an underappreciated part of making spreadsheets. But visual design […]

Learning about Relative, Absolute and Mixed Cell References is imperative to being a skilled Excel user. This will save you […]

In Excel, there are a few different methods to rename worksheets. This guide will take you through each of them, […]

Formulas and Functions are some of Excels most powerful tools. They allow the user to make complex and useful spreadsheets. […]

InDesign spell check works differently from the other spell checkers. InDesign is primarily a publishing tool.  InDesign assumes that by […]

There are four types of tables in MS SQL: Permanent:     Normal tables you create and save #Local Temporary:    […]

Page numbers help your reader and add a professional finish to your documents. InDesign makes numbering documents incredibly easy so […]

Master pages are a huge time saver in InDesign. They’re a great ‘one and done’ solution to make sure that […]

This is part 2 of a 4 part series. For the other parts see here: Part1, Part3, Part4. As before […]

Recently it was pointed out that we don’t have a full index of our white papers and that it would […]

10 TIPS FOR FIRST TIME MANAGERS If you are looking to bolster your ability to lead a team at work […]

[ssba] Adobe Creative Cloud is awesome. If you can imagine it you can create it. From photo editing and vector […]

How do some people ace their job interviews every time? Of course, some people are naturally better than others in […]

This page holds the files that can be downloaded if you want to follow along with our Photoshop tutorial “Creating […]

This article assumes a knowledge of the standard use of the Criteria row in a Microsoft Access Query and the […]

[ssba]   Here we are with part 3 of our assertive communication roundup. If you’ve not seen them here are […]

[ssba] Did you know that in a face to face meeting, 93% of communication is non-verbal?To break it down, body […]

Strong, respectful relationships are based on all parties communicating clearly and respectfully. Many people find this difficult. They don’t find […]

This Photoshop tutorial is going to show you how to create a text effect which makes it look like it […]

Before printing out or sending off a document you have created in Microsoft Word, it’s always a good idea to […]

This Photoshop tutorial will show you how to create an image with a displacement technique. You will see this commonly […]

Many people use MS Office every day but do not realise they are taking longer than needed to do common […]

First place the text cursor at the point where you wish to insert a column break. On the numeric keypad, […]

Here is a handy tip on how to temporarily activate the ‘Hand Tool’ instead of having to switch tools every […]

Whether you speak a different language and you want to be able to translate a word in a presentation or […]

Here is a list of just some of the key benefits to help you get started: 1. Save time and […]

Presenting your document so that it is very clear and easy for a reader to navigate is critical. Adding a […]