Excel: INDEX Function
Excel: INDEX – Data Search Made Easy
  • Online sales

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.

Excel: INDEX – Data Search Made Easy
The best browsers for Windows and Mac
The best browsers for Windows and Mac
  • Technical matters

Google Chrome, Mozilla Firefox, Apple Safari, Opera, or good old Microsoft Edge? The debate about which web browser is number one has been going on for years in online communities. But what is a browser exactly? And is there one that can trump the competition and be touted as the best browser?

The best browsers for Windows and Mac
What is a browser?
What is a browser?
  • Web development

Google Chrome, Mozilla Firefox, and other browsers are the gateway to the web: But what exactly is a browser, and how does it work? Usually free, browser software assembles codes, images, and other resources for us in such a way that we are able to surf websites and make purchases in online shops. In addition to the standard elements that every browser brings with it, additional features and...

What is a browser?
Excel: LOOKUP Function
Excel: How to use the LOOKUP function
  • Online sales

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.

Excel: How to use the LOOKUP function
DWH | What is a data warehouse?
Data warehouse systems: get success with big data analysis
  • Web analytics

More and more businesses are adopting dispositive data with the aim of making strategic decisions shaped by reports, prognoses, and patterns. The database is usually supplied by an information system that functions as a central data repository, separate from a data operating system. This is known as a data warehouse, or a DWH for short. A data warehouse is a modularly built system made up of...

Data warehouse systems: get success with big data analysis
Excel: TEXT function
Excel Text: using the TEXT function to convert numbers into individually formatted text
  • Online sales

The Excel TEXT function converts any number into a text string. The best part is that you can format the number as text in almost any way you like (e.g. as a decimal number, fraction, currency or by adding user-defined text before, between or after). Learn how to make the most of the Excel TEXT function using the format codes.

Excel Text: using the TEXT function to convert numbers into individually formatted text
How to protect your website from malware
Malware on the server: consequences and countermeasures
  • Technical matters

A website operator is responsible for the security of a web project as well as the content. Neglecting security may lead to hackers easily infiltrating the system through security gaps. If a malware-infected website goes unnoticed, it could cause serious damage. It is therefore important to make sure your site is fully protected.

Malware on the server: consequences and countermeasures
Creating an online store with WordPress
Creating an online store with WordPress and WooCommerce: This tutorial shows you how
  • CMS

In order to successfully sell products in the age of mobile internet and digital offers, having a well-functioning online store is a necessity. But how can you create your own online store without resorting to expensive help? With WordPress and WooCommerce, you can quickly and easily set up your own web store. We will show you how to do it with this step by step WooCommerce tutorial.

Creating an online store with WordPress and WooCommerce: This tutorial shows you how
What are system calls?
System calls: What are system calls and why are they necessary?
  • Know-how

The core component of operating systems like Windows or Linux, known as the kernel, is crucial to be able to use the underlying hardware effectively. For security reasons, this system core works on a higher layer than application programs can normally access. It is only with so-called system calls that processes from system-external software can temporarily access the kernel mode.

System calls: What are system calls and why are they necessary?
Graphic file formats: which formats are important?
Graphic file formats: the most important storage formats for images online
  • Web design

Whether you own an online store, run a corporate website, or write a blog, none of your web projects won’t be successful without photos or graphics. Images create visual stimuli that can enhance the content of your text and appeal to your visitors. However, it is crucial not only to find suitable graphical elements - but also to choose the appropriate graphic file format. The format needs to meet...

Graphic file formats: the most important storage formats for images online