Tutorials

Enabling macros in Excel

Enabling Excel macros: How to activate these practical scripts

For over three decades, Microsoft has offered Excel, an excellent solution for creating simple spreadsheets and calculating complex formulas and functions. In addition to its vast functionality, another benefit of Excel spreadsheets is that you can create and use macros to automate any process or task. We’ll show you how to enable macros in Excel.

Showing Duplicates in Excel

Identifying Duplicates in Excel

There are several reasons why you may want to find duplicates in Excel – to filter out errors or analyse double entries. Excel can automatically display these duplicates to you. Thanks to colour highlighting, you can instantly see which entries appear more than once in your tables. And the feature is easy to use: We’ll explain how it works.

Raspberry Pi Plex server

Raspberry Pi and Plex: how to turn a single-board computer into a media server

Plex is among the most popular and user-friendly solutions for creating a media server in your home network. In contrast to many other applications, which are often Windows-only, the Plex server is compatible with Linux, Mac, and even single-board computers like the Raspberry Pi. In this Raspberry Pi and Plex tutorial, you will learn what technical requirements must be fulfilled and how...

Error 522: Explanation and solutions

Error 522 – 'Connection timed out': How to fix the error

52- HTTP error messages indicate a problem between the web server that is running a website and the Cloudflare CDN service. The 522 error is very common and is also known as the 'Cloudflare error'. It is displayed in the visitor’s browser whenever the mandatory TCP handshake fails. This guide explains the reason for this error message and what solutions there are for site operators and visitors....

Explainer Videos: The Best Tools

Create an explainer video: Comparing the best tools

Whether you want to clarify a problem, make a dull tutorial into something fun, or have your product reach millions of people, creative and funny videos are the way to go. But what exactly is an explainer video, and what should you bear in mind when making one yourself? Here we will show you which tools you can use to create explainer videos yourself.

SQL INNER JOIN

INNER JOIN: definition and application

The INNER JOIN is the most important JOIN type in the relational database model. If you want to query database tables in a group, you would usually use INNER JOINs based on equality relationships between primary and foreign keys. We will show you how to use INNER JOINs in practice, delineate the JOIN type from OUTER JOINs, and also deal with the different subtypes of INNER JOINs.

Outlook search function not working

What do you do when your Outlook search function is not working?

Microsoft Outlook is one of the most frequently used e-mail programs worldwide. It’s unsurprising then that there are a multitude of approaches to solving its everyday problems. Especially when it comes to e-mail traffic, it can be annoying when Outlook search suddenly stops working. Restarting the program or PC is often enough to solve problems with the Outlook search function. But what should...

Outlook distribution list

How to create and manage distribution lists in Outlook

Do you regularly send messages to specific groups of recipients? If so, you can make e-mailing easier by creating preconfigured distribution lists in Outlook. You can create contact groups and distribution lists in the online version as well as the desktop version of Microsoft Outlook. This illustrated step-by-step guide will show you how.

Add mailbox to Outlook

Adding a mailbox to Outlook: How to set up access to mailboxes in Outlook

Microsoft Outlook has a feature that allows you to manage mailboxes in one client. To do this, the manager of a mailbox only has to share it. These selected users can then add the mailbox to their Outlook account to help the mailbox owner process incoming and outgoing mail traffic. Depending on the access given, multiple users may have the power to do a lot of work via e-mail, lightening a...

Regular expression tutorial

Regular expressions (regex): The easy way to describe strings

Searching text and code for specific strings on your own can be extremely tedious, especially if your document is large. Since the beginning of the computer age, there have been useful tools or functions that feature regular expression capabilities, also known as regex, to automate this search process to the greatest extent possible.


Wait! We’ve got something for you!
Get your .co.uk domain for just £1/1st year.

Enter the web address of your choice in the search bar to check its availability.
12 months for £1
then £10/year