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

  • countifs-in-action

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

  • customize-bar-menu

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

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

Show Buttons
Share On Facebook
Share On Twitter
Share On Linkedin
Share On Stumbleupon
Contact us
Hide Buttons