Skip Navigation LinksHome > Training > Professional Technical Education > Classes Offered

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