Title: "Financial Elites Are Excel Control".
Author: Liu Yang.
Publisher: China Railway Press***
Whether you are a white-collar worker, a pink-collar office worker, or a financial practitioner, recommending this book today may help you one day in the future and make your work more effective with half the effort.
The author of this book, Liu Yang, is a senior accountant, CMA, a master of accounting from 211 key universities, and a senior financial manager, with many years of experience in financial management of large enterprises, and has a lot of practical experience in the fields of financial analysis and integration of industry and finance. It was these experiences that helped him better to complete this book.
Are you still worried that the data handed over to you by the boss does not know how to summarize and how to merge the reports?
How to make a business analysis kanban through the pivot table, which can go straight to the specific situation of the company's comprehensive sales and salesman ranking, see P54 for details
The book contains eight business and decision-making models, four efficient office dimensions, and a full financial scenario drill.
The book is divided into seven chapters:
1.Steps and structure of financial analysis.
2.Easily handle data aggregation and report consolidation.
3.Pivot tables to create business analysis dashboards.
4.Functions necessary for building financial analysis models.
5.How to present financial data in a business table.
6.The application of dynamic controls in financial analysis.
7.Excel eight business and decision-making model practice.
Chapter 4 covers 17 functions, all of which are useful to address the needs of our work.
Chapter 5 is the use of business tables to present financial data, here are the practical exercises of financial analysis charts, 13 chart practices, teach you how to do a good job of financial analysis charts.
Personally, I think that as an office clerk, the content of these two chapters is very useful and sufficient for me. This is an Excel book on the practicality of office skills.
For beginners who have no work experience, this book can better complete work tasks and reduce work burden.
Each chapter of the book is explained with examples, so it is not difficult for us to understand, and we can also practice on the computer while watching, and have a step-by-step solution process idea. It is beneficial for the reader to understand.
The author uses his previous experience to integrate the content of the book into the explanation, rather than rigidly talking about the concept, focusing on the practical part, if the concept is transferred to the content mastered by the reader. This is the highlight of the book.
And how to make the color of the chart tall in this chapter, because the charts are all black and white, so you can't see the effect clearly, if there is a color plate, it would be good.
This should be a beginner version of Excel basics, and I hope the author can still come out with a mid-to-advanced version.
If you're still struggling to figure out how to make a good diagram, this book is a great helper.