Synopses & Reviews
With an estimated completion time of 35+ hours, this comprehensive text is ideal for beginning users of Microsoft Excel. Certified as Expert level it covers beginning through advanced features of the software. Lessons contain objectives, step-by-step instructions, screen illustrations, tips, notes, Internet coverage, chapter summaries, end-of-chapter exercises, projects and SCANS correlations. It is appropriate for individual or group work.
About the Author
Sandra Cable is the author and co-author of numerous books with Course Technology. Her books include both introductory and advanced levels of Microsoft Excel and Access. The author holds a doctorate in Education from Texas A&M University Commerce. In addition to working full-time for an international corporation in Dallas, TX, she volunteers to teach at seminars and in classrooms promoting simple approaches to using computer applications. Pasewark and Pasewark is comprised of six authors, all partners in the Pasewark LTD, a family-owned business. With over 90 years of combined experience authoring more than 100 computer, accounting, and office technology textbooks, they have won seven Texty Awards for the best computer or business textbook of the year. In addition, the Pasewarks have also won numerous awards for their classroom teaching, a major ingredient for writing effective textbooks.
Table of Contents
Introduction Lesson 1: Office 2000 Basics and the Internet Introduction to Microsoft Excel Unit 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 Other Software Tools Lesson 8: Worksheet Charts Advanced Microsoft Excel Unit Lesson 1: Applying Advanced Formats to Worksheets and Charts Lesson 2: Printing Workbooks Lesson 3: Using Data Lists Lesson 4: Filtering and Extracting Data Lesson 5: Working with Analysis Tools and PivotTables Lesson 6: Creating Macros Lesson 7: Importing, Exporting, and Integrating Data Lesson 8: Using Templates Lesson 9: Working with Multiple Worksheets and Workbooks Lesson 10: Creating Shared Workbooks, Data Maps, and Web Pages Lesson 11: Using Outlines, Subtotals, and Lookup Functions Lesson 12: Working with Graphics and Embedded Elements Appendices A: The Microsoft Office User Specialist Program B: Microsoft Windows 98 Basics C: Computer Concepts