• IHSAA Boys' State
    February 25 12:00am
    swim meet more »
  • CLOSED
    February 25 12:00am
    Closed more »
  • Hans Op de Beeck | Staging Silence (2)
    February 25 10:00am
    In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
  • Freya Powell | Omniscience and Oblivion
    February 25 10:00am
    For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
  • SAPB Film: Fantastic Beasts and Where To Find Them
    February 25 3:00pm
    End your Saturday at the movies at 3 or 7PM in the IUPUI Campus Center! The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school (imdb.com). Free admission and popcorn with your Jagtag ID. Non-IUPUI guests are welcome as long as more »
Saturday, February 25, 2017
    IU Calendar




    • IHSAA Boys' State
      February 25 12:00am
      swim meet more »
    • CLOSED
      February 25 12:00am
      Closed more »
    • Hans Op de Beeck | Staging Silence (2)
      February 25 10:00am
      In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
    • Freya Powell | Omniscience and Oblivion
      February 25 10:00am
      For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
    • SAPB Film: Fantastic Beasts and Where To Find Them
      February 25 3:00pm
      End your Saturday at the movies at 3 or 7PM in the IUPUI Campus Center! The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school (imdb.com). Free admission and popcorn with your Jagtag ID. Non-IUPUI guests are welcome as long as more »
    Saturday, February 25, 2017
      IU Calendar




      • IHSAA Boys' State
        February 25 12:00am
        swim meet more »
      • CLOSED
        February 25 12:00am
        Closed more »
      • Hans Op de Beeck | Staging Silence (2)
        February 25 10:00am
        In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
      • Freya Powell | Omniscience and Oblivion
        February 25 10:00am
        For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
      • SAPB Film: Fantastic Beasts and Where To Find Them
        February 25 3:00pm
        End your Saturday at the movies at 3 or 7PM in the IUPUI Campus Center! The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school (imdb.com). Free admission and popcorn with your Jagtag ID. Non-IUPUI guests are welcome as long as more »
      Saturday, February 25, 2017
        IU Calendar




        • IHSAA Boys' State
          February 25 12:00am
          swim meet more »
        • CLOSED
          February 25 12:00am
          Closed more »
        • Hans Op de Beeck | Staging Silence (2)
          February 25 10:00am
          In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
        • Freya Powell | Omniscience and Oblivion
          February 25 10:00am
          For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
        • SAPB Film: Fantastic Beasts and Where To Find Them
          February 25 3:00pm
          End your Saturday at the movies at 3 or 7PM in the IUPUI Campus Center! The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school (imdb.com). Free admission and popcorn with your Jagtag ID. Non-IUPUI guests are welcome as long as more »
        Saturday, February 25, 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




          • IHSAA Boys' State
            February 25 12:00am
            swim meet more »
          • CLOSED
            February 25 12:00am
            Closed more »
          • Hans Op de Beeck | Staging Silence (2)
            February 25 10:00am
            In Belgian artist Hans Op de Beeck's film, the real and the imaginary fuse as anonymous hands assemble miniature dioramas of timeless, dreamlike settings. more »
          • Freya Powell | Omniscience and Oblivion
            February 25 10:00am
            For this sound installation, New York-based artist Freya Powell created an audio archive where participants were invited to anonymously share one memory they would like to keep forever and one they would like to let go. more »
          • SAPB Film: Fantastic Beasts and Where To Find Them
            February 25 3:00pm
            End your Saturday at the movies at 3 or 7PM in the IUPUI Campus Center! The adventures of writer Newt Scamander in New York's secret community of witches and wizards seventy years before Harry Potter reads his book in school (imdb.com). Free admission and popcorn with your Jagtag ID. Non-IUPUI guests are welcome as long as more »
          Saturday, February 25, 2017