Excel shortcuts

30 Excel shortcuts to speed up your work

Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.

Excel DATEDIF function

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.

COUNTIF in Excel

Practical functions in Excel: COUNTIF explained

What is COUNTIF? With Excel, Microsoft provides a helpful spreadsheet program. The application combines numerous functions – most of which many users are unaware of. It therefore makes all the more sense to learn more about it and use the program for more than just creating tables. The COUNTIF function helps you create statistics, for example. We explain clearly how to use COUNTIF correctly in...

VLOOKUP in Excel

Faster with Excel: the VLOOKUP function explained

It can often be incredibly time-consuming to search for a specific entry in an Excel table by hand, which is where VLOOKUP comes into play. This practical function allows you to find the exact value for a specific search criterion. The VLOOKUP function is indispensable for managing price lists, members directories, and inventory catalogues. To ensure you can benefit from this practical function,...

Excel SUMPRODUCT function

Excel: What can you do with the SUMPRODUCT function?

Besides its clear tables and informative diagrams, Excel impresses in its ability to perform complex calculations automatically. Microsoft’s spreadsheet software offers many different tools to help you do just that. For example, you can use Excel’s SUMPRODUCT function to add and multiply values in a single step. We’ll explain how it works.

Creating an Excel table

Excel tables: How to perfectly format your data

Excel is a powerful tool for formatting, analyzing and presenting your data. Excel lets you create tables that perfectly organize 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.

How to calculate time in Excel

How to calculate time in Excel quickly and easily

You can use the SUM function to quickly add up several values. But if you want to calculate hours in Excel, you first have to adjust the format of the cells. The format has to be correct, otherwise you’ll encounter problems when you add up more than 24 hours. In that case, your total could be missing an entire day. We’ll teach you how to add hours in Excel and avoid common mistakes.

Excel WEEKNUM function

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 WORKDAY function

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 analyze working days separately. Using Excel’s WORKDAY function, you can calculate deadlines more precisely.

Excel: DATE function

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.

We’re all in this together. IONOS is
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.