Learning Microsoft Excel 2002 / Edition 1 available in Other Format
Learning Microsoft Excel 2002 provides readers a total-immersion, hands-on tutorial that walks them step by step, mouse-click by mouse-click, keystroke by keystroke through basic, intermediate, to advanced features of Excel. The well-illustrated, spiral-bound manual contains easy-to-read, appealingly formatted procedural explanations and step-by-step exercises in a multi-part Lesson format. Real-life, on-the-job scenarios make content immediately relevant. An accompanying CD-ROM includes data files, Internet simulations, and computer literacy basics exercises.
Excel 2002 Basics. Key Worksheet Procedures. Use Formulas and Functions. Perform Common Tasks. Print a Worksheet. Edit and Manipulate Worksheets and Workbooks. Modify the Appearance of a Worksheet. Integrate Excel and Other Applications and the Internet. Use Advanced Functions. Create and Modify Charts. Analyze Data. Create Macros.
For anyone wanting to develop skill in using Excel.
Read an Excerpt
How We've Organized the Book
Each lesson in Learning Microsoft Excel 2002 is made up of twelve lessons. Every exercise (except for the Critical Thinking Exercises) is made up of seven key elements:
- On the Job. Each exercise starts with a brief description of how you would use the features of that exercise in the workplace.
- Exercise Scenario. The Excel tools are then put into context by setting a scenario. For example, you may be the manager of computer store putting together a monthly sales report or a weekly payroll form.
- Terms. Key terms are defined at the start of each exercise, so you can refer back to them quickly. The terms are also highlighted in the text.
- Notes. Concise notes describe and outline the . computer concepts in each exercise.
- Procedures. Hands-on mouse and keyboard procedures teach all necessary skills.
- Application Exercise. Step-by-step instructions put your skills to work.
- On Your Own. Each exercise concludes with a critical thinking activity for you to work through on your own. You are challenged to come up with data and then additionally challenged to use the data in a workbook. The On Your Own sections can be used as reinforcement, for practice, or to test skill proficiency.
- In addition, each lesson ends with a Critical Thinking Exercise. As with the On Your Owns, you need to rely on your own skills to complete the task.
Table of Contents
Microsoft Office User Specialist (MOUS) Information.
Index of MOUS Objectives.
Directory of Files.
Lesson 1: Excel 2002 Basics (Exercises 1-4).
Lesson 2: Key Worksheet Procedures (Exercises 5-10).
Lesson 3: Use Formulas and Functions (Exercises 11-16).
Lesson 4: Perform Common Tasks (Exercises 17-22).
Lesson 5: Print a Worksheet (Exercises 23-26).
Lesson 6: Edit and Manipulate Worksheets and Workbooks (Exercises 27-35).
Lesson 7: Modify the Appearance of a Worksheet (Exercises 36-42).
Lesson 8: Integrate Excel and Other Applications and the Internet (Exercises 43-49).
Lesson 9: Use Advanced Functions (Exercises 50-60).
Lesson 10: Create and Modify Charts (Exercises 61-70).
Lesson 11: Analyze Data (Exercises 71-82).
Lesson 12: Create Macros (Exercises 83-85).