Encyclopedia

Progressive web apps | what advantages do they offer?

Progressive web apps | what advantages do they offer?

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

Single sign-on

Single sign-on – one-time registration for everything, please!

Online activity could be so simple – just enter your access data once and automatically be logged in for all accounts and services on the web, instead of having to remember dozens of passwords. This is, in fact, a reality for many websites, and the process is called SSO – single sign-on – and is becoming ever more popular among private and professional users. But what are the benefits of SSO, and...

Creating a batch file

Creating a batch file: How to write your own .bat file

Windows operating systems can be controlled and configured in a wide variety of ways. To this day, experienced administrators use Command Prompt, the Windows command-line interpreter, for this purpose. If you want to have Windows automatically process a sequence of commands, you can create a batch file. This tutorial will show you how.

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.

Personas

Personas: How to get closer to your customer

Every company wants to work close to the customer, to focus on the user. However, many companies only use averages and statistics as a basis. This is not how to reach the individual buyer. Personas are different. They are based on real people and reflect the heterogeneity of the target group. What do you have to pay attention to?

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

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


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.