• Competition Pool
    October 18 5:30am
    lap swim more »
  • Competition Pool
    October 18 11:00am
    lap swim more »
  • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
    October 18 12:00pm
    How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
  • LGBTQmmunity: Indiana's LGBT History
    October 18 12:00pm
    Special Guest Mark Alan Lee will come and share some of Indiana's LGBT History more »
  • Instructional Pool
    October 18 4:00pm
    lap swim more »
Wednesday, October 18, 2017
    IU Calendar




    • Competition Pool
      October 18 5:30am
      lap swim more »
    • Competition Pool
      October 18 11:00am
      lap swim more »
    • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
      October 18 12:00pm
      How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
    • LGBTQmmunity: Indiana's LGBT History
      October 18 12:00pm
      Special Guest Mark Alan Lee will come and share some of Indiana's LGBT History more »
    • Instructional Pool
      October 18 4:00pm
      lap swim more »
    Wednesday, October 18, 2017
      IU Calendar




      • Competition Pool
        October 18 5:30am
        lap swim more »
      • Competition Pool
        October 18 11:00am
        lap swim more »
      • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
        October 18 12:00pm
        How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
      • LGBTQmmunity: Indiana's LGBT History
        October 18 12:00pm
        Special Guest Mark Alan Lee will come and share some of Indiana's LGBT History more »
      • Instructional Pool
        October 18 4:00pm
        lap swim more »
      Wednesday, October 18, 2017
        IU Calendar




        • Competition Pool
          October 18 5:30am
          lap swim more »
        • Competition Pool
          October 18 11:00am
          lap swim more »
        • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
          October 18 12:00pm
          How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
        • LGBTQmmunity: Indiana's LGBT History
          October 18 12:00pm
          Special Guest Mark Alan Lee will come and share some of Indiana's LGBT History more »
        • Instructional Pool
          October 18 4:00pm
          lap swim more »
        Wednesday, October 18, 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




          • Competition Pool
            October 18 5:30am
            lap swim more »
          • Competition Pool
            October 18 11:00am
            lap swim more »
          • Teaching@IUPUI: Preventing and Managing Disruptive Behavior
            October 18 12:00pm
            How and when should you address disruptive student behaviors? Disruptive student behaviors are those behaviors which impede learning and teaching, and have the potential to escalate or spread if left unchecked. This webinar will present examples of disruptive student behaviors and participants will engage in discussions about how to prevent and more »
          • LGBTQmmunity: Indiana's LGBT History
            October 18 12:00pm
            Special Guest Mark Alan Lee will come and share some of Indiana's LGBT History more »
          • Instructional Pool
            October 18 4:00pm
            lap swim more »
          Wednesday, October 18, 2017