• Competition Pool
    December 15 11:00am
    Lap Swim more »
  • Mindfulness Meditation
    December 15 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 »
  • Marion County Swimming and Diving Championships
    December 15 4:00pm
    Swim meet hosted by Roncalli High School. more »
  • CLOSED
    December 16 12:00am
    Closed more »
  • Holiday Classic
    December 16 7:00am
    Columbus North Athletics sponsored swim meet. more »
Friday, December 15, 2017
    IU Calendar




    • Competition Pool
      December 15 11:00am
      Lap Swim more »
    • Mindfulness Meditation
      December 15 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 »
    • Marion County Swimming and Diving Championships
      December 15 4:00pm
      Swim meet hosted by Roncalli High School. more »
    • CLOSED
      December 16 12:00am
      Closed more »
    • Holiday Classic
      December 16 7:00am
      Columbus North Athletics sponsored swim meet. more »
    Friday, December 15, 2017
      IU Calendar




      • Competition Pool
        December 15 11:00am
        Lap Swim more »
      • Mindfulness Meditation
        December 15 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 »
      • Marion County Swimming and Diving Championships
        December 15 4:00pm
        Swim meet hosted by Roncalli High School. more »
      • CLOSED
        December 16 12:00am
        Closed more »
      • Holiday Classic
        December 16 7:00am
        Columbus North Athletics sponsored swim meet. more »
      Friday, December 15, 2017
        IU Calendar




        • Competition Pool
          December 15 11:00am
          Lap Swim more »
        • Mindfulness Meditation
          December 15 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 »
        • Marion County Swimming and Diving Championships
          December 15 4:00pm
          Swim meet hosted by Roncalli High School. more »
        • CLOSED
          December 16 12:00am
          Closed more »
        • Holiday Classic
          December 16 7:00am
          Columbus North Athletics sponsored swim meet. more »
        Friday, December 15, 2017

          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




          • Competition Pool
            December 15 11:00am
            Lap Swim more »
          • Mindfulness Meditation
            December 15 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 »
          • Marion County Swimming and Diving Championships
            December 15 4:00pm
            Swim meet hosted by Roncalli High School. more »
          • CLOSED
            December 16 12:00am
            Closed more »
          • Holiday Classic
            December 16 7:00am
            Columbus North Athletics sponsored swim meet. more »
          Friday, December 15, 2017