Microsoft Excel 2007 Foundation
Aims for this course
To effectively collect, calculate and manipulate data electronically and present the information in table and graphical formats. Be proficient in the creation of basic formulae and how to use them in a timely and efficient manner. Delegates will feel comfortable with the features of excel plus have the confidence to develop their own small spreadsheet models
Course Agenda
Getting
Started
Starting
Out
What
is Microsoft Excel 2007?
Opening Microsoft Excel
Interacting with Excel
Closing Excel
About Workbooks
Creating a
New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Exploring
your Workbook
Using Worksheets
The Active Cell
Selecting Cells
Exploring a Worksheet
The Zoom Feature
Getting
Help in Excel 2007
Using the
Help Screen
About Online Help
About Offline Help
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
The
Page Layout Ribbon
Themes
Page Setup
Scale to Fit
Sheet Options
Arrange
The Formulas
Ribbon
The
Function Library
Defined Names
Formula Auditing
Calculation
The Data
Ribbon
Get
External Data
Connections
Sort and Filter
Data Tools
Outline
The Review
Ribbon
Proofing
Comments
Changes
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
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
Editing
Tools
Using
AutoCorrect
Using Spell Check
Using Find and Replace
Adding Comments
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
Cell Formatting
Conditional
Formatting
The Format Painter
Cell Merging and AutoFit
Find and Replace Formatting
Enhancing
a Worksheet's Appearance
Adding
Patterns and Colors
Adding Borders
Working with Styles
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
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
Printing and Viewing
your Workbook
Using the
View Ribbon
Using
Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview
Managing
a Single Window
Creating
a New Window
Hiding a Window
Unhiding a Window
Freezing a Pane
Managing
Multiple Windows
Switching
Between Open Workbooks
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
Printing
your Workbook
Opening
Print Preview
Using the Print Preview Ribbon
Quick Printing
The Print Dialogue
Using Page Setup
Course Title
Microsoft Excel 2007 Foundation
Cost per delegate
£145 +vat
Who is this course for?
Users with little or no experience in MS Excel 2007
Related courses
> MS Excel 2007 Intermediate
> MS Excel 2007 Advanced
> MS Excel 2007 Expert
When is this course running?
Click here to view the latest course schedule
