Thank you for the invitation. I will recommend some good books I have read to you from the different stages of Excel learning and growth.
In 2017, in order to write a book, I studied most Excel books on the market. From the books I have read, I will choose each type The best book among them, recommended to you.
001 Comprehensive Excel books (recommended learning: web front-end video tutorial)
If you want to learn and use Excel well, laying a good foundation is the final stage, so take it seriously It is very necessary to study 1-2 comprehensive Excel books.
① "Competitiveness: Play with Excel in the workplace and never work overtime" Author: An Weixing et al.
This is my writing based on many years of practice and training This is a comprehensive book on Excel that mainly teaches you Excel tips to improve workplace efficiency.
The positioning of this book is: tools and ideas, that is to say, it not only explains how to use Excel as a tool, but also teaches you some ideas for using it at work.
②"Excel2016 Application Encyclopedia"Author: ExcelHome
This is a comprehensive book with all-inclusive content, covering all aspects of using Excel. If you want to comprehensively understand If you understand Excel technology and are determined to fully apply Excel to your work, this book is a must-read.
The biggest feature of this book is that the editors are all top masters in the Excel field. They all have full insight into the nature of Excel technology. The depth of the content and the practicality of the cases are unmatched by other books.
002 Learning Excel Functions
After studying comprehensive books, the most in-depth study is functions and pivot tables. In these two fields, the quality of the books published by ExcelHome is very high. Let’s talk about functions first.
①"Don't be afraid, Excel functions are actually very simple"
A classic introductory work on function learning. Through illustrations, you can easily learn the most commonly used functions. function.
This book is suitable for new readers, because most of the explanations are single function applications, and there is not much coverage of complex function nesting and array functions.
②"Excel Function and Formula Application Encyclopedia 2013"
This is a book that can qualitatively improve your function and formula skills. It is no exaggeration to say that, After reading this book thoroughly, as long as there are problems that can be solved by functions in Excel, you will find them at your fingertips.
003 Excel Pivot Table Learning
The Pivot Table function is powerful, but the knowledge points involved are not many. I only recommend one book"Excel Pivot Table Application Encyclopedia", this is a masterpiece that comprehensively reveals the inside story of Excel pivot table technology.
Perhaps many people can use pivot tables flexibly without understanding the specific principles. After reading this book, many of your previous questions will be easily answered.
004 Excel charts
There are not many professional books on Excel charts. This "The Way of Excel Charts" (Author: Liu Wanxiang) is undoubtedly the originator of chart books. and "The Sunflower Book."
It is from this book that many people realize that Excel can also produce professional and effective business charts. In the past, everyone's common understanding was that they must be produced with professional drawing tools.
005 VBA
After learning all the major versions of comprehensive classes, functions, pivot tables, and charts, Excel can already solve 90% of the work in the workplace, but there are still two pain points. :
①Unable to truly automate calculations
②Problems that are too complex to solve (or too inefficient)
At this stage, you need to learn VBA. Once you master VBA, you enter a different world. The first recommendation in the VBA field is "Excel2016 Advanced VBA Becomes a Guide" !
006 Power Bi
Of course, if your job is more about data analysis, then learning Power BI may be the easiest way for you to counterattack the Excel master.
There are not many Chinese books on PowerBI at present. I recommend "From Excel to PowerBI, Business Intelligence Data Analysis" written by a good friend of mine.
The above is the detailed content of Books for learning excel. For more information, please follow other related articles on the PHP Chinese website!