Excel Windows 7: Introduction

Course Code: EXCW7-1 Time: 7 hours

Prerequisites: Windows 95: Introduction

The Basics The Worksheet Concept The Electronic Worksheet Starting Excel Windows 95 Screen Elements Excel Screen Elements The Mouse and the Keyboard Mouse Pointer Appearance Worksheet Structure Renaming Sheets in Workbook Cells, Active Cell, Range, Math Operators Shortcut Menus & the Toolbar Shortcut Menus (Right-Click) Toolbars Tabbed Dialog Boxes Help! The Help Button The Tip Wizard Searching for Help In the Help Window Creating a Worksheet Menu Bar Creating a New Workbook Pre-Selecting Data Entry Range Saving, Closing and Opening Files Summary Information AutoComplete Deleting Data UNDO Formulas Creating Excel Formulas Formulas - The Basics Reviewed Formulas - Beyond the Basics Functions Using Functions SUM() Function AVERAGE() MAX() MIN()

AutoCalculate The AutoSum Button The Function Wizard Documenting Your Worksheet Worksheet Mechanics Editing and Deleting Cell Entries AutoCorrect Moving and Copying Data Working With Large Worksheets Zooming Freezing Panes Splitting The Window Creating a Duplicate Window Adding/Deleting Rows, Columns, or Sheets Spellcheck Controlling Formulas with Absolute Addresses Controlling Worksheet Appearance Formatting the Worksheet Number Formats and Shortcuts Alignment Fonts Borders and Patterns The Formatting Toolbar Format Palettes Removing Formats Column Width and Row Height Autofit Selection Row Height Working with Dates and Time Order of Operation Printing Print Features Print Preview Page Setup Page Breaks Ending the Excel Session

Return to Course Listing | Home Page