Excel 2007 - Level 2
Overview:
Learn additional important skills such as creating charts and graphics, using advanced formulas to perform calculations, and sorting and filtering data using Excel in Microsoft Office 2007.
Pre-requisite(s):
Excel Level 1
Audience:
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Length/Cost:
1 Day, $235
Outline:
|
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
|
Schedule:
 = "Guaranteed to Run" |
|
ILT - Instructor-Led Training | MLT - Mentor-Led Training | OC - Online Classroom Learning |
| Location | | Register | Time |
|
Bellevue (ILT)
|
|
Oct 05
| 8:00AM-4:00PM |
|
Seattle (ILT)
|
|
Oct 28
| 8:00AM-4:00PM |
|
Bellevue (ILT)
|
|
Nov 17
| 8:00AM-4:00PM |
|
Seattle (ILT)
|
|
Dec 16
| 8:00AM-4:00PM |
|