WPS Office Kingsoft Spreadsheets Standard Training Material

Author: Beijing Timesun Company (Compiler)
Publisher:
Publishing Date: Not Available
Features: To help readers master the mainstream office software WPS Office 2002 used by government agencies, joint ventures, and educational institutions in China, Kingsoft Company commissioned Beijing Timesun Company to develop a set of official and authoritative training materials—the "Kingsoft Authorized Education Designated Textbook for WPS Office 2002." The series includes four textbooks: "WPS Office 2002 Kingsoft Writer Standard Training Textbook," "WPS Office 2002 Kingsoft Spreadsheets Standard Training Textbook," "WPS Office 2002 Kingsoft Presentation Standard Training Textbook," and "Kingsoft WPS Office 2002 Comprehensive Training Standard Textbook."
The Kingsoft Spreadsheets 2002 module in WPS Office 2002 offers powerful spreadsheet processing capabilities. It supports over 100 functions and conditional expressions across 7 categories, enabling cross-sheet calculations. The module provides features such as table freezing, consolidation, subtotals, auto-filtering, auto-filling, and sorting, allowing for systematic management of data resources. By creating bar charts, pie charts, and other visualizations, it transforms complex data into clear and intuitive charts. It also offers various data report templates, such as personnel and financial reports, and supports data import from databases.
This book systematically and comprehensively introduces the creation of workbooks, the editing and formatting of worksheets, the use of formulas and functions, the creation, management, and operation of data charts, integration with external applications, and the setup of the work environment. Written in plain and easy-to-understand language with abundant illustrations, this book is suitable for beginners. It can serve as a training textbook for WPS Office courses at all levels and types, as well as a reference book for intermediate and advanced readers, office workers, and teachers. It is particularly suitable for daily learning and office reference use by civil servants in government agencies.