PHP 8

PHP 8: What you need to know about the latest update

 

PHP is one of the most important languages on the Internet. Many content management systems like WordPress, TYPO3 or Joomla are based on PHP. The release of PHP 8 is imminent, but we’ve already had some information about its new features. Also some old features will be reworked,...

 

Create Alexa Skills

Program Alexa Skills easily by yourself

 

Alexa Skills extends the functionality of your Amazon Echo, Echo Dot, or any other smart speaker from the Echo series with additional abilities. You can activate extensions for the virtual voice assistant in the Alexa Skills Store for free. With the Alexa Skills Kit, Amazon also...

 

What do EU cookie laws mean for you?

EU cookie laws and how they affect your business

 

Cookies can be helpful business tools, but they often toe the data protection line dangerously. As a result of this tendency towards uncertainty, the EU has introduced a new cookie policy to protect its users. The new policy makes opt-in procedures compulsory, because the user...

 

Zoom alternative

Zoom alternatives: a comparison of the main competitors

 

Alternatives to the popular video conferencing software Zoom are having their moment in the spotlight as a growing number of people are organising video calls daily. Free alternatives to Zoom include a wide range of features, especially since the market for video conferencing...

 

What is a QR code?

What is a QR code?

 

What do stamps, tickets, and posters have in common in the 21st century? More than you might think: Many companies now use QR codes on printed items for a variety of purposes. They can be used to quickly read data and execute commands. How does a QR code work? Which QR code...

 

Best Video editing programs

The 7 best video editing programs of 2020: beginner, advanced, and professional

 

Professionals use video editing software to create amazing films. However, video editing is not just for professionals. The best video editing programs of 2020 manage a balancing act between suitability for amateurs and professionals. With the right video editing software, you...

 

Perfect out of office message: Examples and templates

How to create the perfect out of office message

 

The out of office message is a crucial part of email communication in the workplace. If you don’t have access to your email, your contacts will want to know when you’ll be back and whether or not you’ll be represented by someone else in your absence. An out of office reply may be...

 

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.

Excel's WORKDAY function explained

Many people use dates regularly in Microsoft Excel. However, the problem with dates is that they don’t automatically distinguish between working days and weekends. Excel does, however, provide a function that allows you to analyse working days separately. Using Excel’s WORKDAY function, you can calculate deadlines more precisely.

Excel: The MATCH Function Explained

To work with large data sets, long tables, and large arrays, Excel offers several features. These facilitate navigation through the mass of values and data. For instance, to quickly find the right cell, you can use MATCH in Excel. The function searches for a value and then specifies the position of the cell. How does it work?

The Excel: SUMIF function explained

Get more out of Excel: SUMIF makes it easier to work with balance sheets and analyses. Add only the values you need – completely automatically. From simple calculations to complex formulas, it’s all possible with the SUMIF function in Excel. How do you use the function? And what does the syntax look like?

Excel tables: How to perfectly format your data

Excel is a powerful tool for formatting, analysing and presenting your data. Excel lets you create tables that perfectly organise groups of data and provide useful features like sorting and filtering functions, for example. In this tutorial, you’ll learn how to create Excel tables and tailor them to your individual needs.

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's WEEKNUM: Deriving the week number from a date

In business, you often need to know the calendar week number. Excel’s WEEKNUM function ensures that you always have the correct week number right at your fingertips. The function even considers different counting methods, allowing it to adapt to international practices. WEEKNUM can also be combined with other functions.

Excel: working with dates

Many countries have their own unique way of displaying dates and times. To be able to switch seamlessly between date and time formats, the information must first be stored in a universal format. You can use the DATE function in Excel for this purpose. In this article, you’ll learn how to work with the Excel DATE formula.

Microsoft excel alternatives: 5 premium free-of-charge applications

For many companies, spreadsheets are a part of day-to-day business: whether to compare costs, create diagrams, or plan financing and revenue streams, most tend to gravitate towards Microsoft Excel for their calculations. But is there any way around having to pay for this expensive product? We’ll show you 5 of the best alternatives to Microsoft Excel.

Excel: The CONCATENATE function explained

Excel usually displays a single result in each cell. Because each cell contains only a single value, the contents can easily be transferred to other functions. However, sometimes you want to combine multiple elements. The Excel CONCATENATE function lets you combine text, numbers, and functions in a single cell.


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.