• CLOSED
    December 16 12:00am
    Closed more »
  • Holiday Classic
    December 16 7:00am
    Columbus North Athletics sponsored swim meet. more »
  • IU HCOP Saturday Senior Academy
    December 16 10:00am
    The Saturday Senior Academy participants will receive information about health careers that will halp them make future career choices.  They will participate in on-site and off-site visits.  IU HCOP mentors will be present at all times.  more »
  • CLOSED
    December 17 12:00am
    The competition lap pool for lap swim is closed. more »
  • Holiday Training
    December 18 12:00am
    Holiday Training more »
Saturday, December 16, 2017
    IU Calendar




    • CLOSED
      December 16 12:00am
      Closed more »
    • Holiday Classic
      December 16 7:00am
      Columbus North Athletics sponsored swim meet. more »
    • IU HCOP Saturday Senior Academy
      December 16 10:00am
      The Saturday Senior Academy participants will receive information about health careers that will halp them make future career choices.  They will participate in on-site and off-site visits.  IU HCOP mentors will be present at all times.  more »
    • CLOSED
      December 17 12:00am
      The competition lap pool for lap swim is closed. more »
    • Holiday Training
      December 18 12:00am
      Holiday Training more »
    Saturday, December 16, 2017
      IU Calendar




      • CLOSED
        December 16 12:00am
        Closed more »
      • Holiday Classic
        December 16 7:00am
        Columbus North Athletics sponsored swim meet. more »
      • IU HCOP Saturday Senior Academy
        December 16 10:00am
        The Saturday Senior Academy participants will receive information about health careers that will halp them make future career choices.  They will participate in on-site and off-site visits.  IU HCOP mentors will be present at all times.  more »
      • CLOSED
        December 17 12:00am
        The competition lap pool for lap swim is closed. more »
      • Holiday Training
        December 18 12:00am
        Holiday Training more »
      Saturday, December 16, 2017
        IU Calendar




        • CLOSED
          December 16 12:00am
          Closed more »
        • Holiday Classic
          December 16 7:00am
          Columbus North Athletics sponsored swim meet. more »
        • IU HCOP Saturday Senior Academy
          December 16 10:00am
          The Saturday Senior Academy participants will receive information about health careers that will halp them make future career choices.  They will participate in on-site and off-site visits.  IU HCOP mentors will be present at all times.  more »
        • CLOSED
          December 17 12:00am
          The competition lap pool for lap swim is closed. more »
        • Holiday Training
          December 18 12:00am
          Holiday Training more »
        Saturday, December 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




          • CLOSED
            December 16 12:00am
            Closed more »
          • Holiday Classic
            December 16 7:00am
            Columbus North Athletics sponsored swim meet. more »
          • IU HCOP Saturday Senior Academy
            December 16 10:00am
            The Saturday Senior Academy participants will receive information about health careers that will halp them make future career choices.  They will participate in on-site and off-site visits.  IU HCOP mentors will be present at all times.  more »
          • CLOSED
            December 17 12:00am
            The competition lap pool for lap swim is closed. more »
          • Holiday Training
            December 18 12:00am
            Holiday Training more »
          Saturday, December 16, 2017