Microsoft Excel 2007 Level 2
Enhancing Workbooks
Customize the Excel Environment
Customize an Excel Worksheet
Enhance Worksheets Using Themes
Work with Comments
Access External Resources Using Hyperlinks
Use Web-Based Research Tools
Creating Workbooks Using Templates
Create a Workbook from a Template
Create a Custom Template
Organizing Data Using Tables
Create Tables
Modify Tables
Format Tables
Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts
Create a Chart Template
Share Excel Charts
Analyzing Data Using PivotTables and PivotCharts
Create a PivotTable
Perform Calculations Using PivotTables
Analyze Data Using PivotCharts
Enhancing Visual Appeal Using Graphic Objects
Insert Graphics
Modify Graphic Objects
Emphasize an Area of a Worksheet
Illustrate Workflow Using SmartArt Graphics
Format Graphic Objects
Change the Order of Layered Graphic Objects
Group Graphic Objects
Organize Graphic Objects
Calculating Data with Advanced Formulas
Refer to a Range of Cells
Calculate Data Across Worksheets
Perform Date and Time Calculations
Format Text Using Formulas
Perform Numeric Calculations
Calculate Data with Lookup & Reference Functions
Perform Logical Analysis
Print Formulas
Sorting and Filtering Data
Sort Data in a Spreadsheet
Filter Data in a Spreadsheet
Calculate Large Volumes of Data
Add Subtotals to a Worksheet
Class Information
Duration: 1 day
Prerequisite: Microsoft Excel 2007 Level 1 or equivalent experience.
Course Materials: Course manual (084282S3)
Description: In this course, students will use Microsoft® Office Excel® 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.