The 5 Best Excel Books for All Skill Levels

best excel books -magoosh

Microsoft Excel is one of the best tools for data keeping, applying functions to the data stores, and data analysis. There are many more hidden features too which come along with it. It helps in doing simple and advanced mathematical calculations. A number of people in consulting firms earn lots of money and their work is analysing data on Microsoft Excel. It helps you in school for small projects, in college for analysing the data for lab reports and finally in your job too. It is used even by families to manage their monthly expenses. Such varied and widespread is the use of Microsoft Excel. Thus, knowing the functioning of MS Excel is extremely essential these days.

Here are the books that you can use for developing your skills in MS Excel.

Excel 2010 All-in-One for Dummies’ by Greg Harvey


This book is an entry-level book that you can use to get a good foundation of MS Excel. The book is divided into 8 sections or you can call it 8 books in one single book. These 8 topics will cover almost all basic must-know things like formulas, use of functions, making of charts, performing calculations, data analysis, and VBA. Once you are done with this book you can go for more complex materials to gain specialization in some features of MS Excel.

‘The Mr. Excel Library Series’ by Bill Jelen


This book can be used by you once you are a little clear with the basics as it takes you deeper into advanced Excel functions. The book is really popular and highly recommended by MS Excel experts. The book includes important topics like charts and graphs and also talks about business analysis using MS Excel. 


Slaying Excel Dragons: A beginner’s guide to conquering Excel’s frustrations and making Excel fun’ by Mike Girvin and Bill Jelen.

This book is pretty unique in the sense that it has the content explained in a very interesting way. You will enjoy this book and learn MS Excel at the same time. The techniques are explained along with crisp examples and illustrations in a very interactive way. The book might not be of a very high level but due to its simple way of explaining the basis of MS Excel, you must try it out and use it for a good foundation in MS Excel. 


Excel Charts, by John Walkenbach


This book is for those who know the very basics of MS Excel and are looking to explore Excel charts in a greater detail. This book explains data visualization in great detail and you will also learn about which chart to use in which situation. Use this book learn and understand how to make charts and tables in the most presentable way.


Quick Start Guide from Beginner to Expert, by William Fischer


This book is perfect if you want to learn MS Excel from the basics and then learn things at a higher level too. The book is like a complete package and highly recommended by experts as well. You get to learn basics and even some advanced things, like building macros.

The above books are good resources to help you out in learning MS Excel in a complete way. Apart from the above you can look up more books according to your specifications but do follow the basic books to build a strong base.

All the best!

Comments are closed.


Magoosh blog comment policy: To create the best experience for our readers, we will only approve comments that are relevant to the article, general enough to be helpful to other students, concise, and well-written! 😄 Due to the high volume of comments across all of our blogs, we cannot promise that all comments will receive responses from our instructors.

We highly encourage students to help each other out and respond to other students' comments if you can!

If you are a Premium Magoosh student and would like more personalized service from our instructors, you can use the Help tab on the Magoosh dashboard. Thanks!