• Competition Pool
    July 27 9:00am
    lap swim  more »
  • Age Group State
    July 28 12:00am
    swim meet more »
  • Instructional Pool
    July 28 5:30am
    lap swim more »
  • Indiana Swimming Age Group Long Course State Championships
    July 28 6:30am
    Hosted by Indiana Swimming more »
  • Faculty Research Development Institute Closing
    July 28 9:00am
    This is the final day for IU-MSI STEM Initiative's Faculty Research Development Institute, provided under a Department of Navy Grant.  This is a culmination of a week promoting faculty research and collaboration, along with the STEM Summer Scholars Institute's final research poster presentation.  Dr. Rene Horton of NASA will be more »
Thursday, July 27, 2017
    IU Calendar




    • Competition Pool
      July 27 9:00am
      lap swim  more »
    • Age Group State
      July 28 12:00am
      swim meet more »
    • Instructional Pool
      July 28 5:30am
      lap swim more »
    • Indiana Swimming Age Group Long Course State Championships
      July 28 6:30am
      Hosted by Indiana Swimming more »
    • Faculty Research Development Institute Closing
      July 28 9:00am
      This is the final day for IU-MSI STEM Initiative's Faculty Research Development Institute, provided under a Department of Navy Grant.  This is a culmination of a week promoting faculty research and collaboration, along with the STEM Summer Scholars Institute's final research poster presentation.  Dr. Rene Horton of NASA will be more »
    Thursday, July 27, 2017
      IU Calendar




      • Competition Pool
        July 27 9:00am
        lap swim  more »
      • Age Group State
        July 28 12:00am
        swim meet more »
      • Instructional Pool
        July 28 5:30am
        lap swim more »
      • Indiana Swimming Age Group Long Course State Championships
        July 28 6:30am
        Hosted by Indiana Swimming more »
      • Faculty Research Development Institute Closing
        July 28 9:00am
        This is the final day for IU-MSI STEM Initiative's Faculty Research Development Institute, provided under a Department of Navy Grant.  This is a culmination of a week promoting faculty research and collaboration, along with the STEM Summer Scholars Institute's final research poster presentation.  Dr. Rene Horton of NASA will be more »
      Thursday, July 27, 2017
        IU Calendar




        • Competition Pool
          July 27 9:00am
          lap swim  more »
        • Age Group State
          July 28 12:00am
          swim meet more »
        • Instructional Pool
          July 28 5:30am
          lap swim more »
        • Indiana Swimming Age Group Long Course State Championships
          July 28 6:30am
          Hosted by Indiana Swimming more »
        • Faculty Research Development Institute Closing
          July 28 9:00am
          This is the final day for IU-MSI STEM Initiative's Faculty Research Development Institute, provided under a Department of Navy Grant.  This is a culmination of a week promoting faculty research and collaboration, along with the STEM Summer Scholars Institute's final research poster presentation.  Dr. Rene Horton of NASA will be more »
        Thursday, July 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




          • Competition Pool
            July 27 9:00am
            lap swim  more »
          • Age Group State
            July 28 12:00am
            swim meet more »
          • Instructional Pool
            July 28 5:30am
            lap swim more »
          • Indiana Swimming Age Group Long Course State Championships
            July 28 6:30am
            Hosted by Indiana Swimming more »
          • Faculty Research Development Institute Closing
            July 28 9:00am
            This is the final day for IU-MSI STEM Initiative's Faculty Research Development Institute, provided under a Department of Navy Grant.  This is a culmination of a week promoting faculty research and collaboration, along with the STEM Summer Scholars Institute's final research poster presentation.  Dr. Rene Horton of NASA will be more »
          Thursday, July 27, 2017