Excel

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.

Histogram in Excel

Make a histogram with Excel

A histogram represents the frequency of measured data, making this chart an important tool for statistics. With a bar chart, it’s easy to read which areas are high-frequency and which ones aren’t. There’s no need use extra software to create a pictorial representation like this, because a histogram can be made using Excel.

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.

Excel flowchart

Creating a flowchart in Excel is quick and easy

Flowcharts in Excel allow you to visualize complex processes with simple icons and arrows. Whether you’re working on a complex computer program (and want to understand the algorithm) or you’re trying to improve your team’s workflow, Excel gives you everything you need to create visually appealing flowcharts.

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.


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.
.org
$1/1st year
then $20/year
.com
$1/1st year
then $15/year
.info
$1/1st year
then $20/year
.me
$1/1st year
then $20/year