1 2 1 1 6 8 5 9
Site Navigation
Instructor Classes
Online Classes

Home Page
Course Catalog
Training Locations
FAQ
Partner Sites
User Login
My Account
Online Class Login
Call Toll Free for Customer Service
Chicago Locations
Chicago
Naperville
Northbrook
Schaumburg
Microsoft Courses
Excel Classes
Access Classes
Project Classes
PowerPoint Classes
Word Classes
Outlook Classes
Adobe Courses
Photoshop Classes
Illustrator Classes
InDesign Classes
Dreamweaver Classes
Flash Classes
HTML Classes
Acrobat Classes
Microsoft Excel 2007 Online Course Detail
Microsoft Excel 2007 Online Course

Microsoft Excel 2007 Online Course Detail


Course Decription: MS Excel 2007

We offer one of the most comprehensive and easy to use online class for Microsoft Excel 2007. Students will learn a variety of topics including:
  • New Features of Excel 2007
  • Spreadsheet Design
  • Formatting Techniques
  • Functions and Calculations
  • Working with Large Data Sets
  • Intermediate and Advanced Topics
Special Offer:You will receive all the available Microsoft Excel 2007 online courses, with the purchase of a single MS Excel 2007 online course.
Microsoft Excel 2007 Course Demo


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


Return to the Illinois Computer Training® online course list