Excel 2007 - Intermediate

Overview

About this course

Self-paced lessons on intermediate Excel 2007: workbooks, range names, outlines and subtotals, Paste Special and charts.

Curriculum

Curriculum

10 modules

Introduction

Navigate, Name, and Color Worksheets
Naming Worksheets
Setting the Tab Color
Inserting and Deleting Worksheets
Moving and Copying Worksheets
Moving a Sheet to Another Workbook
Grouping Worksheets
Formatting Grouped Worksheets
Entering 3D Formulas
Using the Watch Window
Anchoring the Watch Window

Viewing Rules for Range Names
Naming a Range of Cells
Moving to a Range Name
Creating a Range Name from Headings
Name Manager
Performing Calculations with Range Names
Creating 3D Range Names
Using Range Names in 3D Formulas

Applying an Outline Manually
Applying an Automatic Outline
Expanding and Collapsing an Outline
Clearing an Outline
Creating Subtotals
Changing the Function Used in Subtotals
Clearing Subtotals

Pasting with No Borders
Transposing
Paste Values
Linking Worksheets and Workbooks
Using the Arrange Windows Tool

Creating an Embedded Chart
Moving a Chart to a Separate Sheet
Selecting Chart Designs and Styles
Changing the Chart Type
Switching Row/Column Data
Selecting a Chart Layout
Using Chart Titles and Axis Labels
Creating a Chart Legend, Data Labels, and a Data Table
Formatting the Chart Axis

Inserting a Text Box
Adding and Formatting Shapes
Using Connector Lines
Adding Shape Effects and Styles

Using Hyperlinks
Linking to a Named Range
Linking to a Specific Cell
Linking to a URL
Linking to an External File

Using an Existing Template
Modifying a Template
Saving a Template
Opening a Template

Course Recap

Who it's for

Who it's for

Users of Excel 2007 building their skills.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.