Excel Data Analysis in Practice
Tags
Summary
This book can be used as a textbook for data analysis majors in secondary vocational schools and higher vocational colleges, and also as a self-study book for data analysis enthusiasts. It is hoped that by studying this book, readers will develop the craftsman spirit of dedication,精益求精, focus, and innovation, establish a correct outlook on consumption, and carry forward the spirit of hard work and thrift.
Editor's review
The core value of this book lies in the word practice. It does not fall into the trap of showcasing complex functions, but instead focuses on solving real problems in data analysis, such as how to use PivotTables for rapid multidimensional summary analysis, how to use Power Query to efficiently handle non-standard data sources, and how to use charts to clearly communicate analytical conclusions. These are precisely the key bottlenecks that many Excel users face in moving from being able to use it to mastering it. The cases in the book are close to common scenarios such as business analysis, operational review, and financial reporting, and have high transfer value.
For readers with some Excel foundation who hope to break through bottlenecks and improve work efficiency and data insight, this book is an excellent roadmap. It helps readers build the mindset for structured data analysis with Excel, rather than merely learning isolated functions. Of course, the depth of this book is better suited to advanced users who want to use Excel as their main daily analysis tool; readers seeking programming-level data analysis or big data processing may need to combine it with other tools.
Who it's for
A good fit for
- Professionals with basic Excel skills who want to systematically learn data analysis methods
- Report writers who frequently need to process large amounts of data and conduct summary and analysis
- Practitioners in marketing, operations, finance, and other roles who need to identify problems and support decisions through data
- Learners who want to turn messy data into clear charts and conclusions to improve the quality of work reports
Not a good fit for
- Readers who expect to learn VBA programming or advanced data analysis languages such as Python
- Complete beginners looking for an introductory Excel tutorial from scratch
Reading tips
- It is recommended to study the chapters in order; the cases in this book are coherent and build knowledge progressively
- Be sure to open Excel and follow along while studying; completing the cases hands-on leaves a deeper impression than reading alone
- Try applying the analytical methods in the book to your own real work data for practice and reinforcement
About the publisher
Posts & Telecom Press is known for its strengths in science and technology, computing, and information and communications titles, and has extended its publishing into photography, art, software learning, and inspirational growth, giving it a fairly diverse range. Its catalog includes computing and communications works such as Refactoring and Patterns (Revised Edition) and Huawei Switch Learning Guide (Second Edition), alongside bilingual collector's editions such as The Little Prince (Chinese-English-French illustrated collector's edition), The Great Gatsby, and Three Days to See. Beijing Ten Years: 1980-1990 and Ghost Blade: WLOP Personal Illustration Collection reflect its presence in photography and art. Its authors include Antoine de Saint-Exupéry, Helen Keller, Joshua Kerievsky, Wang Da, Zhang Zhaozeng, and WLOP.
Contents
- 版权信息
- 内容提要
- 序
- 前言
- 第一篇 概述
- 项目1 学生校园消费行为概述
- 第二篇 数据获取
- 项目2 获取文本数据
- 第三篇 数据处理
- 项目3 制作消费金额的描述性统计分析表
- 项目4 处理异常值
- 项目5 处理缺失值
- 项目6 处理重复值
- 项目7 使用Power Query方法处理数据
- 项目8 合并数据
- 第四篇 数据分析与可视化
- 项目9 分析食堂就餐情况
- 项目10 分析学生就餐消费行为
- 项目11 撰写分析报告
FAQ
How much Excel background does this book require?
Are the case data and analysis templates in the book provided?
Which version of Excel does this book mainly cover?
Comments
Find this book
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
Xiao Meijiao is an author about whom little public information is available. Only one work by this author is held in the collection, Excel Data Analysis Practice. According to the available information, the book is classified under examinations, suggesting that its content may be aimed at exam preparation or skills assessment and centers on the practical use of Excel in data processing and analysis. No further verifiable connection can be established between the author's name and the subject matter of the work; the author's nationality, dates of birth and death, educational background, and professional positions have not been reliably recorded, so no speculation about personal biography is appropriate. As for writing style, a single work does not allow a full assessment, but it does indicate a practical orientation that combines tool operation with examination requirements and emphasizes applicability and hands-on use. For readers who need to master basic Excel data analysis skills, such a work may offer some reference value.
Zhang Liangjun is a Chinese author of books on computing and data analysis. Public information about him is limited, and his biography, nationality, and educational background remain unclear. Judging from the seven titles held in the collection, his writing centers on two areas: programming design and data processing. His works range from introductory programming topics such as Python and R to practical content on Excel data acquisition, processing, and analysis, as well as Power BI data analysis and visualization. Aimed at beginners and everyday office application scenarios, the books combine tool operations with examples and emphasize a gradual path from basic syntax to practical analysis, while also serving exam and teaching needs. These titles fall under categories including programming design, general computing, and examinations, and are suitable for Chinese readers who wish to systematically learn data analysis tools and programming fundamentals.
Ye Mingzhu is an author for whom publicly available information is currently limited; details such as nationality, dates of birth and death, and educational background are not clearly recorded. According to the library's holdings, Ye Mingzhu has one work, Excel Data Analysis Practice, which is classified under exams. This suggests that the book is likely intended for exam preparation, teaching, or skills training, with a focus on helping readers master the practical use of Excel in data processing and analysis. Books of this kind usually emphasize tool use and task-based exercises, with clear steps and concrete examples that allow readers to learn through practice. Ye Mingzhu's writing style and overall influence require more material for a full assessment. Readers who choose this book should consider their own learning goals and exam requirements, and pay attention to its methodological explanations and practice arrangements, so as to improve their practical data analysis skills more effectively.
Huang Lihong is an author about whom public information is currently very limited; basic details such as nationality, dates of birth and death, and an English name cannot yet be confirmed. According to the library's holdings, the only work attributed to this name is Excel Data Analysis Practice, commonly classified under exam preparation. On this basis, it can be inferred that the author focuses on the practical use of spreadsheet tools and training in data-processing skills. The book takes Excel as its operating platform and works through the processes and methods of data analysis, addressing learners and exam candidates who need to master practical skills. Overall, the author's writing orientation is operational and applied, emphasizing the use of tools in concrete tasks rather than abstract theoretical exposition. Because the available material is limited, the author's other experiences, academic background, and broader body of work cannot yet be introduced; further public information would be needed for a fuller account.
