Excel Office Application - IT Workplace Simulation Cabin

Author: Zhou Bo, Han Qing, Pei Jueqing (editors)
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 instructs readers on how to "Complete the Task" and "Complete the Task Better." Finally, it concludes with "Pattern Summary." "Application Practice" and "Self-Assessment Questions" are provided to test your learning outcomes. The book meticulously explains cases such as "Creating an Employee Basic Information Sheet," "Creating a Payroll Sheet," "Creating a Pure Bonus Sheet," "Creating a Task Distribution Chart," "Creating a Product Sales Sheet," "Analyzing a Product Sales Sheet," and "Creating a New Employee Training Machine Test Paper." Through learning, 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 application. The book is illustrated with visuals, engaging, and highly practical. The office scenarios and typical cases provided are especially suitable for students about to enter the workforce to prepare for the workplace. It is also ideal 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 in the "National Computer Professional Qualification Examination," making it an excellent supplementary textbook for that exam module.