Change Location × Indianapolis

    Find Me

    • Use Current Location

    Recent Locations

      Excel 2010: What-If Analysis & Named Scenarios in Indianapolis

      • Excel 2010: What-If Analysis & Named Scenarios Photos
      1 of 0
      June 29, 2012

      Friday   9:00 AM - 10:30 AM

      425 University Blvd
      Indianapolis, Indiana 46202

      Map
      Performers:
      • No Performers Listed
      0 people like this event
      EVENT DETAILS
      Excel 2010: What-If Analysis & Named Scenarios

      Location: IT – Informatics & Communications Technology Complex (ICTC)
      Room: 127
      535 W. Michigan St.
      Indianapolis, IN 46202

      This workshop lasts 3 hours, 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 data tables, Goal Seek, and Solver. Participants will use the Scenario Manager feature, which makes automating what-if models easy by storing and comparing named data scenarios. Summary reports will be generated to see the effects of these various combinations of values.

      What You'll learn

        create a simple array

        create one- and two-input tables

        use the Goal Seek and Solver tools

        create, modify, and recall scenarios 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:

            Excel 2010: Data Management


            Categories: Education | University & Alumni

            Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.
            COMMENTS ABOUT Excel 2010: What-If Analysis & Named Scenarios