## How to Use Dsum in Excel: Calculating Totals from Groups of Data

The Dsum function in Excel stands for “database sum” and is incredibly handy for calculating totals out of groups of data. To begin using it, the first step is to select the data and insert a table out of the data. Once you have the table set up, you can start using Dsum to find … Read more

## How To Use Workday Function in Excel

If you’re looking to find out the delivery date for a product, the Workday function in Microsoft Excel can be incredibly helpful. In this tutorial, we’ll cover everything you need to know about using this function. First, let’s take a look at the parameters involved in the Workday function. Essentially, this function returns the serial … Read more

## How to Use IF and VLOOKUP Together: Combining Logical Functions for Report Calculations

In this tutorial, we’re going to explore the powerful combination of IF and VLOOKUP functions to calculate sales commission rates. The basic premise of this worksheet is to report calculations for those that made their sales goal and column. We will also be looking at whether or not it’s an A, B, or C group … Read more

## How to Use LEFT Function in Excel?

If you frequently work with text data in Microsoft Excel, you may come across the need to extract characters from a cell or string starting from the left. This is where the LEFT function in Excel comes in handy. In this tutorial, we will show you how to use the LEFT function in Excel to … Read more

## How to Do Roots in Excel: A Step-by-Step Guide

Excel is a powerful tool and there are many things that it can do. One of the things that you can do in Excel is calculate the square root of a number. In this post, we will show you how you can do this using a simple Excel formula. We will look at two methods … Read more

## How to Subtract Months in Excel: A Step-by-Step Guide

Excel is a powerful tool for managing data and calculations, but sometimes it can be tricky to figure out how to perform certain functions. One common task is subtracting months from a date, which can be useful for things like calculating due dates or expiration dates. In this post, we’ll walk you through how to … Read more

## How to Use Right Function in Excel: A Comprehensive Guide

If you’re an Excel user, then you’re already familiar with the importance of functions in Excel. Functions are powerful tools that allow you to perform complex calculations and data analysis with ease. One such function is the right function, which is used to extract the rightmost character or characters from a text string. In this … Read more

## How to Round Down in Excel: A Step-by-Step Guide

If you’re an Excel user, you know how important it is to have a good grasp of the various functions available for calculations. Among these functions is ROUND DOWN, which rounds values down based on the given number of decimal places. In this tutorial, we’ll look at how to use this function effectively. To start, … Read more

## How to Use ISBLANK in Excel to Test for Empty Cells

In Excel, it can be useful to test whether a cell is empty or not in order to perform certain calculations. One way to do this is by using the ISBLANK function, which tests whether a cell reference or formula returns a blank. In this post, we’ll look at two different scenarios where ISBLANK can … Read more

## How Do You Force Recalculation In a Range of Cells Containing the Rand or Randbetween Function?

Microsoft Excel comes equipped with a multitude of functions that can help make your work easier and more efficient. One such function is the RAND function, which is used to generate random numbers. In this tutorial, we will take a look at how you can use the RAND function in Microsoft Excel. To get started, … Read more