DIY Functions and Add-ins

The screenshot below is from a spreadsheet that is used to calculate the square footage (area) and perimeter of a rectangular or square shape, such as a garden or a room. The purpose of this (example) spreadsheet is to answer questions such as How much turf do we need...

Pivot Tables in Excel 2011 (Mac)

A Pivot Table is an interactive table that automatically extracts, organizes, and summarizes your data. You can use a Pivot Table to analyze the data, make comparisons, detect patterns and relationships, and discover trends. This short video is taken from a recording...

Understanding VLOOKUP and HLOOKUP

In this tutorial of almost 20 minutes, I show you: – Several practical examples of when and how to use the VLookup and HLookup functions – The differences between the 2 functions – The difference between TRUE and FALSE (4th Argument) The video was...