• Get Ahead and Stay Ahead: Breaking through with Problem People at Work
    May 24 12:00am
    This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
  • Installing and Configuring Windows Server 2012 (MOC 20410)
    May 24 9:00am
    This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
  • Installing and Configuring Windows Server 2012 (MOC 20410)
    May 24 9:00am
    This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
  • Excel 2013: Charts & Graphics
    May 25 1:30pm
    This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
  • Excel 2013: Charts & Graphics
    May 25 1:30pm
    This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
Tuesday, May 24, 2016
    IU Calendar




    • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
      May 24 12:00am
      This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
    • Installing and Configuring Windows Server 2012 (MOC 20410)
      May 24 9:00am
      This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
    • Installing and Configuring Windows Server 2012 (MOC 20410)
      May 24 9:00am
      This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
    • Excel 2013: Charts & Graphics
      May 25 1:30pm
      This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
    • Excel 2013: Charts & Graphics
      May 25 1:30pm
      This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
    Tuesday, May 24, 2016
      IU Calendar




      • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
        May 24 12:00am
        This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
      • Installing and Configuring Windows Server 2012 (MOC 20410)
        May 24 9:00am
        This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
      • Installing and Configuring Windows Server 2012 (MOC 20410)
        May 24 9:00am
        This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
      • Excel 2013: Charts & Graphics
        May 25 1:30pm
        This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
      • Excel 2013: Charts & Graphics
        May 25 1:30pm
        This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
      Tuesday, May 24, 2016
        IU Calendar




        • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
          May 24 12:00am
          This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
        • Installing and Configuring Windows Server 2012 (MOC 20410)
          May 24 9:00am
          This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
        • Installing and Configuring Windows Server 2012 (MOC 20410)
          May 24 9:00am
          This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
        • Excel 2013: Charts & Graphics
          May 25 1:30pm
          This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
        • Excel 2013: Charts & Graphics
          May 25 1:30pm
          This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
        Tuesday, May 24, 2016

          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




          • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
            May 24 12:00am
            This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
          • Installing and Configuring Windows Server 2012 (MOC 20410)
            May 24 9:00am
            This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
          • Installing and Configuring Windows Server 2012 (MOC 20410)
            May 24 9:00am
            This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
          • Excel 2013: Charts & Graphics
            May 25 1:30pm
            This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
          • Excel 2013: Charts & Graphics
            May 25 1:30pm
            This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
          Tuesday, May 24, 2016