Excel 2007 Foundation
Course Description
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel® 2007 to manage, edit, and print data.
View other Excel Courses available
View other Excel Courses available
1 Day
Contact us for pricing
Prerequisites
To effectively understand this course, we recommend that you take the Microsoft Office Windows XP or Vista Introduction course or have equivalent knowledge.Getting Started
Starting OutWhat is Microsoft Excel 2007?
Opening Microsoft Excel
Interacting with Excel
Closing Excel
About Workbooks
Creating a New WorkbookOpening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Exploring your Workbook
Using WorksheetsThe Active Cell
Selecting Cells
Exploring a Worksheet
The Zoom Feature
Getting Help in Excel 2007
Using the Help ScreenAbout Online Help
About Offline Help
The New Interface
The Quick Access ToolbarThe Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
The Home Ribbon
Clipboard
Font
Alignment
Number
Style
Cells
Editing
The Insert Ribbon
TablesCharts
Illustrations
Shapes
Links
Text
The Page Layout Ribbon
ThemesPage Setup
Scale to Fit
Sheet Options
Arrange
Step-By-Step
Skill Sharpener
The Formulas Ribbon
The Function LibraryDefined Names
Formula Auditing
Calculation
Step-By-Step
Skill Sharpener
The Data Ribbon
Get External DataConnections
Sort and Filter
Data Tools
Outline
The Review Ribbon
ProofingComments
Changes
Excel Basics
Working With Excel 2007Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing Your Worksheet
Basic Excel Features
What is AutoFill?What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
Moving your Data
Dragging and Dropping CellsHow 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
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 AutoCorrectUsing Spell Check
Using Find and Replace
Adding Comments
Editing Your Workbook
Modifying Cells and DataChanging the Size of Rows or Columns
Adjusting Cell Alignment
Rotating Text
Creating Custom Number and Date Formats
Cell Formatting
Conditional FormattingThe Format Painter
Cell Merging and AutoFit
Find and Replace Formatting
Enhancing a Worksheet’s Appearance
Adding Patterns and ColorsAdding Borders
Working with Styles
Working With Charts
Creating a ChartFormatting 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 ChartChanging 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 RibbonUsing Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview
Managing a Single Window
Creating a New WindowHiding a Window
Unhiding a Window
Freezing a Pane
Managing Multiple Windows
Switching Between Open WorkbooksArranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
Printing your Workbook
Opening Print PreviewUsing the Print Preview Ribbon
Quick Printing
The Print Dialogue
Using Page Setup
Excel 2007Microsoft Excel 2007