#values

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

Tags

No tags yet.

AVERAGEIFS

AVERAGEIFS allows you to average a set of values that meet multiple criteria. It is useful when you need to make comparisons between differ

AVERAGEIF

Had to average a set of values that met a criteria and didn't know how? AVERAGEIF is a super easy formula to use and understand. I exp

SUMIFS

Learn how to ADD cells that meet multiple criteria using the SUMIFS formula.

COUNTIFS

Learn how to COUNT the number of cells that meet multiple criteria using the COUNTIFS formula.

All about pivot tables part 4: PivotChart

Pivot charts present data from a PivotTable visually. Learn the differences between a PivotChart and a standard chart and how to create them

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

COUNTIF

COUNTIF, in layman’s terms means COUNT the NUMBER of cells, IF it contains XYZ (text, number, etc). The key word here is criterion, referri

Identifying Duplicates

Read on to find out how to use conditional formatting to identify duplicates and save you time!