Section 3.3

• Plan for the next few weeks.
  • Finish chapter 3 today and Wednesday.
  • Chapter 4 is longer so there will three days of discussion and a work day. (Scheduled 11/12).
  • I will pick up something we missed from chapter 1 on 11/11.
  • Test test will be 11/18 and will cover excel chapters 1-4.
    • I would prepare a set of notes on
      • Functions we have used
        • avg, max, min
        • if, vlookup, pmt
        • sum, ....
      • Formulas we have used
        • Computation of down payment.
        • Computation of regular and overtime pay ...
  • I will discuss Excel chapter 5 11/14-11/21
  • We will do power point the last two weeks.
• Chart styles and colors.
  • Relatively straight forward.
  • Special Chart Tools - Design tab, chart Styles group.
• Filtering Data
  • Use the filter sign on the chart.
• Sparklines
  • Select a range.
  • Insert tab, Sparklines group.