Microsoft Excel 2007

£29 (plus vat)

The Excel 2007 course is divided into 16 chapters containing a total of 175 interactive learning lessons which takes you through the skills and knowledge you need to make effective use of Microsoft Excel 2007.

The beauty? It's there all the time, at your elbow - when you need a little help on how to do something, go to your online learning - look it up and get a refresher, in just a few minutes - no need to trouble anyone else and you don't need to remember.

The content covered:

INTRODUCTION

Chapter One: The Fundamentals 

Starting Excel 2007

What's New in Excel 2007

Understanding the Excel Program Screen

Understanding the Ribbon

Using the Office Button and Quick Access Toolbar

Using Keyboard Commands

Using Contextual Menus and the Mini Toolbar

Using Help

Exiting Excel 2007

Chapter Two: Worksheet Basics 

Creating a New Workbook

Opening a Workbook

Navigating a Worksheet

Entering Labels

Entering Values

Selecting a Cell Range

Overview of Formulas and Using AutoSum

Entering Formulas

Using AutoFill

Understanding Absolute and Relative Cell References

Using Undo and Redo

Saving a Workbook

Previewing and Printing a Worksheet

Closing a Workbook

Chapter Three: Editing a Worksheet 

Editing Cell Contents

Cutting, Copying, and Pasting Cells

Moving and Copying Cells Using the Mouse

Using the Office Clipboard

Using the Paste Special Command

Checking Your Spelling

Inserting Cells, Rows, and Columns

Deleting Cells, Rows, and Columns

Using Find and Replace

Using Cell Comments

Using the Research Task Pane

Tracking Changes

Chapter Four: Formatting a Worksheet 

Editing Cell Contents

Cutting, Copying, and Pasting Cells

Moving and Copying Cells Using the Mouse

Using the Office Clipboard

Using the Paste Special Command

Checking Your Spelling

Inserting Cells, Rows, and Columns

Deleting Cells, Rows, and Columns

Using Find and Replace

Using Cell Comments

Using the Research Task Pane

Tracking Changes

INTERMEDIATE 

Chapter Five: Creating and Working with Charts 

Creating a Chart

Resizing and Moving a Chart

Changing Chart Type

Applying Built-in Chart Layouts and Styles

Working with Chart Labels

Working with Chart Axes

Working with Chart Backgrounds

Working with Chart Analysis Commands

Formatting Chart Elements

Changing a Chart's Source Data

Using Chart Templates

Chapter Six: Managing Workbooks 

Viewing a Workbook

Working with the Workbook Window

Splitting and Freezing a Workbook Window

Selecting Worksheets in a Workbook

Inserting and Deleting Worksheets

Renaming, Moving and Copying Worksheets

Working with Multiple Workbooks

Hiding Rows, Columns, Worksheets and Windows

Protecting a Workbook

Protecting Worksheets and Worksheet Elements

Sharing a Workbook

Creating a Template

Chapter Seven: Working with Page Layout and Printing 

Creating Headers and Footers

Using Page Breaks

Adjusting Margins and Orientation

Adjusting Size and Scale

Adding Print Titles, Gridlines and Headings

Advanced Printing Options

Chapter Eight: More Functions and Formulas 

Formulas with Multiple Operators

Inserting and Editing a Function

AutoCalculate and Manual Calculation

Defining Names

Using and Managing Defined Names

Displaying and Tracing Formulas

Understanding Formula Errors

Working with Data Ranges

Sorting by One Column

Sorting by Colors or Icons

Sorting by Multiple Columns

Sorting by a Custom List

Filtering Data

Creating a Custom AutoFilter

Using an Advanced Filter

Chapter Nine: Working with Tables 

Creating a Table

Working with Table Size

Working with the Total Row

Working with Table Data

Summarizing a Table with a PivotTable

Using the Data Form

Using Table Styles

Using Table Style Options

Creating and Deleting Custom Table Styles

Convert or Delete a Table

Chapter Ten: Working with PivotTables 

Creating a PivotTable

Specifying PivotTable Data

Changing a PivotTable’s Calculation

Filtering and Sorting a PivotTable

Working with PivotTable Layout

Grouping PivotTable Items

Updating a PivotTable

Formatting a PivotTable

Creating a PivotChart

Chapter Eleven: Analyzing and Organizing Data 

Creating Scenarios

Creating a Scenario Report

Working with Data Tables

Using Goal Seek

Using Data Validation

Using Text to Columns

Removing Duplicates

Grouping and Outlining Data

Using Subtotals

Consolidating Data by Position or Category

Consolidating Data Using Formulas

Chapter Twelve: Working with the Web and External Data 

Inserting a Hyperlink

Creating a Web Page from a Workbook

Importing Data from Access or Text Files

Importing Data from the Web and Other Sources

Working with Existing Data Connections

ADVANCED 

Chapter Thirteen: Working with Macros 

Recording a Macro

Playing and Deleting a Macro

Adding a Macro to the Quick Access Toolbar

Editing a Macro’s Visual Basic Code

Inserting Copied Code in a Macro

Declaring Variables and Adding Remarks to VBA Code

Prompting for User Input

Using the If...Then...Else Statement

Chapter Fourteen: Working with Objects 

Inserting Clip Art

Inserting Pictures and Graphics Files

Formatting Pictures and Graphics

Inserting Shapes

Formatting Shapes

Resize, Move, Copy and Delete Objects

Applying Special Effects to Objects

Grouping Objects

Aligning Objects

Flipping and Rotating Objects

Layering Objects

Inserting SmartArt

Working with SmartArt Elements

Formatting SmartArt

Using WordArt

Inserting an Embedded Object

Inserting Symbols

Chapter Fifteen: Advanced Topics 

Customizing the Quick Access Toolbar

Using and Customizing AutoCorrect

Changing Excel’s Default Options

Recovering Your Documents

Using Microsoft Office Diagnostics

Viewing Document Properties and Finding a File

Saving a Document as PDF or XPS

Adding a Digital Signature to a Workbook

Preparing Documents for Publishing and Distribution

Publishing a Workbook to a Document Workspace

Creating a Custom AutoFill List

Creating a Custom Number Format

Chapter Sixteen: Appendix of Common Functions 

Using Logical Functions (IF)

Using Financial Functions (PMT)

Using Database Functions (DSUM)

Using Lookup Functions (VLOOKUP)

Financial Functions

Date & Time Functions

Math & Trig Functions

Statistical Functions

Lookup & Reference Functions

Database Functions

Text Functions

Logical Functions

Microsoft Office Excel 2007 Review 

Index