• countif true or false

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 [...]

  • result month auto

Insert Dates in Excel

This tutorial covers how to insert dates in Excel. The Date Format Like numbers, currency, time and others, [...]

  • sum function, total, sum, running count, addition

Calculate a Running Total in Excel

This tutorial will teach you how to set up and calculate a running total with Excel. To calculate [...]

Count if Cells in Range

This tutorial explains how to count the number of cells containing numbers that fall within a specified range [...]

  • mixed ref

Cell References

In order to make accurate calculations it’s essential to understand how the different types of cell references work. [...]

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 [...]

  • pc users data analysis

How to Install the Data Analysis Toolpak

This tutorial will demonstrate how to install the Data Analysis Toolpak add-in in Excel for both Mac and [...]

Sales Funnel Chart

What is a Sales Funnel Chart? Funnel charts are usually used to represent a process’s stages and their [...]

  • remove column page breaks excel vba

Working with Page Breaks in Excel & VBA

If you don’t manually set Page Breaks, Excel will do it’s best to set appropriate Page Breaks. However, [...]

  • calculate exact age in excel

How to Calculate Age in Excel

This tutorial covers how to calculate age in Excel. Calculate Exact Age To calculate the exact age of a person, [...]