IT Career Simulation Center: Excel Office Application

Author: Zhou Bo, Han Qing, Pei Yuqing
Publisher:
Publish Date: 2007-03-01
Features: This book guides readers into a real office environment of a virtual enterprise, teaching them how to use Excel efficiently and effortlessly in the workplace through experiencing common Excel application cases. Each case starts with a "Problem Scenario," followed by "Problem Analysis," "Task Design," and then step-by-step instructions on how to "Complete the Task" and "Complete the Task Better." Finally, it concludes with "Summary of Principles." "Application Practice" and "Self-Test Questions" are provided to assess your learning progress. The book meticulously explains cases such as "Creating an Employee Basic Information Table," "Creating a Payroll Table," "Creating a Pure Bonus Table," "Creating a Task Distribution Chart," "Creating a Product Sales Table," "Analyzing a Product Sales Table," and "Creating a New Employee Training Machine Test Paper." Through learning these cases, readers can easily master the core usage of Excel: table creation and editing, formula application, function application and nesting, chart creation, data processing and analysis, pivot tables, and flexible applications. The book is rich in visuals, engaging, and highly practical. The office scenarios and typical cases provided are ideal for students entering the workforce to prepare for the workplace in advance. It is also suitable for beginners in the workplace who wish to improve their computer office application skills through self-study. Additionally, the book covers most of the exam points for the "Excel Chinese Electronic Spreadsheet Software" module of the "National Computer Professional Qualification Examination," making it an excellent supplementary textbook for that exam module.