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 Objectives:
- Calculate with advanced formulas
- Organize worksheet and table data using various techniques
- Create and modify charts
- Analyze data using PivotTables and PivotCharts
- Insert graphic objects
- Customize and enhance workbooks and the Microsoft Office Excel environment
Course Content
Lesson 1: Calculating Data with Advanced Formulas
- Manage Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort or Filter Worksheet or Table Data
- Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
Lesson 4: Analyzing Data Using PivotTables and PivotCharts
- Create a PivotTable Report
- Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
- Insert and Modify Pictures and ClipArt
- Draw and Modify Shapes
- Illustrate Workflow Using SmartArt Graphics
- Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment
- Customize the Excel Environment
- Customize Workbooks
- Man gage Themes
- Create and Use Templates