Tutorials

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

Analyzing 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 customizing 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 color – 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 of...

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 Pivot Tables

Pivot tables: using Excel to its fullest

Excel pivot tables can considerably ease the evaluation of data. Data analysis can be especially time-consuming and tedious with complex numerical series, but with Excel pivot, this doesn’t have to be the case. Simply place your data in the right context and filter the essential information in just a few clicks. The pivot table allows you to create expressive diagrams in no time. Find out all you...

Cross-site request forgery (CSRF)

CSRF: Cross-site request forgery attacks explained

Criminals are constantly trying to exploit Internet vulnerabilities and harm users. One common type of cyberattack is a cross-site request forgery attack, or CSRF. Hackers use these attacks to make purchases and transfer money on a user’s behalf without the victim noticing. How can these attacks be prevented?


Wait! We’ve got something for you!
Have a look at our great prices for different domain extensions.


Enter the web address of your choice in the search bar to check its availability.
.org
$1/1st year
then $20/year
.com
$1/1st year
then $15/year
.info
$1/1st year
then $20/year
.me
$1/1st year
then $20/year