June - 2017

Note: screenshots and examples were taken using Microsoft Excel 2013, however older versions can be used.

Tags

No tags yet.

Stop Moving! - Absolute Cell Reference

Copied a formula to another cell and noticed the result is not the same as the cell that you just copied? Read on to see how $ signs can pre

SUM VS COUNT

What's the difference between the two? Read on to learn when to use SUM and COUNT.

How to remove table functionality

Created a table and then later decided that you no longer want the “table functionality”? Learn how to remove a table's functionality at

SUMIF

SUMIF is used to “sum the values in a range that meet a criteria that you specify” - Microsoft Support Office 2017. It refers to only one c