MS Excel Level II, CMP958

Explore the new MS Excel 2007 environment to streamline and enhance work sheets with templates, charts, graphics, tables and formulas. Calculate data with advanced logic and lookup functions. Create and modify tables with Excel’s new Quick Style Sets. Manage table data by using sort and filter features and database functions. Create PivotTables to manipulate large amounts of data.  

Prerequisites: Working with Windows XP or Working with Vista. MS Excel--Level I or equivalent experience.

Textbook: Purchase at the Rockville Campus Bookstore and bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).

Classroom Hours: 10

Course Content

Lesson 1: Calculating Data with Advanced Formulas

Lesson 2: Organizing Worksheet and Table Data

Lesson 3: Presenting Data Using Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts

Lesson 5: Inserting Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment