Thursday, March 11th, 2010

An introductory video (youtube) by bytebodger describing the use and creation of pivot tables in Excel 2007.

Here is a video from freetutorials (youtube) on using Excel to manage simple databases.

The REPT function repeats text a given number of times. For example, =REPT(”*”,10) repeats * 10 times in a cell.
You can use this function to create a simple bar for values in multiple cells.  Here is a short video on YouTube: