Recommended Excel Books

If the book you are looking
for is not on this page,
search for it at Amazon.com:


The following Excel books are all excellent, and are therefore all recommended. The books have been categorised by the version of Excel that they apply to. Click on one of the following links to go to the appropriate section:

Recommended Excel 2016 Books
Recommended Excel 2013 Books
Recommended Excel 2010 Books
Recommended Excel 2007 Books

Excel 2016 Books

Excel 2016 Bible

Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. You will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.

Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible.

Excel 2016 for Dummies

Updated to reflect the latest changes to the Microsoft Office suite, this new edition of Excel For Dummies quickly and painlessly gets you up to speed on mastering the world's most widely used spreadsheet tool. Written by bestselling author Greg Harvey, it has been completely revised and updated to offer you the freshest and most current information to make using the latest version of Excel easy and stress-free.

If the thought of looking at spreadsheet makes your head swell, you've come to the right place. Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest installment of the software, Microsoft Excel 2016. In no time, you'll begin creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, and more. Plus, you'll get easy-to-follow guidance on mastering more advanced skills, like adding hyperlinks to worksheets, saving worksheets as web pages, adding worksheet data to an existing web page, and so much more.

Excel 2016 All-in-One for Dummies

Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic - and beyond. In no time, your Excel skills will go from 'meh' to excellent.

Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros - and everything in between - this hands-on, friendly guide makes working with Excel easier than ever before.

Microsoft Excel 2016 Step By Step

The quick way to learn Excel 2016!

This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers - brisk lessons and full-color screen shots show you exactly what to do, step by step.

  • Quickly set up workbooks, enter data, and format it for easier viewing
  • Perform calculations and find and correct errors
  • Filter, sort, summarize, and combine data
  • Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
  • Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
  • Build data models and use them in business intelligence analyses
  • Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
  • Look up just the tasks and lessons you need

Excel 2016 In Depth

Beyond the Basics ... Beneath the Surface ... In Depth. Do more in less time!

Experienced with Excel? Don't let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016. The result is a focused book where every topic is relevant and worth learning.

Excel 2016 In Depth is the fastest, smartest way to master Excel 2016's full power and updated interface. You'll discover how to leverage Excel's new tools for charting, business analysis, data visualization, forecasting, and more.

Excel 2016 Power Programming with VBA

Maximize your Excel experience with VBA.

Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website.

Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce - and can help you take your career to the next level.

Excel 2016 VBA and Macros

Master core Excel 2016 tools for building powerful, reliable spreadsheets!

Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it ... capture data from anywhere, and use it anywhere ... automate Excel 2016's best new features. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with bonus examples, macros, and solutions - straight from MrExcel!



Excel 2013 Books

Excel 2013 Bible

Excel at Excel with the help of this bestselling spreadsheet guide.

John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.

Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.

Excel 2013 for Dummies

The bestselling Excel book - completely updated for Excel 2013!

As the world's leading spreadsheet application, Excel has an enormous user base. The release of Office 2013 brings major changes to Excel, so Excel For Dummies comes to the rescue once more! Featuring the friendly For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features.

Excel 2013 All-in-One for Dummies

The comprehensive reference, now completely up-to-date for Excel 2013!

As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.

The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

Microsoft Excel 2013 Step By Step

The smart way to learn Excel 2013 - one step at a time!

Experience learning made easy - and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace - building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.

Excel 2013 Formulas

Maximize the power of Excel 2013 formulas with this must-have Excel reference.

John Walkenbach, known as "Mr. Spreadsheet," is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more.

Excel VBA Programming For Dummies

Take control of your spreadsheets and use VBA to create your own custom Excel applications.

Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.

Excel 2013 Power Programming with VBA

Maximize your Excel 2013 experience using VBA application development

The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

Excel 2013 VBA and Macros (MrExcel)

Save time and supercharge Excel 2013 with VBA and Macros!

Use Excel 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues can understand and act on it ... how to capture data from anywhere, and use it anywhere ... how to automate Excel 2013's most valuable new features. Mastering advanced Excel macros has never been easier. You'll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions - straight from MrExcel.



Excel 2010 Books

Excel 2010 Bible

A comprehensive reference to the newest version of the world's most popular spreadsheet application: Excel 2010.

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.

An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won't find anywhere else.

Excel 2010 for Dummies

The bestselling Excel book on the market, updated for Excel 2010.

As the world's leading spreadsheet application, Excel has a huge user base. The release of Office 2010 brings major changes to Excel, so Excel For Dummies comes to the rescue once more!

In the friendly and non-threatening For Dummies style, this popular guide shows beginners how to get up and running with Excel and helps more experienced users get comfortable with new features.

Excel 2010 All-in-One for Dummies

A comprehensive, up-to-date, user-friendly guide to Excel 2010.

Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.

Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

Microsoft Excel 2010 Step By Step

Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010.

With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.

Excel 2010 Formulas

Take your Excel formulas to the next level with this updated reference.

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010.

You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else.

Excel 2010 Workbook for Dummies

Reinforce your understanding of Excel with these Workbook exercises.

Boost your knowledge of important Excel tasks by putting your skills to work in real-world situations. The For Dummies Workbook format provides more than 100 exercises that help you create actual results with Excel so you can gain proficiency.

Perfect for students, people learning Excel on their own, and financial professionals who must plan and execute complex projects in Excel, Excel 2010 Workbook For Dummies helps you discover all the ways this program can work for you.

Excel 2010 Power Programming with VBA

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

VBA and Macros: Microsoft Excel 2010 (Mr Excel)

Save time and supercharge Excle 2010 with VBA and Macros!

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won't find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010's most powerful new features. Learning advanced Excel scripting has never been easier. You'll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.



Excel 2007 Books

Excel 2007 Bible

This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere.

Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else.

John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld's leading authorities on Excel.

Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features.

Includes a valuable CD-ROM with templates and worksheets from the book.

Excel 2007 for Dummies

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you're not in Kansas anymore. Well, have no fear - Excel 2007 for Dummies is here!

If you've never worked with a computer spreadsheet, or if you've had some experience with earlier versions of Excel but need help transitioning, here you'll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

Excel 2007 All-in-One for Dummies

Master the Ribbon, powerful graphics capabilities, and more!

Your one-stop guide to great-looking spreadsheets that actually mean something.

Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!

Microsoft Excel 2007 Step By Step

Experience learning made easy - and quickly teach yourself how to organize, analyze, and present data with Excel 2007.

With Step By Step, you set the pace-building and practicing the skills you need, just when you need them!

Excel 2007 Formulas

This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere.

Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else.

John Walkenbach, aka "Mr. Spreadsheet", is one of the world's leading authorities on Excel.

Thoroughly updated to cover the re-vamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features.

Includes a valuable CD-ROM with templates and worksheets from the book.

Excel 2007 VBA Programming For Dummies

Step-by-step instructions for creating VBA macros.

Harness the power of VBA and create custom Excel applications.

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.