Timelines in Excel – 16 Sep 2016
This demonstration covers using Excel to make a Timeline- a series of blocks designating how long activities take.
You can watch the recording (3:56 in length)
or download the recording to your computer via the link:
Excel Timeline download timeline video (.mp4 format, 44.2 MB)
Excel plus Word + Outlook mailout. 18th May 2016
This demonstration covers using Excel as a data source to compose a message in Word that is sent out in an email in Outlook (this demonstration uses Office 2013, but the principles are the same for other versions).
You can watch the recording (2:51 in length)
or download the video file
Double Axis Graph in Excel – 1st April 2016
This demonstration covers making a single axis graph into a two axis graph to solve the problem of trying to see a set of small numbers and a set of big numbers on the same graph.
You can watch the recording (3:43 in length)
or download the recording to your computer via the link:
Double Axis Excel Graph video download (.m4v format, 6.2 MB)
and download a copy of the example spreadsheet
Excel data Download (xlsx format)
Vlookup – 21st March 2016
This demonstration covers the two ways the VLOOKUP function is used in Excel, to match numbers into ranges, and to match exact values to combine data from different sources.
You can watch the recording:
or download the recording to your computer via the link:
vlookup movie download (16 MB, m4v movie file)
and download the example spreadsheet with finished formula
