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.
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...
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.
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 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?
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...
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!
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...
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.
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.