Excel 2007 Intermediate Course Contents

Hover over the content header to see more details

Click to view Course Contents as PDF file

Basic Functions

SUM, COUNT, COUNTA, AVERAGE, MAX, MIN, ROUND
Auto functions
ROUND function
Function Library
Insert Function Wizard

Relative and Absolute Formulae

Relative and absolute references
What If Analysis

Range Names

Scope
Create Name Methods
Name Manager
Edit Range Names
Delete Range Names
Range Names in Formulas
Define Variables

Logical and lookup functions

Testing Conditions in Cells
IF, COUNTIF, SUMIF, VLOOKUP

Introduction to Charts

Composition of Charts
Methods of Display
Create a chart
Edit a chart
Delete an embedded chart
Create multiple embedded charts
Place a chart on a chart sheet
Place multiple charts on a chart sheet
Shortcut key method

Database Features

Database terms
Sorting data
Excel tables
Filtering data
Subtotals
PivotTables
PivotCharts

Workbook Management

Group editing
Move and copy worksheets
Splitting/freezing panes
View several sheets of one workbook in multiple windows
View several workbooks in multiple windows

Excel 2007 Courses

Wed Sep 08
Excel 2007 Introduction Course
Thu Sep 09
Excel 2007 VBA Introduction
Tue Sep 14
Excel 2007 Intermediate Course
Tue Sep 21
Excel 2007 Advanced Course
Wed Sep 29
Excel 2007 VBA Intermediate
Thu Oct 07
Excel 2007 Introduction Course
Tue Oct 12
Excel 2007 VBA Introduction
Wed Oct 13
Excel 2007 Intermediate Course
Wed Oct 20
Excel 2007 VBA Intermediate
Thu Oct 21
Excel 2007 Advanced Course