• CLOSED
    June 27 12:00am
    pool closed more »
  • USA Swimming National Championships
    June 27 12:00am
    meet more »
  • USA Swimming National Championships and World Championship Trials
    June 27 6:00am
    Swim meet for National Championship and World Championship trials. more »
  • Competition Pool
    June 27 11:30am
    lap swim more »
  • Nanotechnology Experiences for Students and Teachers
    June 28 8:45am
    High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
Tuesday, June 27, 2017
    IU Calendar




    • CLOSED
      June 27 12:00am
      pool closed more »
    • USA Swimming National Championships
      June 27 12:00am
      meet more »
    • USA Swimming National Championships and World Championship Trials
      June 27 6:00am
      Swim meet for National Championship and World Championship trials. more »
    • Competition Pool
      June 27 11:30am
      lap swim more »
    • Nanotechnology Experiences for Students and Teachers
      June 28 8:45am
      High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
    Tuesday, June 27, 2017
      IU Calendar




      • CLOSED
        June 27 12:00am
        pool closed more »
      • USA Swimming National Championships
        June 27 12:00am
        meet more »
      • USA Swimming National Championships and World Championship Trials
        June 27 6:00am
        Swim meet for National Championship and World Championship trials. more »
      • Competition Pool
        June 27 11:30am
        lap swim more »
      • Nanotechnology Experiences for Students and Teachers
        June 28 8:45am
        High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
      Tuesday, June 27, 2017
        IU Calendar




        • CLOSED
          June 27 12:00am
          pool closed more »
        • USA Swimming National Championships
          June 27 12:00am
          meet more »
        • USA Swimming National Championships and World Championship Trials
          June 27 6:00am
          Swim meet for National Championship and World Championship trials. more »
        • Competition Pool
          June 27 11:30am
          lap swim more »
        • Nanotechnology Experiences for Students and Teachers
          June 28 8:45am
          High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
        Tuesday, June 27, 2017

          About This Event

          Summary

          Discover how pivot tables can make work tasks easier and how they can be useful in analyzing data. In this workshop, participants will learn how to create, format, and modify pivot tables, perform various summary techniques when displaying data, and how to create pivot charts. This workshop will also explore more advanced techniques such as how to group items in pivot tables and how to create calculated fields. The slicer tool will also be introduced.

           What you'll learn             

          •             create, modify, and format pivot tables

          •             use summary functions and customized calculations

          •             group numbers and dates

          •             create filters and slicers

          •             link and update pivot tables

          •             create pivot charts                         

          What you need to know              

          •             navigate an Excel spreadsheet

          •             create basic formulas

          •             work with subtotals

          •             sort and filter data

          •             work with tables

          •             manage named ranges 

          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
            June 27 12:00am
            pool closed more »
          • USA Swimming National Championships
            June 27 12:00am
            meet more »
          • USA Swimming National Championships and World Championship Trials
            June 27 6:00am
            Swim meet for National Championship and World Championship trials. more »
          • Competition Pool
            June 27 11:30am
            lap swim more »
          • Nanotechnology Experiences for Students and Teachers
            June 28 8:45am
            High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
          Tuesday, June 27, 2017