• Cascade Server: Managing Content
    February 15 1:30pm
    This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
  • Fair Labor Standards Act Legal Compliance Training
    February 16 9:00am
    Course Overview: The Fair Labor Standards Act Legal Compliance Course is designed to provide information on how to uniformly administer the various requirements under the FLSA. Learning Objectives: • Know how to comply with minimum wage requirements • Understand how overtime rules are applied • Identify the differe more »
  • SIS Basics for Administrators
    February 16 1:30pm
    University Employees Only This workshop lasts 3 hours. This course covers: How to login via OneStart; basic SIS Navigation; basic academic structure; review of FERPA and Service Indicators; and Bio/Demo Data. more »
  • Excel 2013: The Basics
    February 16 1:30pm
    This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity and Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with common f more »
  • HTML5 & CSS: Creating Style for the Web
    February 17 1:30pm
    This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Round-out your HTML5 & CSS knowledge by learning more techniques for creating style for a web page. This workshop will teach how to refine table structure, embed video, use non-standard fonts in your site using Web F more »
Sunday, February 14, 2016
    IU Calendar




    • Cascade Server: Managing Content
      February 15 1:30pm
      This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
    • Fair Labor Standards Act Legal Compliance Training
      February 16 9:00am
      Course Overview: The Fair Labor Standards Act Legal Compliance Course is designed to provide information on how to uniformly administer the various requirements under the FLSA. Learning Objectives: • Know how to comply with minimum wage requirements • Understand how overtime rules are applied • Identify the differe more »
    • SIS Basics for Administrators
      February 16 1:30pm
      University Employees Only This workshop lasts 3 hours. This course covers: How to login via OneStart; basic SIS Navigation; basic academic structure; review of FERPA and Service Indicators; and Bio/Demo Data. more »
    • Excel 2013: The Basics
      February 16 1:30pm
      This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity and Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with common f more »
    • HTML5 & CSS: Creating Style for the Web
      February 17 1:30pm
      This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Round-out your HTML5 & CSS knowledge by learning more techniques for creating style for a web page. This workshop will teach how to refine table structure, embed video, use non-standard fonts in your site using Web F more »
    Sunday, February 14, 2016
      IU Calendar




      • Cascade Server: Managing Content
        February 15 1:30pm
        This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
      • Fair Labor Standards Act Legal Compliance Training
        February 16 9:00am
        Course Overview: The Fair Labor Standards Act Legal Compliance Course is designed to provide information on how to uniformly administer the various requirements under the FLSA. Learning Objectives: • Know how to comply with minimum wage requirements • Understand how overtime rules are applied • Identify the differe more »
      • SIS Basics for Administrators
        February 16 1:30pm
        University Employees Only This workshop lasts 3 hours. This course covers: How to login via OneStart; basic SIS Navigation; basic academic structure; review of FERPA and Service Indicators; and Bio/Demo Data. more »
      • Excel 2013: The Basics
        February 16 1:30pm
        This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity and Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with common f more »
      • HTML5 & CSS: Creating Style for the Web
        February 17 1:30pm
        This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Round-out your HTML5 & CSS knowledge by learning more techniques for creating style for a web page. This workshop will teach how to refine table structure, embed video, use non-standard fonts in your site using Web F more »
      Sunday, February 14, 2016
        IU Calendar




        • Cascade Server: Managing Content
          February 15 1:30pm
          This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
        • Fair Labor Standards Act Legal Compliance Training
          February 16 9:00am
          Course Overview: The Fair Labor Standards Act Legal Compliance Course is designed to provide information on how to uniformly administer the various requirements under the FLSA. Learning Objectives: • Know how to comply with minimum wage requirements • Understand how overtime rules are applied • Identify the differe more »
        • SIS Basics for Administrators
          February 16 1:30pm
          University Employees Only This workshop lasts 3 hours. This course covers: How to login via OneStart; basic SIS Navigation; basic academic structure; review of FERPA and Service Indicators; and Bio/Demo Data. more »
        • Excel 2013: The Basics
          February 16 1:30pm
          This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity and Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with common f more »
        • HTML5 & CSS: Creating Style for the Web
          February 17 1:30pm
          This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Round-out your HTML5 & CSS knowledge by learning more techniques for creating style for a web page. This workshop will teach how to refine table structure, embed video, use non-standard fonts in your site using Web F more »
        Sunday, February 14, 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




          • Cascade Server: Managing Content
            February 15 1:30pm
            This workshop lasts 3 hours. Cascade Server: Managing Content will teach users how to manage content in IU’s WCMS, Cascade Server. Users will be provided a demonstration site, demonstration username and passphrase, and will be guided through tasks focused on the skills needed to create and edit conte more »
          • Fair Labor Standards Act Legal Compliance Training
            February 16 9:00am
            Course Overview: The Fair Labor Standards Act Legal Compliance Course is designed to provide information on how to uniformly administer the various requirements under the FLSA. Learning Objectives: • Know how to comply with minimum wage requirements • Understand how overtime rules are applied • Identify the differe more »
          • SIS Basics for Administrators
            February 16 1:30pm
            University Employees Only This workshop lasts 3 hours. This course covers: How to login via OneStart; basic SIS Navigation; basic academic structure; review of FERPA and Service Indicators; and Bio/Demo Data. more »
          • Excel 2013: The Basics
            February 16 1:30pm
            This workshop lasts 3 hours, and is part of the following certificates series: Office 2013 Productivity and Excel 2013 End-User Excel is the most-used spreadsheet and analysis application today. This workshop introduces basic Excel features such as entering various types of data, working with common f more »
          • HTML5 & CSS: Creating Style for the Web
            February 17 1:30pm
            This workshop lasts 3.5 hours, and is part of the certificate series Web Creation Round-out your HTML5 & CSS knowledge by learning more techniques for creating style for a web page. This workshop will teach how to refine table structure, embed video, use non-standard fonts in your site using Web F more »
          Sunday, February 14, 2016