Excel 2007 Beginner - DSXL71 ( 1 Day )
Price: $195.00
Course Outline
Download Course Outline (PDF)
View Course Schedule
Abstract/Overview
Microsoft Excel 2007 is the latest version of the powerful spreadsheet software that helps you organize information and make quick and accurate numerical calculations. Suitable for everyday tasks like budgeting and forecasting, Excel is equally useful in scientific, engineering and financial work.
This module is the first part of a three-day series that covers all the capabilities of Excel 2007 in detail, from the most basic worksheet operations, to advanced applications like what-if analysis and macro writing.
In this first module, you discover the key differences between Excel 2007 and its predecessor, Excel 2003. You learn everything you need to create, edit and format simple workbooks and worksheets, using Excel’s most common functions and features.
Audience - Who Should Attend?
This module is for those who are new to Excel or to the concept of using spreadsheets to organize, manipulate and format information. It is also very useful for those moving to Excel 2007 from earlier versions. If you need to create or edit spreadsheets using Excel’s powerful set of tools, this course is for you.
Prerequisite
You should be able to use a desktop computer with a mouse and keyboard. Beyond that, no particular skills are required.
Objective
When you complete this course, you will be able to:
· Describe what all the controls on the Excel program screen are for, including the new Ribbon, Office Button and Quick Access Toolbar
· Start Excel, create a new workbook, open an existing workbook, print your work and save a workbook
· Use menu commands and toolbars to enter data into a workbook, enter a formula into a workbook cell, and apply labels to ranges of cells
· Streamline worksheet tasks using AutoSum and AutoFill
· Edit cell contents using cut, copy, paste and drag and drop
· Insert and delete rows, find and replace contents, and use undo/redo
· Format worksheets using number formats, borders, shading and patterns, the Format Painter, and apply rules-based conditional fomatting
Apply reusable format using Document Themes
Content
The Fundamentals
Starting Excel 2007
What’s New in Excel 2007
Understanding the Excel Program Screen
Understanding the Ribbon
Using the 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, Redo and Repeat
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
Tracking Changes
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
Course Schedule
| Start Date | Location | Class Code | Duration (days) |
| Wed, Dec 01 2010 | Toronto | P36565 | 1 |
| | | | |
top