• Competition Pool
    January 16 5:30am
    Lap Swim more »
  • Dr. Martin Luther King, Jr. Day of Service
    January 16 8:00am
    On January 16, 2017, IUPUI will host its 16th annual Dr. Martin Luther King, Jr. Day of Service. You can be a part of this IUPUI tradition! Hundreds of IUPUI students, faculty, staff, and community members volunteer together at community sites across Indianapolis as a way to honor Dr. King’s commitment to service and social justice. more »
  • Hans Op de Beeck | Staging Silence (2)
    January 16 10:00am
    In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
  • Tom Sachs | Radiant City: Paintings 2000-2016
    January 16 10:00am
    A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
  • Craig McDaniel + Jean Robertson | Close Reading
    January 16 10:00am
    In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
Monday, January 16, 2017
    IU Calendar




    • Competition Pool
      January 16 5:30am
      Lap Swim more »
    • Dr. Martin Luther King, Jr. Day of Service
      January 16 8:00am
      On January 16, 2017, IUPUI will host its 16th annual Dr. Martin Luther King, Jr. Day of Service. You can be a part of this IUPUI tradition! Hundreds of IUPUI students, faculty, staff, and community members volunteer together at community sites across Indianapolis as a way to honor Dr. King’s commitment to service and social justice. more »
    • Hans Op de Beeck | Staging Silence (2)
      January 16 10:00am
      In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
    • Tom Sachs | Radiant City: Paintings 2000-2016
      January 16 10:00am
      A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
    • Craig McDaniel + Jean Robertson | Close Reading
      January 16 10:00am
      In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
    Monday, January 16, 2017
      IU Calendar




      • Competition Pool
        January 16 5:30am
        Lap Swim more »
      • Dr. Martin Luther King, Jr. Day of Service
        January 16 8:00am
        On January 16, 2017, IUPUI will host its 16th annual Dr. Martin Luther King, Jr. Day of Service. You can be a part of this IUPUI tradition! Hundreds of IUPUI students, faculty, staff, and community members volunteer together at community sites across Indianapolis as a way to honor Dr. King’s commitment to service and social justice. more »
      • Hans Op de Beeck | Staging Silence (2)
        January 16 10:00am
        In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
      • Tom Sachs | Radiant City: Paintings 2000-2016
        January 16 10:00am
        A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
      • Craig McDaniel + Jean Robertson | Close Reading
        January 16 10:00am
        In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
      Monday, January 16, 2017
        IU Calendar




        • Competition Pool
          January 16 5:30am
          Lap Swim more »
        • Dr. Martin Luther King, Jr. Day of Service
          January 16 8:00am
          On January 16, 2017, IUPUI will host its 16th annual Dr. Martin Luther King, Jr. Day of Service. You can be a part of this IUPUI tradition! Hundreds of IUPUI students, faculty, staff, and community members volunteer together at community sites across Indianapolis as a way to honor Dr. King’s commitment to service and social justice. more »
        • Hans Op de Beeck | Staging Silence (2)
          January 16 10:00am
          In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
        • Tom Sachs | Radiant City: Paintings 2000-2016
          January 16 10:00am
          A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
        • Craig McDaniel + Jean Robertson | Close Reading
          January 16 10:00am
          In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
        Monday, January 16, 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
            January 16 5:30am
            Lap Swim more »
          • Dr. Martin Luther King, Jr. Day of Service
            January 16 8:00am
            On January 16, 2017, IUPUI will host its 16th annual Dr. Martin Luther King, Jr. Day of Service. You can be a part of this IUPUI tradition! Hundreds of IUPUI students, faculty, staff, and community members volunteer together at community sites across Indianapolis as a way to honor Dr. King’s commitment to service and social justice. more »
          • Hans Op de Beeck | Staging Silence (2)
            January 16 10:00am
            In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
          • Tom Sachs | Radiant City: Paintings 2000-2016
            January 16 10:00am
            A major survey exhibition of Tom Sachs’ paintings showcasing the artist’s ongoing interest in combining mass-produced pop cultural icons with a hand made aesthetic. This exhibition is made possible in part by the generous support of Julie and David Eskenazi. more »
          • Craig McDaniel + Jean Robertson | Close Reading
            January 16 10:00am
            In Close Reading, Herron faculty members Jean Robertson and Craig McDaniel explore the relationship of visual and verbal modes of communicating and expressing meaning. more »
          Monday, January 16, 2017