Excel 2007 - Level 2
;
Location:
Sydney
Melbourne
Brisbane
Perth
Date:
Choose a date...
06 Feb 12 - 06 Feb 12
17 Feb 12 - 17 Feb 12
27 Feb 12 - 27 Feb 12
21 Mar 12 - 21 Mar 12
27 Mar 12 - 27 Mar 12
02 Apr 12 - 02 Apr 12
18 Apr 12 - 18 Apr 12
20 Apr 12 - 20 Apr 12
30 Apr 12 - 30 Apr 12
02 May 12 - 02 May 12
16 May 12 - 16 May 12
22 May 12 - 22 May 12
31 May 12 - 31 May 12
06 Jun 12 - 06 Jun 12
12 Jun 12 - 12 Jun 12
28 Jun 12 - 28 Jun 12
{None}
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
9:00 AM - 5:00 PM
Duration: 1 Day
Price:
Print Preview |
Send to a friend
Learning Method:
Instructor Led
Overview:
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.
Target 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 take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
At Course Completion:
Upon successful completion of this course, students will be able to:
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.
Module 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
Module 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
Module 3: Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts
Module 4: Analyzing Data Using PivotTables and PivotCharts
Create a PivotTable Report
Analyze Data Using PivotCharts
Module 5: Inserting Graphic Objects
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects
Module 6: Customizing and Enhancing Workbooks and the Excel Environment
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates
Course Ratings Averaged from 7,138 responses. Instructor's Knowledge Training Quality Training Objectives Training Overall Courseware Quality
Extraordinary Great Good Average Poor
