Excel Windows 5: Introduction

Course Code: EXCW5-1 Time: 7 hours

Prerequisites: Windows: Introduction

The Basics The Worksheet Concept The Electronic Worksheet Starting Excel Windows Screen Elements Excel Screen Elements The Mouse and the Keyboard Worksheet Structure Creating a Worksheet Menu Bar Creating a New Workbook Pre-Selecting Data Range Saving, Closing and Opening Files Summary Information Deleting Data UNDO Formulas What is a Formula? Functions SUM(), AVERAGE() MAX() MIN() The AutoSum Button The Function Wizard Order of Operation Documenting Your Worksheet The Excel Menu System Main Menu, Quick Menus & the Toolbar Menu Commands Help! Quick Menus (Right-Click) Toolbars Tabbed Dialog Boxes

Worksheet Mechanics Editing and Deleting Cell Entries Moving and Copying Data Working With Large Worksheets Adding and Deleting Rows, Columns, or Sheets Spellcheck Absolute Addresses Controlling Worksheet Appearance Formatting the Worksheet Number Format Alignment Fonts Borders and Patterns The Formatting Toolbar Tear Off Palettes Removing Formats Column Width and Row Height Autofit Selection Row Height Working with Dates and Time Printing Print Features Print Preview Page Breaks Ending the Excel Session Appendix Function Keys Keyboard Movement Keys Formatting Codes

Return to Course Listing | Home Page