• Chinese Culture Summer Camp
    July 24 7:30am
    This program is for young Chinese language learners to better prepare them for taking on the task of another language.  The Confucius Institute in Indianapolis is one of the sponsors. more »
  • Competition Pool
    July 25 5:30am
    lap swim more »
  • Instructional Pool
    July 25 7:00am
    lap swim more »
  • Competition Pool
    July 25 9:00am
    lap swim  more »
  • GetSet Luncheon
    July 26 11:00am
    A partnership luncheon with the Division of Undergraduate Education and GetSet. more »
Monday, July 24, 2017
    IU Calendar




    • Chinese Culture Summer Camp
      July 24 7:30am
      This program is for young Chinese language learners to better prepare them for taking on the task of another language.  The Confucius Institute in Indianapolis is one of the sponsors. more »
    • Competition Pool
      July 25 5:30am
      lap swim more »
    • Instructional Pool
      July 25 7:00am
      lap swim more »
    • Competition Pool
      July 25 9:00am
      lap swim  more »
    • GetSet Luncheon
      July 26 11:00am
      A partnership luncheon with the Division of Undergraduate Education and GetSet. more »
    Monday, July 24, 2017
      IU Calendar




      • Chinese Culture Summer Camp
        July 24 7:30am
        This program is for young Chinese language learners to better prepare them for taking on the task of another language.  The Confucius Institute in Indianapolis is one of the sponsors. more »
      • Competition Pool
        July 25 5:30am
        lap swim more »
      • Instructional Pool
        July 25 7:00am
        lap swim more »
      • Competition Pool
        July 25 9:00am
        lap swim  more »
      • GetSet Luncheon
        July 26 11:00am
        A partnership luncheon with the Division of Undergraduate Education and GetSet. more »
      Monday, July 24, 2017
        IU Calendar




        • Chinese Culture Summer Camp
          July 24 7:30am
          This program is for young Chinese language learners to better prepare them for taking on the task of another language.  The Confucius Institute in Indianapolis is one of the sponsors. more »
        • Competition Pool
          July 25 5:30am
          lap swim more »
        • Instructional Pool
          July 25 7:00am
          lap swim more »
        • Competition Pool
          July 25 9:00am
          lap swim  more »
        • GetSet Luncheon
          July 26 11:00am
          A partnership luncheon with the Division of Undergraduate Education and GetSet. more »
        Monday, July 24, 2017

          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




          • Chinese Culture Summer Camp
            July 24 7:30am
            This program is for young Chinese language learners to better prepare them for taking on the task of another language.  The Confucius Institute in Indianapolis is one of the sponsors. more »
          • Competition Pool
            July 25 5:30am
            lap swim more »
          • Instructional Pool
            July 25 7:00am
            lap swim more »
          • Competition Pool
            July 25 9:00am
            lap swim  more »
          • GetSet Luncheon
            July 26 11:00am
            A partnership luncheon with the Division of Undergraduate Education and GetSet. more »
          Monday, July 24, 2017