Encyclopedia

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

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: 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: 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?

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

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