Collaboration tools: a comparison of the best solutions

Collaboration tools: the best apps for better productivity

 

The bigger your business, the more difficult it is to manage all the different teams and projects. It’s especially difficult if not all employees are located in the same place – this is when planning resources and communicating quickly becomes a gigantic task. Collaboration...

 

Joy of Missing Out

JOMO: The mindful countertrend to FOMO

 

JOMO (joy of missing out) is the antithesis of FOMO (fear of missing out). Younger people especially are discovering the joy of missing out for themselves. They’re enjoying the moment, instead of chasing after trendy events and comparing themselves to others on social media. JOMO...

 

Video conferencing

Video conferencing: How to make virtual meetings a success

 

Flexible working models are hard to imagine without video conferencing. Employees from different locations can meet easily for personal exchanges on a digital platform. But which software is recommended for optimal video conferencing? How can you make video conferencing more...

 

Skype alternatives

The best alternatives to Skype: 13 free applications for video calls

 

For millions of people around the world, video chats and conferences are an essential part of daily life – for both work and leisure. When it comes to video telephony software and applications, Skype is by far the leader of the pack. In fact, many people are unaware that there’s...

 

Promote your website

Promoting your website: crash course for beginners

 

There are well over one billion websites worldwide. If you’re a newcomer and want to improve your online presence, you need a well-thought-out strategy and a lot of patience. But solid online marketing efforts can give a website the desired reach. From SEM, to display, to mobile:...

 

The best TeamViewer alternatives

Alternatives to TeamViewer

 

You don’t always have to use the market leader – this also applies to remote access. TeamViewer is still the most widely-used solution for remote management and online meetings, but there are numerous alternatives on the market which can be considered. We present some serious...

 

How to identify phishing e-mails and protect your data

Identifying phishing e-mails: the telltale signs at a glance

 

Scammers send out dubious e-mails attempting to obtain sensitive data from internet users every day. This is known as phishing and isn’t just annoying; fraudulent e-mails cost millions each year as internet users fall victim to them. We reveal how to identify phishing e-mails and...

 

Punycode

Since the introduction of internationalised domain names in 2003, Punycode has been ubiquitous on the internet. Internet addresses like look peculiar, but fulfil an important function: They encode non-ASCII characters into ASCII-compatible character strings and therefore ensure a smooth flow in the network. How does this work, and why is Punycode criticised so often? We’ll tell you.

An introduction to CouchDB

The creation and continued development of web applications require numerous data sets. How exactly these data sets are stored in databases is crucial for the user. The CouchDB database management system stores data in a way that is schema-free and document-oriented. Non-structured or half-structured data can be virtually filtered and structured without any issues.

Transposing in Excel – How it Works!

Realigning a table can be a marathon task. Copying or re-typing each cell individually – that takes time. Thankfully, areas can be transposed in Excel. This way, you can convert rows into columns and columns into rows, almost like turning the table on its side. Excel offers a function to do this with paste and even its own array formula.

Excel: Deleting Blank Rows – Made Easy!

If you regularly work with tables, you often encounter rows without content when reworking and restructuring them. Removing each of these rows by hand is often very tedious. However, Excel can find these blanks automatically. There are even several ways to delete blank rows in Excel. We will introduce two of them in the following.

Excel: The DATEDIF function explained

Microsoft Excel has many functions that help you produce calculations, statistics, and tables. Some of these functions do not even make it into the official list in the software. DATEDIF is one of those hidden functions that can help you calculate periods of time. The result can be shown in days, months or years. We’ll explain how it works.

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.


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.