• Housing Move-In
    August 18 8:00am
    Students will be moving their items into campus housing for the 2017-2018 academic year.  There will be student volunteers to assist. more »
  • CLOSED
    August 19 12:00am
    Closed more »
  • Lecture-Seminar Hari Nakshatri
    August 19 9:00am
    Hari Nakshatri, PhD, Director of Education is giving a seminar to med students and researchers regarding breast cancer research. more »
  • IU School of Public Health Alumni Board Meeting
    August 19 4:30pm
    For additional information, please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
  • 2017 IUPUI and IU Symphony on the Prairie
    August 19 6:00pm
    Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
Friday, August 18, 2017
    IU Calendar




    • Housing Move-In
      August 18 8:00am
      Students will be moving their items into campus housing for the 2017-2018 academic year.  There will be student volunteers to assist. more »
    • CLOSED
      August 19 12:00am
      Closed more »
    • Lecture-Seminar Hari Nakshatri
      August 19 9:00am
      Hari Nakshatri, PhD, Director of Education is giving a seminar to med students and researchers regarding breast cancer research. more »
    • IU School of Public Health Alumni Board Meeting
      August 19 4:30pm
      For additional information, please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
    • 2017 IUPUI and IU Symphony on the Prairie
      August 19 6:00pm
      Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
    Friday, August 18, 2017
      IU Calendar




      • Housing Move-In
        August 18 8:00am
        Students will be moving their items into campus housing for the 2017-2018 academic year.  There will be student volunteers to assist. more »
      • CLOSED
        August 19 12:00am
        Closed more »
      • Lecture-Seminar Hari Nakshatri
        August 19 9:00am
        Hari Nakshatri, PhD, Director of Education is giving a seminar to med students and researchers regarding breast cancer research. more »
      • IU School of Public Health Alumni Board Meeting
        August 19 4:30pm
        For additional information, please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
      • 2017 IUPUI and IU Symphony on the Prairie
        August 19 6:00pm
        Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
      Friday, August 18, 2017
        IU Calendar




        • Housing Move-In
          August 18 8:00am
          Students will be moving their items into campus housing for the 2017-2018 academic year.  There will be student volunteers to assist. more »
        • CLOSED
          August 19 12:00am
          Closed more »
        • Lecture-Seminar Hari Nakshatri
          August 19 9:00am
          Hari Nakshatri, PhD, Director of Education is giving a seminar to med students and researchers regarding breast cancer research. more »
        • IU School of Public Health Alumni Board Meeting
          August 19 4:30pm
          For additional information, please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
        • 2017 IUPUI and IU Symphony on the Prairie
          August 19 6:00pm
          Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
        Friday, August 18, 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




          • Housing Move-In
            August 18 8:00am
            Students will be moving their items into campus housing for the 2017-2018 academic year.  There will be student volunteers to assist. more »
          • CLOSED
            August 19 12:00am
            Closed more »
          • Lecture-Seminar Hari Nakshatri
            August 19 9:00am
            Hari Nakshatri, PhD, Director of Education is giving a seminar to med students and researchers regarding breast cancer research. more »
          • IU School of Public Health Alumni Board Meeting
            August 19 4:30pm
            For additional information, please contact Karen Jones at kdeery@iupui.edu or 317-274-8959. more »
          • 2017 IUPUI and IU Symphony on the Prairie
            August 19 6:00pm
            Summer in Indianapolis isn't complete without an alumni trip to Symphony on the Prairie. Join other IUPUI and IU alumni from across Central Indiana on August 19 for the music of Fleetwood Mac. The Central Indiana Chapter of the IU Alumni Association will again host a wine tasting with proceeds benefiting the Diabetes Youth Foundation of Indi more »
          Friday, August 18, 2017