Tutorials

Excel: LOOKUP Function

Excel: How to use the LOOKUP function

Do you have a huge table where you can no longer keep track of all the entries? In Excel, you can use LOOKUP to quickly find related values. For instance, the function can serve as a mini search engine within your spreadsheet. Enter a search term and Excel will seek out the associated value for you. Here, we’ll show you what the syntax of the function looks like.

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.

Learning HTML: a beginner’s tutorial

Learn HTML: the first steps with the standard web language

In times of content management systems and website construction kits, you might think it’s a waste of time learning HTML. But if a page doesn’t work for some reason or if you plan to install dynamic elements, you won’t be able to continue without having knowledge of this web language. In our detailed HTML tutorial, we introduce you to the basic features of the markup language, including numerous...

Excel: SUM Function

Excel: Calculate the Sum of a Group of Numbers

The Microsoft Excel program is a convenient and easy way to collect and archive data. In addition, mathematical formulas can be solved using the software. For example, you can use the Excel SUM function to add the values of specific cells or entire ranges of cells without having to use a calculator.

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.

Windows blue screen

Windows blue screen (BSOD): How to cure the error

The infamous blue screen of death usually shows up without any warning. It’s an important indicator of internal problems with hardware, software, or drivers. If Windows can no longer be run as a result of such a problem, then the forced shutdown takes place in the form of a blue screen containing an error message. This may cause unsaved files and documents to be lost. The most important thing with...

CPU Temperature

The CPU temperature: How high can it get and how can you monitor it?

The CPU temperature primarily depends on the processes that are running, though factors such as ambient temperature also play an important role. Since fluctuations are quite normal, only sustained overheating needs to be prevented. There are different tools with which you can display the CPU temperature in order to be sure that it stays within the normal range and that your computer operates...

How to Overclock CPU

How to overclock your CPU: fine-tuning for your processor

CPU-intensive programs or games are an endurance test for the central processor of any computing device. Older models are quickly overloaded by processing power requirements. If you overclock your CPU, you can considerably increase the performance, eliminating the need for a new computer. We explain to you step-by-step what needs to be taken into account when you do this.

Breadcrumb navigation: Explanations and Examples

Breadcrumb navigation: What are the advantages?

Breadcrumb navigation helps visitors on your site to better navigate its structure, using selected filters or parent categories. It makes it easier for users to go back one or more steps. In this article, we explain what breadcrumb navigation is, why it is important for a good user experience, and how to implement breadcrumbs ideally in your website.

Progressive web apps | what advantages do they offer?

Progressive web apps: what do progressive apps promise to do?

The app market has already produced several new and progressive app formats; conventional native apps were followed by the development of web apps and hybrid apps. But then what is a progressive web app (PWA)? Fundamentally, they are based on the concept of a web app that then takes the form of an app. But PWAs manage to go one step further, promising users the optimized use of a mobile device’s...


We’re all in this together. IONOS is
#HereForYou
For your business. When times are tough. When it matters most.
Keep your business going or start one with your own online store.
3 months free
Online Store
Get started in the world of eCommerce free for 3 months.