Jul 8, 2013
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...
May 10, 2013
In this video, a 10 minute clip taken from a webinar that I delivered in 2012, I build a spreadsheet that can be used by anyone planning a wedding. The video covers absolute cell references, SUMIF, COUNTIF and conditional formatting. I used Excel 2011 for Mac but...
Apr 12, 2013
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...
Mar 24, 2013
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...
Feb 28, 2013
Try this…Type a date into a cell using one of the formats the Excel recognises (such as 25-Dec-2013, 25/12/13 or 12/25/13). Now change the format of the cell to General and you should see the number 41633 in the cell. So what’s going on? What is the...
