• 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 25 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 End-User

          Learn how to use lists to extract and manipulate data. Participants will explore Excel’s table-related features in this workshop, as well as creating custom lists, validating data entry, sorting and filtering data, creating and removing subtotals, and recording a macro. Participants will also learn how to work with multiple worksheets and how to save a workspace. This workshop also introduces pivot tables.

              What You'll learn Available Downloads

          • specify data validation criteria

          • separate and concatenate text strings

          • record and use a macro

          • protect a worksheet

          • work with custom lists

          • convert data to a table and work with table features

          • sort and filter data

          • create and remove subtotals

          • create a pivot table

          • link data between worksheets

          • work with multiple worksheets

          • compare workbooks and save a workspace

          What you need to know

          • understand spreadsheet terminology

          • create and modify Excel spreadsheets

          • enter text or numeric data and formulas or functions

          • create named ranges

          • format worksheets

          • create simple charts

          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 25 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 25 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