Excel 2007 - Level 2 Training Course
Course ID: 230795
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)
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
Or fill out the information as a first time user:
|
|
Live Instructor-led Excel 2007 - Level 2 Training Dates
|
Filter By...
| Location: |
|
Date Range: |
|
to |
|
| Location |
Date |
Type |
Duration |
Price |
254 course(s) |
|
05/24/13
C
7.5 hours(s)
$275.00
05/30/13
V
8 hours(s)
$275.00
05/30/13
V
8 hours(s)
$275.00
05/30/13
V
8 hours(s)
$275.00
05/30/13
V
8 hours(s)
$275.00
05/30/13
C
7.5 hours(s)
$275.00
05/31/13
C
1 day(s)
$275.00
05/31/13
C
7.5 hour(s)
$275.00
05/31/13
C
7.5 hours(s)
$260.00
06/03/13
C
1 day(s)
$275.00
06/03/13
C
1 day(s)
$275.00
06/03/13
C
1 day(s)
$275.00
06/03/13
C
1 day(s)
$275.00
06/03/13
C
1 day(s)
$275.00
06/03/13
C
1 day(s)
$275.00
06/03/13
C
8 hours(s)
$275.00
06/03/13
C
1 day(s)
$275.00
06/03/13
V
7.5 hours(s)
$199.00
06/05/13
C
1 day(s)
$275.00
06/05/13
C
8 hours(s)
$275.00
06/05/13
C
1 day(s)
$275.00
06/05/13
C
8 hours(s)
$275.00
06/05/13
C
1 day(s)
$275.00
06/07/13
C
1 day(s)
$295.00
06/07/13
V
1 day(s)
$295.00
06/07/13
V
1 day(s)
$295.00
06/07/13
V
1 day(s)
$295.00
06/07/13
V
1 day(s)
$295.00
06/07/13
V
1 day(s)
$295.00
06/07/13
C
7.5 hours(s)
$275.00
06/10/13
C
1 day(s)
$245.00
06/10/13
C
8 hours(s)
$245.00
06/10/13
V
8 hours(s)
$270.00
06/10/13
C
8 hours(s)
$270.00
06/11/13
C
1 day(s)
$275.00
06/11/13
C
1 day(s)
$275.00
06/11/13
C
1 day(s)
$275.00
06/11/13
C
1 day(s)
$275.00
06/11/13
C
1 day(s)
$275.00
06/11/13
C
1 day(s)
$275.00
06/11/13
V
8 hours(s)
$275.00
06/11/13
V
8 hours(s)
$275.00
06/11/13
V
8 hours(s)
$275.00
06/11/13
C
8 hours(s)
$275.00
06/11/13
C
1 day(s)
$275.00
06/11/13
C
1 day(s)
$275.00
06/11/13
C
8 hours(s)
$275.00
06/11/13
C
8 hours(s)
$275.00
06/11/13
C
8 hours(s)
$275.00
06/11/13
C
8 hours(s)
$250.00
Online Self-Paced Excel 2007 - Level 2 Training Options
|
No online results
|