IT Training & Education
View Workshop Charges and Policies
Intended for participants who are considering upgrading to Excel 2007 and want to learn more about it, and for experienced Excel users who simply need to learn how to navigate in the new interface and take advantage of the new features. In this workshop, participants will be introduced to the new Excel 2007 interface and learn how to use some its new features. Compatibility issues and file formats will also be discussed. (read the full description)
Currently there are no scheduled offerings of this workshop in Bloomington. You can, however, order these materials for self-study.
Currently there are no scheduled offerings of this workshop in Indianapolis. You can, however, order these materials for self-study.
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 formulas and functions, and creating a simple chart. Formatting a worksheet, importing data, and exploring Excel templates are also covered. Although this workshop is intended for the spreadsheet novice, participants with some previous spreadsheet experience may gain a better understanding and learn some new tricks to increase their efficiency in using Excel. (read the full description)
This workshop will help participants develop skills required to create effective and accurate charts. Intended for those already comfortable with using Excel, participants will create various types of charts and apply elements and formats. Chart templates and SmartArt graphics will be covered. This workshop also covers how to insert charts into PowerPoint slides. (read the full description)
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. This workshop also introduces pivot tables and pivot charts. (read the full description)
Macros enable Excel users to automate their work by recording a sequence of commands into a single action. In this workshop, participants will explore how to record and edit macros in Excel 2007, how to make them easily available, and how to share their recorded macros with other Excel users. (read the full description)
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, and perform various summary techniques when displaying data. This workshop will also explore more advanced techniques such as how to group items in pivot tables and how to create calculated fields. Pivot charts will also be covered. (read the full description)
This workshop will explore arrays and conditional functions used to summarize or count data with certain criteria. Discover how to use IF and Nested IF functions to test for specific conditions and how to apply different types of conditional formats. Participants will also explore various techniques to look up values in a range of data using VLOOKUP. Challenge exercises will be provided for reinforcement. (read the full description)
This workshop introduces a number of tools that will allow participants to develop what-if models or predict future trends in Excel. Discover how to analyze complex data by using data tables, Goal Seek, and Solver. Participants will use the Scenario Manager feature, which makes automating what-if models easy by storing and comparing named data scenarios. Summary reports will be generated to see the effects of these various combinations of values. (read the full description)
Macros combine a sequence of commands into a single action and user-defined functions are used to perform complex calculations that can be launched from a single function name. In this workshop, participants will learn how to use advanced macro capabilities to automate complex workflows and how to write and assign user-defined functions. Participants will incorporate decision making logic and repeating actions into their macros and add to Excel’s default function library by creating their own functions. (read the full description)
While Excel’s statistics capabilities are not as refined as those of dedicated statistics applications like SPSS, it can be used to perform many common statistical analyses. This workshop is intended for participants who are already comfortable using Excel and who have a familiarity with statistical concepts and terminology, and would like to learn how to perform statistical analyses in Excel. Participants will learn how to perform a variety of statistical procedures in Excel using the function wizard and add-in modules, and how to interpret the results. (read the full description)
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.
Note: This workshop was previously entitled: "Excel: Reporting for IUIE Users" and teaches IU staff members how to format and analyze data in Excel instead of how to extract and manipulate data from the IUIE.
