• Resiliency for Mental Well-being (Session 3 of 3)
    August 01 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. Facilitated more »
  • IUIE Reporting Basics
    August 02 1:30pm
    Indiana University Employees Only This workshop lasts 3 hours. This workshop is intended to be a three-hour, hands-on experience. This course covers: Accessing the IUIE; Navigating in IUIE; Working with Catalo more »
  • Excel 2013: Advanced Macros & User Defined Functions
    August 02 5:30pm
    This workshop lasts 3.5 hours, and is part of the certificate series Excel 2013 Advanced End-User  Macros combine a sequence of commands into a single action and user-defined functions are used to perform complex calculations that can be launched from a single function name. In this workshop, participan more »
  • IU Periodontic Alumni Board Meeting
    August 03 8:00pm
    For more information or to register for this event please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
  • Access 2013: Reports
    August 04 9:00am
    This workshop lasts 3 hours, and is part of the certificate series Access 2013 End-User Reports can provide attractive and organized ways to share data with others. This workshop is intended for anyone who is interested in learning how to create and enhance relational reports. Participants will also l more »
Sunday, July 31, 2016
    IU Calendar




    • Resiliency for Mental Well-being (Session 3 of 3)
      August 01 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. Facilitated more »
    • IUIE Reporting Basics
      August 02 1:30pm
      Indiana University Employees Only This workshop lasts 3 hours. This workshop is intended to be a three-hour, hands-on experience. This course covers: Accessing the IUIE; Navigating in IUIE; Working with Catalo more »
    • Excel 2013: Advanced Macros & User Defined Functions
      August 02 5:30pm
      This workshop lasts 3.5 hours, and is part of the certificate series Excel 2013 Advanced End-User  Macros combine a sequence of commands into a single action and user-defined functions are used to perform complex calculations that can be launched from a single function name. In this workshop, participan more »
    • IU Periodontic Alumni Board Meeting
      August 03 8:00pm
      For more information or to register for this event please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
    • Access 2013: Reports
      August 04 9:00am
      This workshop lasts 3 hours, and is part of the certificate series Access 2013 End-User Reports can provide attractive and organized ways to share data with others. This workshop is intended for anyone who is interested in learning how to create and enhance relational reports. Participants will also l more »
    Sunday, July 31, 2016
      IU Calendar




      • Resiliency for Mental Well-being (Session 3 of 3)
        August 01 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. Facilitated more »
      • IUIE Reporting Basics
        August 02 1:30pm
        Indiana University Employees Only This workshop lasts 3 hours. This workshop is intended to be a three-hour, hands-on experience. This course covers: Accessing the IUIE; Navigating in IUIE; Working with Catalo more »
      • Excel 2013: Advanced Macros & User Defined Functions
        August 02 5:30pm
        This workshop lasts 3.5 hours, and is part of the certificate series Excel 2013 Advanced End-User  Macros combine a sequence of commands into a single action and user-defined functions are used to perform complex calculations that can be launched from a single function name. In this workshop, participan more »
      • IU Periodontic Alumni Board Meeting
        August 03 8:00pm
        For more information or to register for this event please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
      • Access 2013: Reports
        August 04 9:00am
        This workshop lasts 3 hours, and is part of the certificate series Access 2013 End-User Reports can provide attractive and organized ways to share data with others. This workshop is intended for anyone who is interested in learning how to create and enhance relational reports. Participants will also l more »
      Sunday, July 31, 2016
        IU Calendar




        • Resiliency for Mental Well-being (Session 3 of 3)
          August 01 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. Facilitated more »
        • IUIE Reporting Basics
          August 02 1:30pm
          Indiana University Employees Only This workshop lasts 3 hours. This workshop is intended to be a three-hour, hands-on experience. This course covers: Accessing the IUIE; Navigating in IUIE; Working with Catalo more »
        • Excel 2013: Advanced Macros & User Defined Functions
          August 02 5:30pm
          This workshop lasts 3.5 hours, and is part of the certificate series Excel 2013 Advanced End-User  Macros combine a sequence of commands into a single action and user-defined functions are used to perform complex calculations that can be launched from a single function name. In this workshop, participan more »
        • IU Periodontic Alumni Board Meeting
          August 03 8:00pm
          For more information or to register for this event please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
        • Access 2013: Reports
          August 04 9:00am
          This workshop lasts 3 hours, and is part of the certificate series Access 2013 End-User Reports can provide attractive and organized ways to share data with others. This workshop is intended for anyone who is interested in learning how to create and enhance relational reports. Participants will also l more »
        Sunday, July 31, 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




          • Resiliency for Mental Well-being (Session 3 of 3)
            August 01 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. Facilitated more »
          • IUIE Reporting Basics
            August 02 1:30pm
            Indiana University Employees Only This workshop lasts 3 hours. This workshop is intended to be a three-hour, hands-on experience. This course covers: Accessing the IUIE; Navigating in IUIE; Working with Catalo more »
          • Excel 2013: Advanced Macros & User Defined Functions
            August 02 5:30pm
            This workshop lasts 3.5 hours, and is part of the certificate series Excel 2013 Advanced End-User  Macros combine a sequence of commands into a single action and user-defined functions are used to perform complex calculations that can be launched from a single function name. In this workshop, participan more »
          • IU Periodontic Alumni Board Meeting
            August 03 8:00pm
            For more information or to register for this event please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
          • Access 2013: Reports
            August 04 9:00am
            This workshop lasts 3 hours, and is part of the certificate series Access 2013 End-User Reports can provide attractive and organized ways to share data with others. This workshop is intended for anyone who is interested in learning how to create and enhance relational reports. Participants will also l more »
          Sunday, July 31, 2016