Microsoft Excel 2007 Level 2

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: Formulas and Functions
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
Protecting a Workbook
Protecting Worksheets and Worksheet Elements

Chapter Two: Analyzing and Organizing Data
Creating Scenarios
Creating a Scenario Report
Working with Data Tables
Using Goal Seek
Using Solver
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 Three: Creating and Working with Charts
Creating a Chart
Resizing and Moving 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 Four: 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


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 1.