• countif true or false

EXCEL TUTORIAL- Test if Cell Contains Specific Value

[toc] In this tutorial you will learn how to test if a range contains a specific value. COUNTIF Function In [...]

  • result month auto

Insert Dates in Excel

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

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

Calculate a Running Total in Excel

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

Count if Cells in Range

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

  • mixed ref

Cell References

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

How to Disable Scroll Lock in Excel on PC

[toc] What is Scroll Lock? The Scroll Lock setting determines what happens when you use the Arrow Keys in Excel. [...]

  • pc users data analysis

How to Install the Data Analysis Toolpak

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

Sales Funnel Chart

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

  • remove column page breaks excel vba

Working with Page Breaks in Excel & VBA

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

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