Encyclopedia

Excel if-then statements

Excel if-then: how the IF function works

Excel’s if-then statement is one of its most helpful formulas. In many situations, you can create a logical comparison: if A is true, then B, otherwise C. To use this useful if-then formula in Excel, you first need to understand how it works and precisely how to use it. For example, which syntax rules does the IF function follow, and how can you extend the formula?

Freezing Excel Rows

Freezing Rows and Columns in Excel: A Guide

The bigger an Excel table is, the harder it is to maintain an overview. The problem is that cells like the header bar become hidden without the use of special formatting. The following article shows you how to freeze certain Excel columns and rows so they stay visible when scrolling.

What is conversion rate optimization?

What is Conversion Rate Optimization (CRO)?

Successful SEO measures help land you a spot in the top ranking positions of the search engine results pages (SERPS) and increase the influx of visitors to your site. But what happens when only a few visitors are actually buying your products or subscribing to your newsletters? Despite good traffic, the web project still isn’t as successful as it could be. The practical and effective solution to...

YouTube Sponsorship

YouTube sponsorship: support at the touch of a button

If you want to start a YouTube channel or expand your channel, you should think about monetising it. Recently, YouTube made sponsorship possible: Until now, YouTubers mostly financed themselves through advertising or external donation platforms. Now viewers can directly sponsor a YouTuber via their YouTube page – by means of the “join” button. We explain what this is all about.

ASCII-Codes | Overview of all characters on the ASCII table

ASCII - American Standard Code for Information Interchange

Every day we work with text on PCs, smartphones, tablets and other computer equipment using our keyboards. We expect letters, numbers, and characters to appear on the monitor before us. The fact is that there is a decades-old coding system behind this everyday function. Since the 1960s, ASCII has determined how computers interpret our input. We have prepared a practical ASCII table to help you...

Create a ZIP file

Create a ZIP File: compress your files

Send multiple images and videos via email, archive large amounts of data without using too much space, or encrypt confidential documents - you can do all of this by zipping files. We show you how to create a compressed ZIP file in Windows as well as macOS in our step-by-step guide. We also show you how to protect your files with a password if needed. This way, you can manage your storage space...

Binary code

Binary code: what do you use the binary system for?

Computers use binary code which is made up of all “ones and zeroes”. But why? Why don’t PCs and smartphones work in the decimal system that we are all used to? The answer can be found in the technology as well as in the sheer elegance of the binary system. It is a lot simpler than many people think. Can you perform calculations with binary code too?

What is a domain?

The domain basics

What is a domain? Despite this word being mentioned so frequently, it’s often unclear what the functions and structures of domains are. Knowing the hierarchical structure of the Domain Name System (DNS) is fundamental for anyone working in IT or in any online industry. We explain the difference between top-level, second-level, and third-level domains, and how you can benefit from subdomains that...

Kodi alternatives

5 alternatives to Kodi for a great home cinema

Kodi is one of the most popular media centers. But not everyone needs the abundance of extensions that it inevitably forces its users to learn. Alternatives to Kodi can fully meet the demands of a modern home cinema while also being easier to operate. Whether you want to screen films or listen to music: Good alternatives to Kodi allow you to organisze your library on your own, link up your...

Scrum

Scrum: modern and flexible agile project management

What exactly is the Scrum framework? If you deal with agile project management, you can’t ignore Scrum. Originally used in software development, Scrum has also found a home in many other industries. Fans of the model rave about greater efficiency and transparency, and praise the framework’s open approach. Are you also considering establishing Scrum teams in your company? We explain the most...


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.