• Sophomore Welcome Back
    August 30 8:00am
    Attend this sophomore exclusive event for free food, giveaways and a chance to meet other sophomore students.  more »
  • Excellence in Teaching Workshop
    August 30 9:00am
    This workshop is designed for faculty with teaching as the area of endeavor. Please visit our website to register. more »
  • Involvement Expo
    August 30 10:00am
    Discover the many ways to get involved at IUPUI and in the Indianapolis community by checking out the registered student groups and non-profit organization at this event happening over two days. more »
  • 39th Annual Ice Cream Social
    August 30 11:00am
    Enjoy ice cream with help from our Distinguished Dippers.  Music and ice cream, just what you need on a Tuesday afternoon! more »
  • ePortfolio for Students: Taskstream
    August 30 12:00pm
    This workshop lasts 60 minutes. In this session you will learn how to use Taskstream’s Folio and Web Page tools to create an electronic portfolio. We’ll explore the different styles and layouts available, how to organize your content, and how to share your final product with others. more »
Tuesday, August 30, 2016
    IU Calendar




    • Sophomore Welcome Back
      August 30 8:00am
      Attend this sophomore exclusive event for free food, giveaways and a chance to meet other sophomore students.  more »
    • Excellence in Teaching Workshop
      August 30 9:00am
      This workshop is designed for faculty with teaching as the area of endeavor. Please visit our website to register. more »
    • Involvement Expo
      August 30 10:00am
      Discover the many ways to get involved at IUPUI and in the Indianapolis community by checking out the registered student groups and non-profit organization at this event happening over two days. more »
    • 39th Annual Ice Cream Social
      August 30 11:00am
      Enjoy ice cream with help from our Distinguished Dippers.  Music and ice cream, just what you need on a Tuesday afternoon! more »
    • ePortfolio for Students: Taskstream
      August 30 12:00pm
      This workshop lasts 60 minutes. In this session you will learn how to use Taskstream’s Folio and Web Page tools to create an electronic portfolio. We’ll explore the different styles and layouts available, how to organize your content, and how to share your final product with others. more »
    Tuesday, August 30, 2016
      IU Calendar




      • Sophomore Welcome Back
        August 30 8:00am
        Attend this sophomore exclusive event for free food, giveaways and a chance to meet other sophomore students.  more »
      • Excellence in Teaching Workshop
        August 30 9:00am
        This workshop is designed for faculty with teaching as the area of endeavor. Please visit our website to register. more »
      • Involvement Expo
        August 30 10:00am
        Discover the many ways to get involved at IUPUI and in the Indianapolis community by checking out the registered student groups and non-profit organization at this event happening over two days. more »
      • 39th Annual Ice Cream Social
        August 30 11:00am
        Enjoy ice cream with help from our Distinguished Dippers.  Music and ice cream, just what you need on a Tuesday afternoon! more »
      • ePortfolio for Students: Taskstream
        August 30 12:00pm
        This workshop lasts 60 minutes. In this session you will learn how to use Taskstream’s Folio and Web Page tools to create an electronic portfolio. We’ll explore the different styles and layouts available, how to organize your content, and how to share your final product with others. more »
      Tuesday, August 30, 2016
        IU Calendar




        • Sophomore Welcome Back
          August 30 8:00am
          Attend this sophomore exclusive event for free food, giveaways and a chance to meet other sophomore students.  more »
        • Excellence in Teaching Workshop
          August 30 9:00am
          This workshop is designed for faculty with teaching as the area of endeavor. Please visit our website to register. more »
        • Involvement Expo
          August 30 10:00am
          Discover the many ways to get involved at IUPUI and in the Indianapolis community by checking out the registered student groups and non-profit organization at this event happening over two days. more »
        • 39th Annual Ice Cream Social
          August 30 11:00am
          Enjoy ice cream with help from our Distinguished Dippers.  Music and ice cream, just what you need on a Tuesday afternoon! more »
        • ePortfolio for Students: Taskstream
          August 30 12:00pm
          This workshop lasts 60 minutes. In this session you will learn how to use Taskstream’s Folio and Web Page tools to create an electronic portfolio. We’ll explore the different styles and layouts available, how to organize your content, and how to share your final product with others. more »
        Tuesday, August 30, 2016

          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




          • Sophomore Welcome Back
            August 30 8:00am
            Attend this sophomore exclusive event for free food, giveaways and a chance to meet other sophomore students.  more »
          • Excellence in Teaching Workshop
            August 30 9:00am
            This workshop is designed for faculty with teaching as the area of endeavor. Please visit our website to register. more »
          • Involvement Expo
            August 30 10:00am
            Discover the many ways to get involved at IUPUI and in the Indianapolis community by checking out the registered student groups and non-profit organization at this event happening over two days. more »
          • 39th Annual Ice Cream Social
            August 30 11:00am
            Enjoy ice cream with help from our Distinguished Dippers.  Music and ice cream, just what you need on a Tuesday afternoon! more »
          • ePortfolio for Students: Taskstream
            August 30 12:00pm
            This workshop lasts 60 minutes. In this session you will learn how to use Taskstream’s Folio and Web Page tools to create an electronic portfolio. We’ll explore the different styles and layouts available, how to organize your content, and how to share your final product with others. more »
          Tuesday, August 30, 2016