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