EXCEL TUTORIAL- Test if Cell Contains Specific Value

countif true or false

In this tutorial you will learn how to test if a range contains a specific value. COUNTIF Function In Excel, the COUNTIF function is used to determine if a value exists in a range of cells. The general formula for the COUNTIF is as follows: =COUNTIF(range, criteria) Range is the group of cells that you…

Read More

Insert Dates in Excel

result month auto

This tutorial covers how to insert dates in Excel. The Date Format Like numbers, currency, time and others, the date is a quintessential number format in Excel. Though Excel tries its best to auto-recognize data types, it doesn’t always succeed. To manually apply the date format to a cell or group of cells, select the…

Read More

Calculate a Running Total in Excel

sum function, total, sum, running count, addition

This tutorial will teach you how to set up and calculate a running total with Excel. To calculate a running total, you’ll need to use the SUM function with a combination of absolute and relative references. Mixed references will allow you to create a growing total that is anchored to the initial value. Let’s start…

Read More

Count if Cells in Range

This tutorial explains how to count the number of cells containing numbers that fall within a specified range using the COUNTIFS function. COUNTIFS COUNTIFS(range_1,criteria _1,[ range_2,criteria _2],…) range_1 (required): group of cells to count criteria_1 (required): conditions used to count range_2,criteria_2: optional ranges and criteria than can be evaluated. Up to 127 range and criteria…

Read More

Cell References

mixed ref

In order to make accurate calculations it’s essential to understand how the different types of cell references work. A1 vs. R1C1 References Excel worksheets contain many cells and (by default) each cell is identified by its column letter followed by its row number. This is known as A1-style referencing. Examples: A1, B4, C6 Optionally, you…

Read More

How to Disable Scroll Lock in Excel on PC

What is Scroll Lock? The Scroll Lock setting determines what happens when you use the Arrow Keys in Excel. When Scroll Lock is off (the default setting), the Arrow Keys allow you to navigate and select different cells within a worksheet. When Scroll Lock is enabled, the Arrow Keys will instead “scroll” through the active…

Read More

How to Install the Data Analysis Toolpak

pc users data analysis

This tutorial will demonstrate how to install the Data Analysis Toolpak add-in in Excel for both Mac and PC. For PC Users: Click on the File tab on the top left, then select Options.        Click Add-ins. Where it says Manage at the bottom, select Excel Add-ins from the drop-down menu and click…

Read More

Sales Funnel Chart

What is a Sales Funnel Chart? Funnel charts are usually used to represent a process’s stages and their outputs. A Sales Funnel Chart does this with sales. Like the name entails, the chart looks like a funnel made up of stacked bars, as shown below. Other Funnel Charts There are many other uses for Funnel…

Read More

Working with Page Breaks in Excel & VBA

remove column page breaks excel vba

If you don’t manually set Page Breaks, Excel will do it’s best to set appropriate Page Breaks. However, if you’ve ever tried to print an Excel spreadsheet, you know it generally does not do a good job. Any time you print a spreadsheet you should review and edit the Page Breaks before printing. Page Break…

Read More