Description: This hands-on course is designed to introduce students to several features of Microsoft Excel. Students will learn to use outlines, templates and custom formats. Data management will be discussed in detail to include filtering lists and using autofilter. Additional topics covered are charting and linking. It is recommended that students have basic skills in Excel and have experience using Windows.

Objective: This course will provide students with an expanded understanding of the functions and capabilities of Microsoft Excel.

Course Content:

Managing Worksheets

Working with Outlines

Using Paste Special

Using Range Names

Working with Labels in Formulas

Managing Data

Working with Databases

Working with the Data Form

Using AutoFilter

Working with Advanced Filters

Working with Data Series

Using AutoFormat and Styles

Using Conditional and Custom Formats

Using Templates

Advanced Charts

Using HTML Files

Using Additional Effects and Objects

Using Auto Shapes and Diagrams