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

Pull data from a second worksheet into a formula on another worksheet

back to top

Still using your downloaded workbook ...

We will demonstrate facility with functions and formatting of the resultant data

  1. On the 05-Summary worksheet,
    in cell B4 enter the words "Highest Number of Jewish Veterans."
    In cell K4, insert a function that will return the highest number of Jewish veterans from the data on the 06-VA-Religion worksheet.
  2. On the 05-Summary worksheet,
    in cell B5 enter the words "Lowest Expenditure on Medical Care."
    In cell K5 insert a function that will return the lowest expenditure on medical care from the data on the 07-State Level Expenditures worksheet.
  3. On the 05-Summary worksheet,
    in cell B6 enter the words "Number of programs at Idaho National Laboratory".
    In cell K6, display the number of programs for which the Idaho National Laboratory is the source.
    Find the data on the 08-Inventory worksheet.
    Use your help tool to find the right function.

back to top

Still using your downloaded workbook ...

We will demonstrate facility with formulas, by pulling vectored data from two different worksheets into a new formula

  1. Copy cells A4 through A54 from the 09-USA-OASDI worksheet.
    Paste these cells into cells B7 through B57 on the Summary worksheet.
    Then, in cell D7, insert a formula that will draw values from two other worksheets.
    The formula should divide Alabama's "65 or older" from the 09-USA-OASDI worksheet by Alabama's "Total Living Korean War Veterans as of September 30, 2017" from the 10-KoreanWar_State worksheet.

Then we will demonstrate cell formatting skills based on the type of data the cells contain

  1. Once you have created the formula,
    format the cell to display percentages to two decimal places.

We will conclude by demonstrating understanding of how and why to drag formatting information from one cell to another

  1. Once you have formatted the data in the cell,
    drag the cell down the column to apply the same formula and formatting for all state rows

back to top