Excel 2016 Office Applications from Beginner to Mastery

Longma Gaoxin EducationPeking University Press · ChinaAug 2025

Rating 3.1
Word count
108K words
Chapters
32
ISBN
9787301271247

Tags

Software Tutorials Step-by-Step GuidePractical GuideCase AnalysisSelf-Study GuideBeginner Friendly

Summary

Excel 2016 Office Applications: From Beginner to Master: Drawing on 10 years of teaching experience, it guides readers through the entire process from beginner to master! A large number of typical cases drawn from actual work are explained in detail and closely match readers' needs, simulating a real work environment to rapidly improve office efficiency and help readers finish their work ahead of time. Expert tips from years of research reveal the essence of using Excel efficiently. The first three-in-one cross-platform office learning package covering PC office work, online office work, and mobile office work includes the use of apps such as cloud drives, WeChat, QQ, Office, and WPS, as well as tips for searching resources, handling oversized emails, managing contacts, and managing time, making office work possible anywhere.

Editor's review

This book focuses on Excel 2016 office applications and is positioned along the learning path "from beginner to master," making it suitable for workplace readers who want to systematically build spreadsheet-processing skills. Its value lies not in listing functions or menus but in explaining software operations within real office tasks. With cases drawn from actual work, readers understand the purpose of each operation in a simulated work environment, thereby improving efficiency in handling data and reports. The book also includes "Expert Tips"-style content that emphasizes ways of thinking about using Excel efficiently rather than merely memorizing steps, which is especially useful for readers who can already use basic functions but lack methodology. Another feature is its cross-platform office perspective: in addition to PC Excel operations, it covers the use of applications such as cloud drives, WeChat, QQ, Office, and WPS, as well as tips for searching resources, handling oversized emails, and managing contacts and time, so learning does not stop at the software itself but extends to daily office collaboration scenarios. Overall, it is suitable as a desk reference book to use alongside practice and also as reference reading for internal training within an organization. When reading, it is advisable to practice simultaneously with your own worksheets; this is more effective than merely reading.

Who it's for

A good fit for

Not a good fit for

Reading tips

  1. First read the table of contents and prioritize the modules most urgently needed for current work; there is no need to read page by page from the beginning.
  2. After learning each case, reproduce the operation on your own computer and replace it with your own data for practice.
  3. Separately organize the "Expert Tips"-style content into notes to form a personal operation checklist.
  4. The cross-platform office chapters can be consulted as needed when actually using cloud drives and email collaboration.

About the publisher

Peking University Press China · Founded in 1979

Peking University Press is a comprehensive university press whose publishing areas cover classical literature, popular science, social culture, world history, Western philosophy, and culture. Its catalogue contains 6,031 titles, with representative books including A Dream of Red Mansions, Relativity: The Special and General Theory (15th Edition) (with Einstein's classic papers on unified field theory and other topics), Elements, Conics, The Aristocratic Families of the Eastern Jin, The Philosophy of Mythology (Volume I), The Philosophy of Mythology (Volume II), and The Origin of Continents and Oceans. Representative authors include Cao Xueqin, Zhou Ruchang, Albert Einstein, Euclid, Apollonius, Tian Yuqing, Schelling, and Xian Gang. The press has developed distinctive strengths in classical Chinese literature and in the translation of Western philosophical classics, while also covering scientific classics and social and cultural studies. As public information is limited, this description is based only on the books in the catalogue and offers no further extrapolation.

Contents

  1. 版权信息
  2. 前言
  3. 为什么要阅读本书
  4. 本书读者对象
  5. 后续服务：QQ群（218192911）答疑
  6. 创作者说
  7. 第0章 Excel最佳学习方法
  8. 0.1 Excel都可以在哪些地方应用
  9. 0.2 不同行业对Excel的技能要求
  10. 0.3 必须避免的Excel办公学习误区
  11. 0.4 如何成为Excel办公高手
  12. 第1篇 快速入门篇
  13. 第1章 快速上手—Excel 2016的安装与配置
  14. 第2章 Excel 2016的基本操作
  15. 第3章 工作表的编辑与数据输入技巧
  16. 第4章 工作表美化设计及数据的查看
  17. 第2篇 公式函数篇
  18. 第5章 简单数据的快速计算—公式
  19. 第6章 复杂数据的处理技巧—函数
  20. 第3篇 数据分析篇
  21. 第7章 初级数据处理与分析—数据列表管理
  22. 第8章 中级数据处理与分析—图表的应用
  23. 第9章 专业数据的分析—数据透视表和透视图
  24. 第4篇 高效办公实战篇
  25. 第10章 Excel在企业办公中的高效应用
  26. 第11章 Excel在人力资源中的高效应用
  27. 第12章 Excel在市场营销中的高效应用
  28. 第13章 Excel在财务管理中的高效应用
  29. 第5篇 高手秘籍篇
  30. 第14章 Excel文档的打印
  31. 第15章 宏与VBA的应用
  32. 第16章 Office组件间的协作

FAQ

Can a beginner with no prior knowledge read this book directly? Yes. The book is positioned as going from beginner to master. Basic operations are explained, and the cases are close to actual work. However, it is recommended to first master basic content such as the interface, cells, and formulas in chapter order before moving on to comprehensive cases. When encountering unfamiliar menus, operate the software simultaneously to avoid only reading without practicing.
Do the cases in the book require additional materials? According to the information, the book explains operations through typical cases drawn from actual work. When learning, you can replace the case data with your own work data for simultaneous practice. If the book provides materials, use them according to the corresponding chapters; if not, constructing simple spreadsheets yourself can likewise complete the operation practice.
Is the cross-platform office content helpful for learning Excel? Yes. The information shows that the book covers applications such as cloud drives, WeChat, QQ, Office, and WPS, as well as tips for email and time management. This content can help readers embed spreadsheet processing into daily collaboration processes, such as file sharing, transmission, and collaborative processing, and is an extension of office-scenario capabilities.
Is this book suitable as a reference book to consult at any time? Yes. The book organizes content by office application, and the cases and operation steps are relatively independent. When encountering a specific task, you can first check the table of contents to locate the relevant chapter and then follow the operations. It is recommended to mark the locations of commonly used functions on the pages or in notes to form a personal index and improve lookup efficiency.

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

Longma Gaoxin Education Author

Founded in 1998, Longma Gaoxin Education is an educational publishing organization specializing in the planning and writing of computer-related books. It is affiliated with Longma Studio and has long cooperated with multiple universities, industry associations, and websites. Its works cover areas such as software learning, general computing, and architecture, focusing on commonly used software including Office, Word, Excel, and AutoCAD. It has developed series such as "From Beginner to Master," "Complete Self-Study Manual," and "Programming Treasure," with 68 titles in the library. Its writing emphasizes progressive difficulty, clear steps, and close alignment with practical operation, making it easy for beginners and self-learners to follow. The organization has won the National Excellent Bestseller Award multiple times and has a certain influence in the field of popular computer reading materials. Due to limited public information, its staffing and detailed development history are not elaborated here.