## Shortcuts

Return to Excel Shortcuts List zte Join the newsletter Subscribe to get our latest content by email. Success! Now check your Insert Dates in Excel This tutorial covers how to insert dates in Excel. The Date Format Like numbers, Cell References In order to make accurate calculations it’s essential to understand how the different types…

## EXCEL TUTORIAL- Test if Cell Contains Specific Value

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…

## Insert Dates in Excel

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…

## Calculate a Running Total in Excel

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…

## 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…

## Cell References

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…

## 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…