• Competition Pool
    June 23 5:30am
    lap swim more »
  • Instructional Pool
    June 23 7:00am
    lap swim more »
  • Nanotechnology Experiences for Students and Teachers
    June 23 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 »
  • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
    June 23 9:00am
    This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
  • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
    June 23 9:00am
    This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
Friday, June 23, 2017
    IU Calendar




    • Competition Pool
      June 23 5:30am
      lap swim more »
    • Instructional Pool
      June 23 7:00am
      lap swim more »
    • Nanotechnology Experiences for Students and Teachers
      June 23 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 »
    • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
      June 23 9:00am
      This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
    • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
      June 23 9:00am
      This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
    Friday, June 23, 2017
      IU Calendar




      • Competition Pool
        June 23 5:30am
        lap swim more »
      • Instructional Pool
        June 23 7:00am
        lap swim more »
      • Nanotechnology Experiences for Students and Teachers
        June 23 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 »
      • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
        June 23 9:00am
        This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
      • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
        June 23 9:00am
        This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
      Friday, June 23, 2017
        IU Calendar




        • Competition Pool
          June 23 5:30am
          lap swim more »
        • Instructional Pool
          June 23 7:00am
          lap swim more »
        • Nanotechnology Experiences for Students and Teachers
          June 23 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 »
        • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
          June 23 9:00am
          This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
        • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
          June 23 9:00am
          This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
        Friday, June 23, 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




          • Competition Pool
            June 23 5:30am
            lap swim more »
          • Instructional Pool
            June 23 7:00am
            lap swim more »
          • Nanotechnology Experiences for Students and Teachers
            June 23 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 »
          • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
            June 23 9:00am
            This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
          • Installation, Storage and Compute with Windows Server 2016 (MOC 20740)
            June 23 9:00am
            This workshop lasts 5 days. This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, require more »
          Friday, June 23, 2017