• Administering System Center 2012 Configuration Manager (MOC 10747)
    July 01 9:00am
    This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
  • Administering System Center 2012 Configuration Manager (MOC 10747)
    July 01 9:00am
    This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
  • Excel 2013: The Basics
    July 06 1:30pm
    This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
  • Access 2013: The Basics
    July 07 9:00am
    This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
  • Creating Graphics for the Web
    July 08 9:00am
    This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
Friday, July 1, 2016
    IU Calendar




    • Administering System Center 2012 Configuration Manager (MOC 10747)
      July 01 9:00am
      This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
    • Administering System Center 2012 Configuration Manager (MOC 10747)
      July 01 9:00am
      This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
    • Excel 2013: The Basics
      July 06 1:30pm
      This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
    • Access 2013: The Basics
      July 07 9:00am
      This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
    • Creating Graphics for the Web
      July 08 9:00am
      This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
    Friday, July 1, 2016
      IU Calendar




      • Administering System Center 2012 Configuration Manager (MOC 10747)
        July 01 9:00am
        This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
      • Administering System Center 2012 Configuration Manager (MOC 10747)
        July 01 9:00am
        This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
      • Excel 2013: The Basics
        July 06 1:30pm
        This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
      • Access 2013: The Basics
        July 07 9:00am
        This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
      • Creating Graphics for the Web
        July 08 9:00am
        This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
      Friday, July 1, 2016
        IU Calendar




        • Administering System Center 2012 Configuration Manager (MOC 10747)
          July 01 9:00am
          This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
        • Administering System Center 2012 Configuration Manager (MOC 10747)
          July 01 9:00am
          This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
        • Excel 2013: The Basics
          July 06 1:30pm
          This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
        • Access 2013: The Basics
          July 07 9:00am
          This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
        • Creating Graphics for the Web
          July 08 9:00am
          This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
        Friday, July 1, 2016

          About This Event

          Summary

          Discover how pivot tables can make work tasks easier and how they can be useful in analyzing data. In this workshop, participants will learn how to create, format, and modify pivot tables, perform various summary techniques when displaying data, and how to create pivot charts. This workshop will also explore more advanced techniques such as how to group items in pivot tables and how to create calculated fields. The slicer tool will also be introduced.

           What you'll learn             

          •             create, modify, and format pivot tables

          •             use summary functions and customized calculations

          •             group numbers and dates

          •             create filters and slicers

          •             link and update pivot tables

          •             create pivot charts                         

          What you need to know              

          •             navigate an Excel spreadsheet

          •             create basic formulas

          •             work with subtotals

          •             sort and filter data

          •             work with tables

          •             manage named ranges 

          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




          • Administering System Center 2012 Configuration Manager (MOC 10747)
            July 01 9:00am
            This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
          • Administering System Center 2012 Configuration Manager (MOC 10747)
            July 01 9:00am
            This workshop lasts 5 days. This course is intended for Configuration Manager Administrators who are responsible for configuring and managing one or more System Center 2012 Configuration Manager sites and all supporting systems. They have one to three years of experience supporting multiple desktop and ser more »
          • Excel 2013: The Basics
            July 06 1:30pm
            This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity  Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with c more »
          • Access 2013: The Basics
            July 07 9:00am
            This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity Access 2013 End-User Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for peo more »
          • Creating Graphics for the Web
            July 08 9:00am
            This workshop lasts 3 hours, and is part of the certificate series Web Creation This workshop introduces the different tools available in Illustrator and Photoshop for creating web graphics. Participants will create graphics for a website, including buttons, a logo, and a banner image. During the crea more »
          Friday, July 1, 2016