• Competition Pool
    December 08 5:30am
    Lap Swim more »
  • CyberSec First Responder: Threat Detection and Response
    December 08 9:00am
    This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
  • Al-Mutanabbi Street Starts Here
    December 08 10:00am
    A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
  • Undergraduate Student Exhibition
    December 08 10:00am
    The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
  • Stress Busters
    December 08 11:00am
    Students, join us the week before finals in December for Stress Busters Week! The Health and Wellness Peer Educators will offer various activities during the week such adult coloring, make your own stress balls, games, puzzles, and more!  more »
Wednesday, December 7, 2016
    IU Calendar




    • Competition Pool
      December 08 5:30am
      Lap Swim more »
    • CyberSec First Responder: Threat Detection and Response
      December 08 9:00am
      This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
    • Al-Mutanabbi Street Starts Here
      December 08 10:00am
      A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
    • Undergraduate Student Exhibition
      December 08 10:00am
      The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
    • Stress Busters
      December 08 11:00am
      Students, join us the week before finals in December for Stress Busters Week! The Health and Wellness Peer Educators will offer various activities during the week such adult coloring, make your own stress balls, games, puzzles, and more!  more »
    Wednesday, December 7, 2016
      IU Calendar




      • Competition Pool
        December 08 5:30am
        Lap Swim more »
      • CyberSec First Responder: Threat Detection and Response
        December 08 9:00am
        This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
      • Al-Mutanabbi Street Starts Here
        December 08 10:00am
        A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
      • Undergraduate Student Exhibition
        December 08 10:00am
        The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
      • Stress Busters
        December 08 11:00am
        Students, join us the week before finals in December for Stress Busters Week! The Health and Wellness Peer Educators will offer various activities during the week such adult coloring, make your own stress balls, games, puzzles, and more!  more »
      Wednesday, December 7, 2016
        IU Calendar




        • Competition Pool
          December 08 5:30am
          Lap Swim more »
        • CyberSec First Responder: Threat Detection and Response
          December 08 9:00am
          This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
        • Al-Mutanabbi Street Starts Here
          December 08 10:00am
          A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
        • Undergraduate Student Exhibition
          December 08 10:00am
          The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
        • Stress Busters
          December 08 11:00am
          Students, join us the week before finals in December for Stress Busters Week! The Health and Wellness Peer Educators will offer various activities during the week such adult coloring, make your own stress balls, games, puzzles, and more!  more »
        Wednesday, December 7, 2016

          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
            December 08 5:30am
            Lap Swim more »
          • CyberSec First Responder: Threat Detection and Response
            December 08 9:00am
            This workshop lasts 5 days. Overview: This course covers the duties of those who are responsible for monitoring and detecting security incidents in information systems and networks, and for executing a proper response to such incidents. Depending on the size of the organization, this individual more »
          • Al-Mutanabbi Street Starts Here
            December 08 10:00am
            A car bomb exploded in 2007 in the historic intellectual center of Baghdad, al-Mutanabbi Street. More than 130 people died or were wounded, but the place escaped geographic bounds to become a global movement for the free exchange of ideas. View selections from a rare collection of artist's books and broadsides that continue to be generated a more »
          • Undergraduate Student Exhibition
            December 08 10:00am
            The Undergraduate Student Exhibition is juried by Liz Garvey of Simon Garvey Art Access Gallery in New York. Works are typically selected from hundreds of submission across a wide variety of media. more »
          • Stress Busters
            December 08 11:00am
            Students, join us the week before finals in December for Stress Busters Week! The Health and Wellness Peer Educators will offer various activities during the week such adult coloring, make your own stress balls, games, puzzles, and more!  more »
          Wednesday, December 7, 2016