1	MS Excel 2007 Level I Judy Rosella Edwards judy@judyrosellaedwards.com http://www.judyrosellaedwards.com
2	Using Basic Workbook Skills Selecting a Cell using the Keyboard Using KeyTips Scrolling using the Mouse Using the Scroll Bar Shortcut Menu Using the Go To Dialog Box Entering Text and Numbers into Cells Creating/Saving a New Workbook …continued
3	Using Basic Workbook Skills …continued Creating/Saving a New Workbook Using a Template Opening an Existing Workbook Using Data Entry Shortcuts Editing Cell Entries Checking Worksheet Spelling
4	Working with Ranges Selecting Ranges with the Mouse Selecting Ranges with the Keyboard Selecting Non-adjacent Ranges Entering Values into a Range Using the Auto Fill Feature
5	Creating Simple Formulas Entering Formulas Using Functions Using the AutoSum Button Using Formula AutoComplete Inserting/Editing Functions Using the AutoCalculate Feature Checking Formula Errors
6	Copying and Moving Data Copying/Cutting and Pasting Data Copying and Pasting Formulas Paste Options and Paste List Using the Clipboard Task Pane Creating an Absolute Reference Filling Cells Using Drag-and-Drop Editing
7	Printing Previewing a Worksheet Printing the Current Worksheet Printing a Selected Range Printing a Page Range
8	Using Page Setup Setting Margin and Centering Options Changing Page Orientation /Paper Size Repeating Row and Column Labels Scaling a Worksheet Changing Page Breaks Setting/Removing a Print Area Creating Headers and Footers
9	Formatting Numbers Accounting Number Style Percent and Comma Styles Changing Decimal Places
10	Formatting Text Changing an Existing Font Modifying the Font Size Bold, Underlining and Italics Changing the Font Color Rotating/Wrapping/Shrinking Text in a Cell Changing Cell Alignment
11	Working with Columns & Rows Selecting Columns and Rows Using Narrow Column Tooltips Changing the Size of Columns & Rows Adjusting Columns Automatically Hiding/Unhiding Columns and Rows Inserting/Deleting Columns and Rows
12	Formatting Cells Using the Merge and Center Button Changing the Vertical Alignment Splitting Cells Using the Borders Button Using the Fill Color Button Pasting Formats Using the Format Painter Button
13	Using Automatic Formatting and Styles Applying an AutoFormat Applying a Predefined Style Creating a Style by Example Editing an Existing Style Merging Styles
14	Next Excel 2007 Level 2 Using Large Worksheets Logical Functions Sorting & Filtering Charts Drawing Objects SmartArt HTML & Hyperlinking Worksheets Working with Comments
15	Next Excel 2007 Level 3 Working with Tables Working with Advanced Filters Importing & Exporting Data Outline View Advanced Charting Conditional & Custom Formats Templates & Paste Special Customizing Preferences Worksheet Protection Multiple Workbooks & Sharing
16	Next Excel 2007 Level 4 Using the Series Command Advanced Functions PivotTables & Pivot Charts Scenaries & Goal Seeking Data Tables Consolidating Worksheets Working with Views Auditing Tools Buttons & Macros
17	Next Microsoft Access