Microsoft Excel 2007 Foundation

Upon Completion of this course the students will be able to: Understand what Excel is used for; Use the 'Help' function; Use the toolbar; Manage files; Use Features, Tools; Modify data; Use Smart Tags; Modify, format and enhance worksheets and much more

Course Outline

Upon Completion of this course the students will be able to:

• Understand what Excel is used for
• Use the ‘Help’ function
• Use the toolbar
• Manage files
• Use Features, Tools
• Modify data
• Use Smart Tags
• Modify, format and enhance worksheets
• Manage charts and data
• Manage workbooks

Course Outline Getting Started
Starting Out

• What is Microsoft Excel 2007?
• Opening Microsoft Excel
• Interacting with Excel
• Closing Excel
• Step-By-Step

About Workbooks

• Creating a New Workbook
• Opening a Workbook
• Saving a Workbook
• About Excel File Types
• Closing a Workbook
• Step-By-Step
• Skill Sharpener

Exploring your Workbook

• Using Worksheets
• The Active Cell
• Selecting Cells
• Exploring a Worksheet
• The Zoom Feature
• Step-By-Step
• Skill Sharpener

Getting Help in Excel 2007

• Using the Help Screen
• About Online Help
• About Offline Help
• Step-By-Step
• Skill Sharpener

Case Study
Review Questions

The New Interface
The Quick Access Toolbar

• The Default Buttons
• Adding Buttons
• Removing Buttons
• Customizing the Toolbar
• Step-By-Step
• Skill Sharpener
• The Home Ribbon
• Clipboard
• Font
• Alignment
• Number
• Style
• Cells
• Editing
• Step-By-Step
• Skill Sharpener

The Insert Ribbon

• Tables
• Charts
• Illustrations
• Shapes
• Links
• Text
• Step-By-Step
• Skill Sharpener

The Page Layout Ribbon

• Themes
• Page Setup
• Scale to Fit
• Sheet Options
• Arrange
• Step-By-Step
• Skill Sharpener

The Formulas Ribbon

• The Function Library
• Defined Names
• Formula Auditing
• Calculation
• Step-By-Step
• Skill Sharpener

The Data Ribbon

• Get External Data
• Connections
• Sort and Filter
• Data Tools
• Outline
• Step-By-Step
• Skill Sharpener

The Review Ribbon

• Proofing
• Comments
• Changes
• Step-By-Step
• Skill Sharpener

Case Study
Review Questions


Excel Basics
Working With Excel 2007

• Columns, Rows, Cells, and Ranges
• Creating Worksheet Labels
• Entering and Deleting Data
• Printing Your Worksheet
• Step-By-Step
• Skill Sharpener

Basic Excel Features

• What is AutoFill?
• What is AutoSum?
• What is AutoComplete?
• Working with Basic Formulas
• Step-By-Step
• Skill Sharpener

Moving your Data

• Dragging and Dropping Cells
• How to Cut, Copy, and Paste Cells
• How to Cut, Copy, and Paste Multiple Cells and Items
• How to Use Paste Special
• How to Insert and Delete Cells, Rows, and Columns
• Using Undo, Redo, and Repeat
• Step-By-Step
• Skill Sharpener

Smart Tags and Options Buttons

• What Are Smart Tags?
• The Error Option Button
• The AutoFill Option Button
• The Paste Option Button
• Setting Smart Tag Options
• Step-By-Step
• Skill Sharpener

Editing Tools

• Using AutoCorrect
• Using Spell Check
• Using Find and Replace
• Adding Comments
• Step-By-Step
• Skill Sharpener

Case Study
Review Questions

Editing Your Workbook
Modifying Cells and Data

• Changing the Size of Rows or Columns
• Adjusting Cell Alignment
• Rotating Text
• Creating Custom Number and Date Formats
• Step-By-Step
• Skill Sharpener

Cell Formatting

• Conditional Formatting
• The Format Painter
• Cell Merging and AutoFit
• Find and Replace Formatting
• Step-By-Step
• Skill Sharpener

Enhancing a Worksheet’s Appearance

• Adding Patterns and Colors
• Adding Borders
• Working with Styles
• Step-By-Step
• Skill Sharpener

Working With Charts

• Creating a Chart
• Formatting a Chart
• Modifying Charts with the Layout Ribbon
• Manipulating a Chart
• Enhancing a Chart with Shapes and Graphics
• Step-By-Step
• Skill Sharpener

Working with Charts, Part 2

• Changing the Type of Chart
• Changing the Source Data
• Working with the Chart Axis and Data Series
• Saving a Chart as a Template
• Step-By-Step
• Skill Sharpener

Case Study
Review Questions

Printing and Viewing your Workbook
Using the View Ribbon

• Using Normal View
• Using Full Screen View
• Using Page Layout View
• Page Break Preview
• Step-By-Step
• Skill Sharpener

Managing a Single Window

• Creating a New Window
• Hiding a Window
• Unhiding a Window
• Freezing a Pane
• Step-By-Step
• Skill Sharpener

Managing Multiple Windows

• Switching Between Open Workbooks
• Arranging Workbooks
• Comparing Workbooks Side by Side
• Synchronous Scrolling, Resetting a Window, and Saving a Workspace
• Step-By-Step
• Skill Sharpener

Printing your Workbook

• Opening Print Preview
• Using the Print Preview Ribbon
• Quick Printing
• The Print Dialogue
• Using Page Setup
• Step-By-Step
• Skill Sharpener

Case Study
Review Questions

Additional Details

Pre-Requisites

None

Certificates offered

Certificate of Completion

Cancellation Policy

Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to info@itplanit.com.

Map & Reviews

Itplanit Services Corp.
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

A very interesting course. Claude Gerin, our instructor, was excellent in making this a very interesting and learning experience. THANKS!

Reviewed by Oleg T. 2012