• CLOSED
    December 16 12:00am
    Closed 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 »
  • Competition Pool
    December 18 5:30am
    lap swim more »
  • Competition Pool
    December 18 11:00am
    Lap Swim more »
Saturday, December 16, 2017
    IU Calendar




    • CLOSED
      December 16 12:00am
      Closed 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 »
    • Competition Pool
      December 18 5:30am
      lap swim more »
    • Competition Pool
      December 18 11:00am
      Lap Swim more »
    Saturday, December 16, 2017
      IU Calendar




      • CLOSED
        December 16 12:00am
        Closed 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 »
      • Competition Pool
        December 18 5:30am
        lap swim more »
      • Competition Pool
        December 18 11:00am
        Lap Swim more »
      Saturday, December 16, 2017
        IU Calendar




        • CLOSED
          December 16 12:00am
          Closed 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 »
        • Competition Pool
          December 18 5:30am
          lap swim more »
        • Competition Pool
          December 18 11:00am
          Lap Swim more »
        Saturday, December 16, 2017

          About This Event

          Summary

          This workshop lasts 3 hours, and is part of the certificate series Excel 2010 Advanced End-User

          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

          Available Downloads

          • 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:

          Bookmark and Share

          Event Schedule

          There are no upcoming dates for this event.

          IU Calendar




          • CLOSED
            December 16 12:00am
            Closed 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 »
          • Competition Pool
            December 18 5:30am
            lap swim more »
          • Competition Pool
            December 18 11:00am
            Lap Swim more »
          Saturday, December 16, 2017