Tutorials

Format USB Stick on Mac

Formatting flash drives on Macs: How it works

For USB sticks to work as storage media, they need to have their own file system. Without this, it can be added manually by formatting the flash drive. Mac users have a tool available for this with the “Disk Utility” program. Read this tutorial article to find out what the individual steps are and which file systems are available to use.

Elasticsearch

Elasticsearch: the flexible search engine

If you work with large amounts of data, you’ll need a powerful search engine. Elasticsearch offers you a full-text search that you can configure so that it is perfectly tailored to your needs. But first you have to understand the principle behind it – what is Elasticsearch?. In this Elasticsearch tutorial we’ll explain the first steps in using the search engine, from installation to creating a...

Excel: INDEX Function

Excel: INDEX – Data Search Made Easy

Analysing huge quantities of data can be a frustrating task. However, Microsoft’s spreadsheet program offers a range of functions that make preparing worksheets easier and more efficient. For instance, the INDEX function in Excel enables you to replicate specific cell content. This can be very useful particularly in combination with other formulas.

SUMIF in Excel

The Excel: SUMIF function explained

Get more out of Excel: SUMIF makes it easier to work with balance sheets and analyses. Add only the values you need – completely automatically. From simple calculations to complex formulas, it’s all possible with the SUMIF function in Excel. How do you use the function? And what does the syntax look like?

Excel: ROUND Function

Excel: How to Round Properly

Excel allows you to perform complex computations. However, you may often want to simplify the results, either by rounding up or down. In Excel, you can round using a function, saving time and effort. You can use the ROUND function directly and in its simple form, or build it into complex formulas. So, how do you use it correctly?

Word Styles: Creating and Modifying Styles in Word

Using, creating and customising Word styles

It’s often very time consuming to format each and every heading of a document individually, especially for lengthy, complex documents. Font, font size, font colour – these features, among others, must be consistent within a document to achieve a uniform layout. Word styles allow you to easily format and edit a text, making significant and otherwise tedious adjustments to features such as a table...

How to mail merge

Send bulk messages with Word’s mail merge feature

You often need to send the same content to multiple people, whether it’s a party invitation or a business invoice. If you don’t want to change the addresses manually every time, you can use the mail merge feature in Word. You simply insert placeholders instead of addresses into your document and let the program do the rest – easy!

How to save as PDF

Word documents: how to save as a PDF file

If you want to send a Word document or prepare it for printing, it’s recommended you know how to save it as a PDF file. This way, you can be sure that the formatting of your document won’t change and that others will not be able to edit it without permission. For simple conversion tasks, the save function in Word is often sufficient. However, there are some dedicated tools which offer a wider...

GraphQL

GraphQL: flexible query language and runtime environment for your web API

Applications on the web need interfaces in order to exchange data. If you run a web project yourself and want to grant other programs access to certain data sets, an API (application programming interface) like this is essential. Established concepts such as REST or SOAP are often used in development – but there are alternatives, as GraphQL proves.

Excel formulas

An overview of Excel formulas and functions

There are many Excel functions and formulas that are useful for a wide range of tasks. They can help you make your workflows easier and more efficient. We’ll introduce you to the most important ones here, and you’ll be on your way to being an Excel expert.


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