COUNTIFSLearn how to COUNT the number of cells that meet multiple criteria using the COUNTIFS formula.
TimelinesWhat are timelines? How do you create one? I'll show you how to present dates in an interactive format.
With great control comes great responsibility - Slicers Part 2/2In this final part of this two-parter, I'm going to show you how to use one slicer to control more than one pivot table.
Slice & Dice - Slicers Part 1/2What are slicers? In this two-part series, I'm going to show you how to create slicers and how to use one slicer to control more than on
All about pivot tables part 4: PivotChartPivot charts present data from a PivotTable visually. Learn the differences between a PivotChart and a standard chart and how to create them
All about pivot tables part 2: SortingContinuing from part 1 of this 4 part series, in this post, I'm going to cover how to sort a pivot table, whether it's by numerical
Pivot pivot! - All about pivot tables part 1Learn how to construct a pivot table in this first part of a 4-part "All about pivot tables" series, starting off with learning ju
EDATE & EOMONTHLearn how to use EDATE and EOMONTH functions to add & subtract months from a starting date.
Adding 2 or more COUNTIF formulasDid you know that you can add the result of multiple COUNTIF formulas? COUNTIF is normally used on it’s own as several entries and then adde
