Excel 2007: Intermediate

Learning Outcomes:

• Given the information provided in the Lesson Lab, successfully create an inventory list from an online template.
• Utilizing a set of instructions provided, accurately create and format a bar chart.
• Using a set of criteria, use functions such as Date & Time, Lookup & Reference, and Statistical to correctly calculate quarterly grades and cumulative totals.
• Utilizing a specific scenario, effectively use PivotTable to create a report.

This course is designed for persons preparing for certification as an MOS in Excel. Apply visual elements and advanced formulas to a worksheet to display data in various formats.

• Creating Data with Advanced Formulas
• Organizing Worksheet and Table Data
• Presenting Data Using Charts
• Analyzing Data Using PivotTables and PivotCharts
• Inserting Graphic Objects
• Customizing and Enhancing Workbooks and the Excel Environment

Excel 2007: Intermediate

Upon successful completion of this course, students will be able to: Manage cell and range names, calculate data across worksheets, use specialized functions and analyze data with logical and lookup functions. Create and modify tables, format tables, sort or filter worksheet or table date and calculate data in a table of worksheet. Create, modify and format charts. Create a PivotTable report and analyze data using PivotCharts. Insert and modify pictures and ClipArt. Draw and modify shapes. Illustrate workflow using SmartArt graphics and layer and group graphic objects. Customize the excel environment and workbooks. Manage themes. Create and use templates.

Class targeted to: Students with basic knowledge of Excel and who has experience creating worksheets and charts but need the additional benefits this class provides.

Prerequisites: Windows: Introduction and Excel 2007: Introduction.