With an estimated completion time of 35+ hours, this comprehensive text is ideal forintroductory courses on Microsoft Excel. Certified as Expert level it covers beginning throughadvanced features of the software. Lessons contain objectives, step-by-step instructions,screen illustrations, tips, notes, Internet coverage, chapter summaries, end-of-chapterexercises, projects and SCANS correlations. It is appropriate for individual or group work.
Table of Contents
Introduction Lesson 1: Microsoft Office 2003 Basics and the Internet Introductory Microsoft Excel Lesson 1: Excel Basics Lesson 2: Changing the Appearance of a Worksheet Lesson 3: Organizing the Worksheet Lesson 4: Worksheet Formulas Lesson 5: Function Formulas Lesson 6: Making the Worksheet Useful Lesson 7: Working with Multiple Worksheets Lesson 8: Worksheet Charts Advanced Microsoft Excel Lesson 9: Applying Advanced Worksheet and Chart Options Lesson 10: Using Lists Lesson 11: Filtering, Extracting, and Using Database Functions Lesson 12: Working with Analysis Tools Lesson 13: Creating PivotTables and PivotCharts Lesson 14: Creating Macros and Menus Lesson 15: Importing and Exporting Lesson 16: Using Templates and Protection Lesson 17: Working with Multiple Worksheets and Workbooks Lesson 18: Working with Shared Workbooks Lesson 19: Using Outlines, Subtotals, and Validation Lesson 20: Using Advanced Excel Tools Appendices A: Windows Basics B: Computer Concepts C: Concepts for Microsoft Office Programs D: The Microsoft Office Specialist Program E: Keyboarding Touch System Improvement