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

No events