Microsoft Excel 2002 Standard Tutorial Self-Learning Manual

Author: Microsoft Corporation
Publisher:
Publish Date: 2002-04-01
Features: OfficeXP has pioneered a new trend in office software with its network and collaborative office capabilities, and Excel within it is the most widely used spreadsheet and data processing software globally. This book is designed for beginners, guiding readers step-by-step into the magical world of data management, helping them master the various functions of Excel 2002 and easily achieve electronic management of various data.
Chapter 1: Experience EXCEL 2002 Electronic Spreadsheets
What new features has Excel 2002 added? This chapter takes you through the experience of Excel 2002.
Chapter 2: Start with a Simple Sales Table
This chapter helps you master the workflow and standards of creating electronic spreadsheets through the creation of a simple table.
Chapter 3: Edit Spreadsheets and Experience Basic Statistical Methods
By creating a "Salary Table" file, you will learn how digital office enables table control and data statistics.
Chapter 4: Professionalize Spreadsheet Formatting
In Excel 2002, you can freely format spreadsheets, making it easier to reflect the logical relationships of data while implementing your design ideas and introducing data management concepts.
Chapter 5: Establish Behavioral Standards to Ensure Table Quality
This chapter emphasizes behavioral standards in office processes, which are powerful measures to improve work efficiency and quality.
Chapter 6: Make Data Presentation More Intuitive—Charts Let Data "Speak"
Charts are the best choice to present data more clearly and showcase their underlying relationships. This chapter introduces you to the charm of charts.
Chapter 7: Data Analysis with Charts
This chapter guides you into a more magical world of charts, where these techniques will help charts better represent your analysis goals.
Chapter 8: Advanced Use of Formulas and Functions
This chapter will help you solve various algorithm problems in life and experience the benefits of digital algorithms.
Chapter 9: Filtering and Sorting Spreadsheet Data
How to make data analysis more flexible? Once you master the methods in this chapter, you will have "command" over the data, making it follow your instructions.
Chapter 10: Statistical Analysis of Spreadsheet Data
In Excel 2002, data statistics are easier, helping you analyze the information hidden in your spreadsheet data.
Chapter 11: Sharing EXCEL Data and Network Applications
The sharing of workbooks enables collaborative office work, and Excel 2002, with its enhanced network capabilities, is even more suited to the demands of the new era. This chapter guides you into the world of network office.