Midland Computer Training and Support



	Microsoft Excel 2003
		This course provides competency in creating workbooks, modifying worksheets, formatting worksheets and printing worksheets. This course also provides competency in creating and editing formulas, working with basic functions and the Function Wizard, applying text attributes and other formatting characteristics, creating workbooks from templates, using styles, adding worksheet backgrounds, applying AutoFormats, and finding and replacing data. Guided, step-by-step labs provide opportunities to practice new skills. You can challenge yourself and review your skills after each lesson in the Lesson Summary and Lesson Review sections. Additional skill reinforcement is provided in Activities, Optional Labs, Lesson Quizzes and a Course Assessment that are available from your instructor. This coursebook includes a supplemental CD-ROM containing the lab files used in class. To practice the skills presented in class or to perform any labs that were not completed, refer to the Classroom Setup section for information about system requirements and using the lab files. Topics Introduction to Excel Overview of Workbooks and Worksheets Starting Excel Navigating Worksheets Selecting Ranges Using Toolbars and Menus Quitting Excel Case Study Creating Workbooks About Workbooks Opening New Workbooks Entering Data Editing Data Saving and Closing New Workbooks Case Study Modifying Worksheets Introduction to Modifying Worksheets Opening Existing Workbooks Copying Worksheet Data Moving Worksheet Data Deleting Worksheet Data Saving Existing Workbooks Case Study Formatting Worksheets Introduction to Formatting Worksheets Inserting and Deleting Cells Inserting and Deleting Rows and Columns Adjusting Column Widths and Row Heights Hiding and Unhiding Rows and Columns Applying Numeric Formats Aligning Cell Data Case Study Printing Worksheets Introduction to Printing Worksheets Checking Spelling Previewing Worksheets Previewing Page Breaks Printing Worksheets Case Study Working with Formulas About Formulas Creating Formulas Editing Formulas Using Cell References Case Study Working with Basic Functions About Functions Using the AutoSum Feature Using the AVERAGE Function Using the MAX Function Using the MIN Function Using the Function Wizard Using the AutoCalculate Feature Case Study Enhancing Worksheets Introduction to Enhancing Worksheets Changing Fonts and Text Attributes Merging and Splitting Cells Rotating Text in Cells Indenting Text in Cells Adding and Modifying Borders Adding Background Shading Working with Graphics Working with Diagrams Case Study Using Templates, Styles, Worksheet Backgrounds and AutoFormats About Templates, Styles, Worksheet Backgrounds and AutoFormats Creating Workbooks from Templates Using Styles Adding Worksheet Backgrounds Applying AutoFormats Case Study Finding and Replacing Data Introduction to Finding and Replacing Data Finding and Opening Existing Workbooks Finding and Replacing Text Finding and Replacing Numeric Data Finding and Replacing Cell Formats Using the Research Tool Case Study