Introduction to Excel 2007

2-day workshop, $215 +tax
9:00 am-4:00 pm

Utilizing the CustomGuide workbooks, students will learn worksheet basics as well as some use of three-dimensional workbooks (referencing cells on multiple worksheets). After students complete this course, they will understand the advantages of using an electronic spreadsheet over a paper ledger, and create formulas with some of Excel’s built-in functions. Students will learn how to create and edit spreadsheets and charts and use Excel’s database functions. Students enrolling in this course should understand the basic concepts involved in working with a personal computer.

Some of the skills developed in this course:

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
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 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
Using the Research Task Pane
Tracking Changes
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 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
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
Creating Headers and Footers
Using Page Breaks
Adjusting Margins and Orientation
Adjusting Size and Scale
Adding Print Titles, Gridlines and Headings
Advanced Printing Options