Skip Navigation LinksHome > Training > Technology Training > Class Catalog

Excel 2010: Intermediate

In this course, students will use Excel 2010 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Course Outline

Calculating Data with Advanced Formulas
Manage Cell and Range Names
Calculate Data across Worksheets
Use Specialized Functions
Use Logical and Lookup Functions

Organizing Worksheet and Table Data
Create and Modify Tables
Format Tables
Sort or Filter Worksheet Data

Presenting Data Using Charts
Create, modify and format charts

Inserting Graphic Objects
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Insert SmartArt Graphics
Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment
Customize the Excel Environment
Manage Comments and Hyperlinks
Adding Watermarks
Create and Use Templates
Bring the DoIT Technology Training postcard you received in your campus mailbox to one of our training classes and receive 50% off the listed price of the next class you sign up for. This offer is good for one discounted class per person and must be redeemed by September 4, 2015. Please see the list of eligible classes and email us at pte@doit.wisc.edu for more information.