• CLOSED
    May 27 12:00am
    Closed more »
  • CLOSED
    May 28 12:00am
    The competition lap pool for lap swim is closed. more »
  • CLOSED - Memorial Day
    May 29 12:00am
    Closed more »
  • Competition Pool
    May 30 5:30am
    Lap Swim more »
  • Instructional Pool
    May 30 7:00am
    Lap Swim  more »
Saturday, May 27, 2017
    IU Calendar




    • CLOSED
      May 27 12:00am
      Closed more »
    • CLOSED
      May 28 12:00am
      The competition lap pool for lap swim is closed. more »
    • CLOSED - Memorial Day
      May 29 12:00am
      Closed more »
    • Competition Pool
      May 30 5:30am
      Lap Swim more »
    • Instructional Pool
      May 30 7:00am
      Lap Swim  more »
    Saturday, May 27, 2017
      IU Calendar




      • CLOSED
        May 27 12:00am
        Closed more »
      • CLOSED
        May 28 12:00am
        The competition lap pool for lap swim is closed. more »
      • CLOSED - Memorial Day
        May 29 12:00am
        Closed more »
      • Competition Pool
        May 30 5:30am
        Lap Swim more »
      • Instructional Pool
        May 30 7:00am
        Lap Swim  more »
      Saturday, May 27, 2017
        IU Calendar




        • CLOSED
          May 27 12:00am
          Closed more »
        • CLOSED
          May 28 12:00am
          The competition lap pool for lap swim is closed. more »
        • CLOSED - Memorial Day
          May 29 12:00am
          Closed more »
        • Competition Pool
          May 30 5:30am
          Lap Swim more »
        • Instructional Pool
          May 30 7:00am
          Lap Swim  more »
        Saturday, May 27, 2017

          About This Event

          Summary

          This workshop lasts 90 minutes, and is part of the certificate series Excel 2010 Advanced End-User

          This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using one- and two-input data tables and Goal Seek. Participants will use the Scenario Manager, which makes automating what-if models easy by storing and comparing named scenarios. Summary reports will be generated to see the effects of these various combinations of input values.

           

           

          What You'll learn

          Available Downloads

          • create a simple array

          • create one- and two-input tables

          • use the Goal Seek tool

          • create, modify, and recall scenarios using the Scenario Manager

          • generate summary reports using the Scenario Manager

          What you need to know

          • create and manage named ranges

          • create formulas and functions

          • work with table features

          If you don't have those skills, consider first taking the workshop:

          Bookmark and Share

          Event Schedule

          There are no upcoming dates for this event.

          IU Calendar




          • CLOSED
            May 27 12:00am
            Closed more »
          • CLOSED
            May 28 12:00am
            The competition lap pool for lap swim is closed. more »
          • CLOSED - Memorial Day
            May 29 12:00am
            Closed more »
          • Competition Pool
            May 30 5:30am
            Lap Swim more »
          • Instructional Pool
            May 30 7:00am
            Lap Swim  more »
          Saturday, May 27, 2017