Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab
 

About This Event

Summary

This workshop is specifically designed for any IU staff member who uses Excel to format IUIE data. Participants will learn how to format text and numeric data, create and remove subtotals, convert data to a table, sort and filter data, automate work using macros, and analyze data using pivot tables.

It is recommended that IU staff take the IUIE Reporting Basics workshop or at least have some experience using the IUIE environment before taking this Excel workshop.

What you'll learn:            

    format text and numeric data

    use macros to automate tasks

    use AVERAGE, COUNTIF, and VLOOKUP functions

    create and remove subtotals

    convert data to a table and work with table features

    sort and filter data

    analyze data using pivot tables

 What you need to know:

    navigate an Excel spreadsheet

    switch back and forth between Windows applications

    enter and edit data

    work with basic formulas and functions

    save and print a worksheet

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.