Open Source

How to change DNS server

How to change DNS server: Reconfiguring DNS entries

It can make sense to change DNS servers (typically that of the internet provider) for a number of reasons: One example is that it can enable faster access times on the World Wide Web. In this guide, you’ll find out why this is the case and how you can change DNS server on Windows 10, macOS, and other operating systems.

Excel: INDIRECT Function

Excel: The INDIRECT Function Explained

In Excel, we almost always work with cell references. Rather than entering values into formulas individually, we pull them from the cells of tables. The INDIRECT Excel function enables you to even obtain references from other cells. This can be helpful when working with multiple worksheets or when creating complex formulas, for example. We explain how to use INDIRECT in Excel.

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

The best Microsoft PowerPoint alternatives

Free alternatives to Microsoft PowerPoint

It doesn’t matter whether you’re in school, at university, or in an important workplace meeting: a professional presentation can support any point you are making and help give the speaker a clear background to visualize ideas, plans, and perspective. When it comes to the software for this presentation there’s one household name that stands out: Microsoft PowerPoint. But there are numerous free...

Microsoft Visio alternatives

Microsoft Visio: Free alternatives for creating diagrams and flow charts

Visio allows you to create industry-standard professional diagrams, which can be seamlessly integrated into Microsoft Office documents. Thanks to a variety of graphic elements, complex information can be visualised efficiently and smoothly. But this visualisation software is quite expensive, so luckily there is no shortage of free Microsoft Visio alternatives.

Microsoft Office alternatives

Six free alternatives to Microsoft Office

Microsoft Office is the most widely used Office package and, without a doubt, will remain to be for professional purposes. For users who often exchange documents with others, its compatibility gives it an unbeatable advantage. The biggest disadvantage, however, is the high cost of using Microsoft Office. Microsoft Office alternatives are usually more cost-effective, especially when the software is...

Excel: Transpose

Transposing in Excel – How it Works!

Realigning a table can be a marathon task. Copying or re-typing each cell individually – that takes time. Thankfully, areas can be transposed in Excel. This way, you can convert rows into columns and columns into rows, almost like turning the table on its side. Excel offers a function to do this with paste and even its own array formula.

Free Microsoft Excel alternatives

Microsoft excel alternatives: 5 premium free-of-charge applications

For many companies, spreadsheets are a part of day-to-day business: whether to compare costs, create diagrams, or plan financing and revenue streams, most tend to gravitate towards Microsoft Excel for their calculations. But is there any way around having to pay for this expensive product? We’ll show you 5 of the best alternatives to Microsoft Excel.

Removing Excel Duplicates

Deleting Duplicates in Excel: How it Works

The Microsoft program Excel makes storing and processing data a piece of cake. But the more entries are added to a table, the greater the chance that some values are duplicated in the process. Excel offers a function for removing duplicates to solve this problem with ease. This allows you to delete redundant double entries with just a few clicks.


We’re all in this together. At IONOS we are
#hereforyou
Coronavirus is a challenge we need to face together.
We've created special offers on key products to help
your business keep going.
3 months free
Online Shop
Be where your customers are with your own online store.