Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Excel 2007 Course

Microsoft Excel 2007 Self Paced Training Course

Course Description: Learn all the new features of Microsoft Excel 2007. This Self Paced online class covers the basic, intermediate and advanced features of Microsoft's newest spreadsheet program.

Price: 6-month User License: $99.00
Price: 12-month User License: $129.00

6-month license

12-month license

free demo

Microsoft Excel 2007 Self-Paced Course Syllabus

Course Outline

The Fundamentals

Starting Excel 2007
What's New in Excel 2007
Understanding the Excel 2007 Program Screen
Understanding the Ribbon Incomplete Using the Microsoft Office Button and Quick Access Toolbar
Using Keyboard Commands
Using Contextual Menus and the Mini Toolbar
Using Help
Exiting Excel 2007

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

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

Formatting a Worksheet

Formatting Labels
Formatting Values
Adjusting Row Height and Column Width
Working with Cell Alignment
Adding Cell Borders, Background Colors and Patterns
Using the Format Painter
Using Cell Styles
Using Document Themes
Applying Conditional Formatting
Creating and Managing Conditional Formatting Rules
Finding and Replacing Formatting

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

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

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

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

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

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

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

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

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 or Other Sources
Displaying and Managing Connections

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 Code in a Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If...Then...Else Statement

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 Document
Preparing Documents for Publishing and Distribution
Publishing a Workbook to a Document Workspace
Creating a Custom AutoFill List
Creating a Custom Number Format

Special Offers!

Special Offer: Get this class, along with all of our other available Microsoft Office self-paced training courses for only $149. See what is included in the Microsoft Office value package.

Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)

Business Computer Skills BBB Profile