• Get Ahead and Stay Ahead: Breaking through with Problem People at Work
    May 27 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 27 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 27 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 »
  • HTML5 & CSS: Structuring Pages
    May 27 9:00am
    This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Expand your HTML5 & CSS: The Basics knowledge by learning how to fully structure your pages. Learn how to create CSS buttons, internal-page hyperlinks, tables, useful navigation, useful footers, and properly formatti more »
  • Excel 2013: Data Management
    June 01 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 »
Friday, May 27, 2016
    IU Calendar




    • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
      May 27 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 27 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 27 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 »
    • HTML5 & CSS: Structuring Pages
      May 27 9:00am
      This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Expand your HTML5 & CSS: The Basics knowledge by learning how to fully structure your pages. Learn how to create CSS buttons, internal-page hyperlinks, tables, useful navigation, useful footers, and properly formatti more »
    • Excel 2013: Data Management
      June 01 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 »
    Friday, May 27, 2016
      IU Calendar




      • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
        May 27 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 27 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 27 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 »
      • HTML5 & CSS: Structuring Pages
        May 27 9:00am
        This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Expand your HTML5 & CSS: The Basics knowledge by learning how to fully structure your pages. Learn how to create CSS buttons, internal-page hyperlinks, tables, useful navigation, useful footers, and properly formatti more »
      • Excel 2013: Data Management
        June 01 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 »
      Friday, May 27, 2016
        IU Calendar




        • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
          May 27 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 27 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 27 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 »
        • HTML5 & CSS: Structuring Pages
          May 27 9:00am
          This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Expand your HTML5 & CSS: The Basics knowledge by learning how to fully structure your pages. Learn how to create CSS buttons, internal-page hyperlinks, tables, useful navigation, useful footers, and properly formatti more »
        • Excel 2013: Data Management
          June 01 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 »
        Friday, May 27, 2016

          About This Event

          Summary

          This workshop is specifically designed for any IU staff member who uses Excel to format IUIE data. Participants will learn how to format text and numeric data, create and remove subtotals, convert data to a table, sort and filter data, automate work using macros, and analyze data using pivot tables.

          It is recommended that IU staff take the IUIE Reporting Basics workshop or at least have some experience using the IUIE environment before taking this Excel workshop.

          What you'll learn:            

              format text and numeric data

              use macros to automate tasks

              use AVERAGE, COUNTIF, and VLOOKUP functions

              create and remove subtotals

              convert data to a table and work with table features

              sort and filter data

              analyze data using pivot tables

           What you need to know:

              navigate an Excel spreadsheet

              switch back and forth between Windows applications

              enter and edit data

              work with basic formulas and functions

              save and print a worksheet

          If you don't have those skills, consider first taking the workshop:

              Excel 2013: The Basics

          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 27 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 27 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 27 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 »
          • HTML5 & CSS: Structuring Pages
            May 27 9:00am
            This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Expand your HTML5 & CSS: The Basics knowledge by learning how to fully structure your pages. Learn how to create CSS buttons, internal-page hyperlinks, tables, useful navigation, useful footers, and properly formatti more »
          • Excel 2013: Data Management
            June 01 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 »
          Friday, May 27, 2016