Art 569 - Class 09 - Using Excel
00:00 Introduction
00:55 A very brief history of spreadsheets
02:12 Worksheet: a grid of cells
02:52 Basic worksheet interface
03:56 Three kinds of cell contents
04:27 Simple math formulas - add, etc.
07:40 Basic text formulas
09:38 Basic cell formatting options
10:20 Cell borders
10:57 Text justifucation in cell: horiz & vert
12:40 Automatic fill options
13:42 Basic sorting procedure
15:13 Clearing text and formatting
17:08 Being careful with formulas
19:48 Other cool stuff
21:37 Class schedule - spreadheet with no math
23:43 Copy cell look with Format Painter
24:42 Create a construction budget worksheet
31:28 Decimal places, $ signs, commas, etc.
41:19 Check your formulas!
43:40 Create a simple construction schedule
53:57 Create a space allocation worksheet