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.

Google Sheets vs. Excel

Google Sheets vs. Excel

Microsoft Excel and Google spreadsheet programs differ primarily in how they work. While the more conventional Excel is used locally, Google Sheets is used online. Both have their advantages. In this guide, we will compare Microsoft Excel and Google Sheets and show you what you can expect from these spreadsheet programs.

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.

Excel CONCATENATE function

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.

Excel: ROUNDDOWN function

Excel: ROUNDDOWN – an explanation of this handy function

When performing complex calculations in tables, you can quickly produce values that are not fit for everyday use because they have far too many decimal places. The ROUNDDOWN function in Excel can help with this. It uses a simple formula to simplify your workflow. You can use it to round down any number to the desired number of decimal places.


Excel ROUNDUP function: How to use it correctly

The Excel ROUNDUP function for figures is one of the basic functions of many commercial, scientific and financial applications. It is used to make calculation results easier to read where they have numerous decimal places. If you want to automatically round up your results, you can use the Excel ROUNDUP function.

Wait! We’ve got something for you!
Have a look at our great prices for different domain extensions.

Enter the web address of your choice in the search bar to check its availability.
$1/1st year
then $15/year
$1/1st year
then $15/year
$1.60/1st year
then $20/year
$1/1st year
then $25/year