• Competition Pool
    May 26 5:30am
    Lap Swim more »
  • Mindfulness Meditation
    May 26 11:00am
    Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
  • CLOSED
    May 27 12:00am
    Closed more »
  • CLOSED
    May 28 12:00am
    The competition lap pool for lap swim is closed. more »
  • CLOSED - Memorial Day
    May 29 12:00am
    Closed more »
Friday, May 26, 2017
    IU Calendar




    • Competition Pool
      May 26 5:30am
      Lap Swim more »
    • Mindfulness Meditation
      May 26 11:00am
      Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
    • CLOSED
      May 27 12:00am
      Closed more »
    • CLOSED
      May 28 12:00am
      The competition lap pool for lap swim is closed. more »
    • CLOSED - Memorial Day
      May 29 12:00am
      Closed more »
    Friday, May 26, 2017
      IU Calendar




      • Competition Pool
        May 26 5:30am
        Lap Swim more »
      • Mindfulness Meditation
        May 26 11:00am
        Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
      • CLOSED
        May 27 12:00am
        Closed more »
      • CLOSED
        May 28 12:00am
        The competition lap pool for lap swim is closed. more »
      • CLOSED - Memorial Day
        May 29 12:00am
        Closed more »
      Friday, May 26, 2017
        IU Calendar




        • Competition Pool
          May 26 5:30am
          Lap Swim more »
        • Mindfulness Meditation
          May 26 11:00am
          Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
        • CLOSED
          May 27 12:00am
          Closed more »
        • CLOSED
          May 28 12:00am
          The competition lap pool for lap swim is closed. more »
        • CLOSED - Memorial Day
          May 29 12:00am
          Closed more »
        Friday, May 26, 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




          • Competition Pool
            May 26 5:30am
            Lap Swim more »
          • Mindfulness Meditation
            May 26 11:00am
            Feeling stressed and overwhelmed? Looking for an opportunity to practice self-care? Join us for guided mindfulness meditation. You don't have to be a CAPS client and no registration is needed. Student ID is required. more »
          • CLOSED
            May 27 12:00am
            Closed more »
          • CLOSED
            May 28 12:00am
            The competition lap pool for lap swim is closed. more »
          • CLOSED - Memorial Day
            May 29 12:00am
            Closed more »
          Friday, May 26, 2017