Microsoft Excel 2007 Level 3

Microsoft Excel 2007 is a powerful spreadsheet software program that allows you to make quick and accurate numerical calculations. Entering data onto a spreadsheet (or worksheet as they are called in Excel) is quick and easy. Once data has been entered in a worksheet, Excel can instantly perform any type of calculation on it. Excel can also make your information look sharp and professional.

The uses for Excel are limitless: businesses use Excel for creating financial reports, scientists use Excel for statistical analysis, and families use Excel to help manage their investment portfolios. Microsoft Excel is by far the most widely used and, according to most reviews, the most powerful and user friendly spreadsheet program available. You've made a great choice by deciding to learn Microsoft Excel 2007.


Course Outline

Chapter One: 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 Two: Working with Data Ranges
Sorting by One Column
Sorting by Colours or Icons
Sorting by Multiple Columns
Sorting by a Custom List
Filtering Data
Creating a Custom AutoFilter
Using an Advanced filter

Chapter Three: 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

Chapter Four: Working with Macros
Recording a Macro
Playing and Deleting a Macro
Adding a Macro to the QuickAccess Toolbar
Editing a Macro's Visual Basic Code
Inserting Code in a Macro

Chapter Five: 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


Student Practice Files for this class are located here.

Prerequisites: This course is designed for intermediate Microsoft Office users.

Basic computer skills are necessary to complete this course. These skills include: a basic understanding of a computer's operating system, the ability to navigate the environment using a mouse and keyboard, an understanding of computer file storage, launching an application, and creating and saving files. It is also recommended that students are also familiar with using the internet.

Students enrolling in this course should be familiar with personal computers, and know how to use Excel 2007 to create, edit, format, and print spreadsheets.

To ensure your success, we recommend you first take the following course or have equivalent knowledge: Excel 2007 Level 2.