Excel Windows 5: Transition from a DOS Spreadsheet

Course Code: EXCW5-T Time: 7 hours

Prerequisites: Windows: Introduction and extensive experience in a DOS spreadsheet

The Transition Making the Switch Starting Excel Windows Screen Elements Excel Screen Elements The Mouse and Keyboard Menu Bar Quick Menus (Right-Click) Toolbars Tabbed Dialog Boxes Creating a Workbook Creating New Workbook Window Entering Worksheet Data Pre-Selecting Data Entry Range Excel Formula Basics Saving, Closing and Opening Files Editing and Deleting Cell Entries UNDO Excel Functions & Formulas Functions SUM() Function AVERAGE() MAX() MIN() The AutoSum Button Moving and Copying Data Moving Data Copying Data The Fill Handle Absolute References More Excel Functions AND() OR() The Function Wizard PMT() Order of Operation Working with Dates and Time Naming Ranges Naming Rules So What are Names Good For?

Worksheet Mechanics Working With Large Worksheets Zooming, Freezing Panes, & Splitting The Window Add/Delete Rows/Columns/Sheets Spellcheck Controlling Worksheet Appearance Formatting the Worksheet Number Formats, Alignment, Fonts, Borders, & Patterns The Formatting Toolbar Palette Buttons Removing Formats Column Width and Row Height Autofit Selection Multiple Pages and Files Excel Workbooks Sheet Names Grouping Sheets 3-D Formulas & 3-D Ranges Multiple Files External Cell Addresses Printing Print Features Print Preview Page Breaks Ending the Excel Session Appendix Documenting Your Work Help for 1-2-3 Users Function Keys Keyboard Movement Keys Formatting Codes Number Format Shortcuts Sequential List of Procedures

Return to Course Listing | Home Page