• CLOSED
    November 18 12:00am
    Closed more »
  • House of Champions
    November 18 12:00am
    swim meet more »
  • IUPUI Annual Culture Show presented by the International Club
    November 18 6:00pm
    International Club has been hosting its annual International Culture Show for the past five years. This event gives students the opportunity to showcase their culture in a creative manner through music, dance or drama to bring you a sense of adventure as the performance takes you through a journey to explore various cultures through dance, more »
  • CLOSED
    November 19 12:00am
    The competition lap pool for lap swim is closed. more »
  • PPG 2017 Symposium
    November 19 8:00am
    PPG 2017 Symposium sponsored by the Cardiac Developmental Biology/Wells Center more »
Saturday, November 18, 2017
    IU Calendar




    • CLOSED
      November 18 12:00am
      Closed more »
    • House of Champions
      November 18 12:00am
      swim meet more »
    • IUPUI Annual Culture Show presented by the International Club
      November 18 6:00pm
      International Club has been hosting its annual International Culture Show for the past five years. This event gives students the opportunity to showcase their culture in a creative manner through music, dance or drama to bring you a sense of adventure as the performance takes you through a journey to explore various cultures through dance, more »
    • CLOSED
      November 19 12:00am
      The competition lap pool for lap swim is closed. more »
    • PPG 2017 Symposium
      November 19 8:00am
      PPG 2017 Symposium sponsored by the Cardiac Developmental Biology/Wells Center more »
    Saturday, November 18, 2017
      IU Calendar




      • CLOSED
        November 18 12:00am
        Closed more »
      • House of Champions
        November 18 12:00am
        swim meet more »
      • IUPUI Annual Culture Show presented by the International Club
        November 18 6:00pm
        International Club has been hosting its annual International Culture Show for the past five years. This event gives students the opportunity to showcase their culture in a creative manner through music, dance or drama to bring you a sense of adventure as the performance takes you through a journey to explore various cultures through dance, more »
      • CLOSED
        November 19 12:00am
        The competition lap pool for lap swim is closed. more »
      • PPG 2017 Symposium
        November 19 8:00am
        PPG 2017 Symposium sponsored by the Cardiac Developmental Biology/Wells Center more »
      Saturday, November 18, 2017
        IU Calendar




        • CLOSED
          November 18 12:00am
          Closed more »
        • House of Champions
          November 18 12:00am
          swim meet more »
        • IUPUI Annual Culture Show presented by the International Club
          November 18 6:00pm
          International Club has been hosting its annual International Culture Show for the past five years. This event gives students the opportunity to showcase their culture in a creative manner through music, dance or drama to bring you a sense of adventure as the performance takes you through a journey to explore various cultures through dance, more »
        • CLOSED
          November 19 12:00am
          The competition lap pool for lap swim is closed. more »
        • PPG 2017 Symposium
          November 19 8:00am
          PPG 2017 Symposium sponsored by the Cardiac Developmental Biology/Wells Center more »
        Saturday, November 18, 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




          • CLOSED
            November 18 12:00am
            Closed more »
          • House of Champions
            November 18 12:00am
            swim meet more »
          • IUPUI Annual Culture Show presented by the International Club
            November 18 6:00pm
            International Club has been hosting its annual International Culture Show for the past five years. This event gives students the opportunity to showcase their culture in a creative manner through music, dance or drama to bring you a sense of adventure as the performance takes you through a journey to explore various cultures through dance, more »
          • CLOSED
            November 19 12:00am
            The competition lap pool for lap swim is closed. more »
          • PPG 2017 Symposium
            November 19 8:00am
            PPG 2017 Symposium sponsored by the Cardiac Developmental Biology/Wells Center more »
          Saturday, November 18, 2017