Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 19 Jan intro and clients | lecture | labs
  2. 26 Jan servers and command line | lecture | labs
  3. 02 Feb networks and protocols | lecture | labs
Web Development | sessions 04-08

  1. 09 Feb structural layer | lecture | labs
  2. 16 Feb presentational layer | lecture | labs
  3. 23 Feb using a structure | lecture | labs
  4. 02 Mar behavioral layer | lecture | labs
  5. 09 Mar design thoughts | lecture | labs
Dealing with Markup | sessions 09-10
  1. 16 Mar control objects and display | lecture | labs
  2. 23 Mar tools that read markup | lecture | labs
Working with data | sessions 11-14
  1. 30 Mar formulas, functions, vectors | lecture | labs
  2. 06 Apr data display | lecture | labs
  3. 13 Apr manipulate data sets | lecture | labs
  4. 20 Apr relational data bases | lecture | labs
Presentations | sessions 15-16
  1. 27 Apr designing a presentation | lecture | labs
  2. 04 May delivering a presentation | lecture | labs

Get some experience is setting up a worksheet.

back to top

Set up your workbook by creating two new worksheets

Download this workbook and use it for all your spreadsheet tasks.

[enable content in worksheet with cells linked to other worksheets]

You will note this warning atop the first worksheet
Do not enable content. The worksheet has cells linked to other worksheets you don't have access to.

  1. Insert a new worksheet, place it fifth in the sequence of worksheets, and name it 05-Summary.

back to top

Format a worksheet to make it display better

  1. On the 01-Format worksheet,
    format row 2 to display as
    alignment: vertical, center;
    text: Courier New font, 16 pt, Bold.
  2. On the 01-Format worksheet,
    format row 1 with white font, blue fill, but only for those cells that have data below them.
    Do not format the row out to the end of all possible cells in the row. For example on the specifications sheet, only columns A through G have data below them, so row 1 is formatted with a fill only over columns A through G)
  3. On the 01-Format worksheet,
    format cells A25648 through G25648 (North Carolina) with a custom fill [Red: 255; Green: 204; Blue: 0;]
    format cells cells A25649 through G25649 with an orange color;
    and format the cells in the row that shows your home county name in column G with a green color (if you are from Bexar County, TX, your row is 38154. If you are not from a county in the USA, use Bexar County for this purpose).
  4. On the 01-Format worksheet,
    format the header row so that there is a visible color difference between the header descriptors in the seven columns of data.
    Look at every other worksheets in the downloaded task04.datasets.xlsx workbook for examples
  5. On the 01-Format worksheet,
    freeze the appropriate cell so that the header rows always appear and the Summary Level column always appears
  6. On the 01-Format worksheet,
    validate the data in column C so that new data added to this column cannot be less than 100

back to top