Outline- Microsoft Excel Class #3

Using functions, conditional formatting, and goal seek

1. Formatting Example - (UMC Theaters)
  1. Home Tab - Format Cells - color, alignment, fonts, numbers
  2. Formating contiguous cells; non-contiguous cells
  3. Copying a range of cells
2. Using more functions - MAX, MIN, MEDIAN, IF
  1. Formulas Tab - Logical
  2. Conditional formatting for changing font and formatting
  3. Logical function "IF" - example =IF (b1>100000,"Target","Too Low")
3. Create a Chart
  1. Insert Tab - Chart Group
  2. Type of Chart - Column, Bar, Pie, Line, etc.
4. Payment Function (PMT) - Truck Loan Example - (New Excel File)
  1. Formulas Tab - Financial
  2. Using the PMT Function
  3. PMT(rate,time,principal)
  4. Using the Fill Handle
  5. Data Tab - What if Analysis
  6. Goal Seek - to find a particular value (e.g. in contrast to PMT)