• Administering System Center 2012 Configuration Manager (MOC 10747)
    June 27 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)
    June 27 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 »
  • Second Session, Resiliency for Mental Well-being
    June 27 2:00pm
    Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
  • Background Check, I-9 and E-Verify Refresher Training
    June 28 9:00am
    Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
  • Excel 2013: Basic Automation Using Macros
    June 28 5:30pm
    This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
Sunday, June 26, 2016
    IU Calendar




    • Administering System Center 2012 Configuration Manager (MOC 10747)
      June 27 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)
      June 27 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 »
    • Second Session, Resiliency for Mental Well-being
      June 27 2:00pm
      Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
    • Background Check, I-9 and E-Verify Refresher Training
      June 28 9:00am
      Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
    • Excel 2013: Basic Automation Using Macros
      June 28 5:30pm
      This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
    Sunday, June 26, 2016
      IU Calendar




      • Administering System Center 2012 Configuration Manager (MOC 10747)
        June 27 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)
        June 27 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 »
      • Second Session, Resiliency for Mental Well-being
        June 27 2:00pm
        Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
      • Background Check, I-9 and E-Verify Refresher Training
        June 28 9:00am
        Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
      • Excel 2013: Basic Automation Using Macros
        June 28 5:30pm
        This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
      Sunday, June 26, 2016
        IU Calendar




        • Administering System Center 2012 Configuration Manager (MOC 10747)
          June 27 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)
          June 27 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 »
        • Second Session, Resiliency for Mental Well-being
          June 27 2:00pm
          Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
        • Background Check, I-9 and E-Verify Refresher Training
          June 28 9:00am
          Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
        • Excel 2013: Basic Automation Using Macros
          June 28 5:30pm
          This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
        Sunday, June 26, 2016

          About This Event

          Summary

           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:

           •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

           

           

          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:

          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)
            June 27 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)
            June 27 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 »
          • Second Session, Resiliency for Mental Well-being
            June 27 2:00pm
            Course Overview: This experiential training offers evidence-based strategies to improve psychological flexibility while minimizing irritability, lack concentration and focus, worry and self-doubt. The program leads to positive outcomes by utilizing: values-oriented living; acceptance and commitment; and mindfulness practices. Facilitate more »
          • Background Check, I-9 and E-Verify Refresher Training
            June 28 9:00am
            Course Overview:  This is intended as a refresher/update training on processing background checks, I-9s and E-Verify checks through GIS. However, we will include a brief outline of the basics before moving on to more complicated issues, such as remote hires, non-US citizen hires, and handling Tentative Non-Confirmations. Will discuss crit more »
          • Excel 2013: Basic Automation Using Macros
            June 28 5:30pm
            This workshop lasts 90 minutes, and is part of the certificate series Excel 2013 End-User Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel, how to make them easi more »
          Sunday, June 26, 2016