• CLOSED
    August 19 12:00am
    Closed more »
  • 2017 IUPUI and IU Symphony on the Prairie
    August 19 6:00pm
    Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
  • IU Lilly School of Philanthropy Symphony on the Prairie
    August 19 6:30pm
    Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
  • IU School of Public Health Night at Conner Prairie
    August 19 6:30pm
    Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
  • WOW: First Night
    August 19 7:00pm
    Start the year off right in the Campus Center with an evening full of fun activities and free snacks.  more »
Saturday, August 19, 2017
    IU Calendar




    • CLOSED
      August 19 12:00am
      Closed more »
    • 2017 IUPUI and IU Symphony on the Prairie
      August 19 6:00pm
      Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
    • IU Lilly School of Philanthropy Symphony on the Prairie
      August 19 6:30pm
      Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
    • IU School of Public Health Night at Conner Prairie
      August 19 6:30pm
      Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
    • WOW: First Night
      August 19 7:00pm
      Start the year off right in the Campus Center with an evening full of fun activities and free snacks.  more »
    Saturday, August 19, 2017
      IU Calendar




      • CLOSED
        August 19 12:00am
        Closed more »
      • 2017 IUPUI and IU Symphony on the Prairie
        August 19 6:00pm
        Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
      • IU Lilly School of Philanthropy Symphony on the Prairie
        August 19 6:30pm
        Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
      • IU School of Public Health Night at Conner Prairie
        August 19 6:30pm
        Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
      • WOW: First Night
        August 19 7:00pm
        Start the year off right in the Campus Center with an evening full of fun activities and free snacks.  more »
      Saturday, August 19, 2017
        IU Calendar




        • CLOSED
          August 19 12:00am
          Closed more »
        • 2017 IUPUI and IU Symphony on the Prairie
          August 19 6:00pm
          Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
        • IU Lilly School of Philanthropy Symphony on the Prairie
          August 19 6:30pm
          Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
        • IU School of Public Health Night at Conner Prairie
          August 19 6:30pm
          Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
        • WOW: First Night
          August 19 7:00pm
          Start the year off right in the Campus Center with an evening full of fun activities and free snacks.  more »
        Saturday, August 19, 2017

          About This Event

          Summary

          This workshop will explore arrays and conditional functions used to summarize or count data with certain criteria. Discover how to use IF and Nested IF functions to test for specific conditions and how to apply different types of conditional formats. Participants will also explore various techniques to look up values in a range of data using VLOOKUP. Challenge exercises will be provided for reinforcement.

           What you'll learn:

          •perform calculations using array formulas

          •create IF and nested IF functions

          •use conditional functions to summarize or count data

          •use the CONCATENATE function to join text

          •look up data using VLOOKUP

          •apply different types of conditional formatting

           

          What you need to know :

          •create and manage named ranges

          •create formulas and functions

          •create and apply validation criteria

          •work with tables

          •sort and filter data

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

          Excel 2013: Data Management

          Bookmark and Share

          Event Schedule

          There are no upcoming dates for this event.

          IU Calendar




          • CLOSED
            August 19 12:00am
            Closed more »
          • 2017 IUPUI and IU Symphony on the Prairie
            August 19 6:00pm
            Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
          • IU Lilly School of Philanthropy Symphony on the Prairie
            August 19 6:30pm
            Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
          • IU School of Public Health Night at Conner Prairie
            August 19 6:30pm
            Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
          • WOW: First Night
            August 19 7:00pm
            Start the year off right in the Campus Center with an evening full of fun activities and free snacks.  more »
          Saturday, August 19, 2017