|
|
|
Course ID: 13892
| Course Duration: 1 Day
|
|
Course Dates:
|
| |
|
| |
Excel 2007 - Level 2 Training Class
Course ID: 13892
|
|
| |
|
|
| |
|
|
| |
Excel 2007 - Level 2 Training Seminar
In this course, students use Excel?? 2007 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats. (Second Edition)
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
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
Manage Themes
Create and Use Templates
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Excel 2007 - Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Excel 2007 - Level 2 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 13892
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
| | | | |
|