Recommended Excel Books

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


The following Excel books are all excellent Excel guides, and are therefore all recommended. However, they are aimed at users with varying skill levels. Therefore, as well as a short review, we have also included a guide to each book's complexity, so that you can easily choose a book that is suitable for your skill level.

The books on this page are split into those written for Excel 2010, those written for Excel 2007, and those written for Excel 2003. Click on one of the following links to go to the appropriate section :

Recommended Excel 2010 Books

Recommended Excel 2007 Books

Recommended Excel 2003 Books


  Excel 2010 Books

Excel 2010 for Dummies

This book is fantastic for Excel Novices, and is also useful for users of earlier versions of Excel, who want to update themselves with the new features of Excel 2010. The Excel 2010 commands, tools and functionality are explained in enough detail to enable the complete beginner to aquire confidence with the basics of Excel 2010 spreadsheets, and the style of writing is readable and entertaining, making the information easy to absorb and understand.

More advanced Excel users will probably find some new ideas to enhance their existing Excel skills, although they may find some areas of the book too basic for their needs.

Level: Novice - Intermediate

Microsoft Office 2010 All-in-One for Dummies

This book provides an excellent overview of the basics of each of the Microsoft Office 2010 programs, and is recommended for Microsoft Office beginners, who want to ensure that they have an understanding of all the programs in the Microsoft Office suite. Also, if you have previously used earlier versions of Microsoft Office, and want to familiarise yourself with the additional features in Office 2010, this book will bring you up to speed.

Like the other "For Dummies" books, the style of writing is light and easy to read, and it is likely that users of all levels will pick up some useful tips. However, as the book covers all the Microsoft Office products, it may not provide enough depth for those wishing to develop their skills in any one Office program (such as Excel), to an advanced level.

Level: Novice

Excel 2010 Bible

If you need the ultimate encyclopedia of Excel 2010, this is the book for you. The book covers everything you could possibly need to know about Excel, starting with the most basic functionality and progressing to more advanced tools.

The book also includes an introduction to Macro programming, although those wanting to become proficient at Excel VBA programming will need to also read some more in-depth VBA literature.

Recommended as an excellent reference book.

Level: Novice - Advanced

Excel 2010 Formulas

This book doesn't focus on the basic Excel operations, so is not suitable for complete beginners. Instead it gets straight into a discussion of formulas, using Excel's built-in functions, including the new functions that have been introduced into Excel 2010.

The book discusses Excel Array formulas, debugging methods and provides an introduction to user-defined formulas, through the use of Macros.

Recommended for intermediate to advanced Excel users.

Level: Intermediate - Advanced

Excel Workbook for Dummies

If you want to learn the basics of Excel, this is a good book for beginners. It will take you from the simple procedure of entering data, to the more advanced features, such as functions, formulas and basic Excel Macros.

Like the other "For Dummies" books, the writing is clear and entertaining, making the books easy to read and understand. This is a great book for beginners to intermediate Excel users, which is likely to also provide more advanced Excel users with a few new tips.

Level: Novice - Intermediate

Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets

I can't recommend this book highly enough! It really encouraged me to think about different ways to implement Excel functions and formulas, in order to achieve actions that I previously thought required macro programming.

Though the book is mostly aimed at users with some experience of Excel functions and formulas, the tips are graded, in terms of difficulty, so the novice could read the easier tips and progress to the more advanced ones over time. ... Highly recommended!

Level: Intermediate to Advanced

Excel VBA Programming for Dummies

Yet another book in the "For Dummies" series, which, as always, is written in a clear, light-hearted style. You should beware though, that Excel VBA programming is not an easy subject, so don't take the "For Dummies" label too seriously. However, for those who are confident with functions and formulas and want to further their Excel skills, this is a great introduction to Excel macros.

The book starts with the basics, such as the VBA editor and how to enter a macro, and leads you through the process of creating, running and debugging Excel macros.

Recommended for Intermediate - Advanced Excel users

Level: Intermediate - Advanced

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Most people use Excel for relatively simple tasks, and are unaware of the full extent of the program. Here is a book that takes your Excel skills to a completely new level. The book provides an explanation of how to develop professional-quality Excel-based applications that run efficiently and smoothly.

This book is not for Excel beginners. However, if you are confident with Excel and want to develop your skills to a professional level, this is the book for you.

Highly recommended for Advanced Excel users.

Level: Advanced


  Excel 2007 Books

Excel 2007 for Dummies

This book is fantastic for Excel Novices, and is also useful for Excel 2003 users, who want to update themselves with the new features of Excel 2007, such as the new user interface, conditional formatting, sorting and filtering by colour, etc. The Excel 2007 commands, tools and functionality are explained in enough detail to enable the complete beginner to aquire confidence with the basics of Excel 2007 spreadsheets, and the style of writing is readable and entertaining, making the information easy to absorb and understand.

More advanced Excel users will probably find some new ideas to enhance their existing Excel skills, although they may find some areas of the book too basic for their needs.

Level: Novice - Intermediate

Office 2007 All-in-One Desk Reference for Dummies

This book provides an excellent overview of the basics of each of the Microsoft Office 2007 programs, and is recommended for Microsoft Office beginners, who want to ensure that they have an understanding of all the programs in the Microsoft Office suite. Also, if you have previously used Office 2003 and want to familiarise yourself with the additional features in Office 2007, this book will bring you up to speed.

Like the other "For Dummies" books, the style of writing is light and easy to read, and it is likely that users of all levels will pick up some useful tips. However, as the book covers all the Microsoft Office products, it may not provide enough depth for those wishing to develop their skills in any one Office program (such as Excel), to an advanced level.

Level: Novice

Excel 2007 Bible

If you need the ultimate encyclopedia of Excel 2007, this is the book for you. The book covers everything you could possibly need to know about Excel, starting with the most basic functionality and progressing to more advanced tools.

The book also includes an introduction to Macro programming, although those wanting to become proficient at Excel VBA programming will need to also read some more in-depth VBA literature.

Recommended as an excellent reference book.

Level: Novice - Advanced

Excel 2007 Formulas

This book doesn't focus on the basic Excel operations, so is not suitable for complete beginners. Instead it gets straight into a discussion of formulas, using Excel's built-in functions, including the new functions that have been introduced into Excel 2007.

The book discusses Excel Array formulas, debugging methods and provides an introduction to user-defined formulas, through the use of Macros.

Recommended for intermediate to advanced Excel users.

Level: Intermediate - Advanced

Microsoft Office Excel 2007 Formulas and Functions for Dummies

In line with other books in the "For Dummies" series, this book is written in a clear and entertaining style. However, do not make the mistake of thinking that the book is suitable for complete beginners. - You really should have a good foundation in basic Excel before approaching this book.

If you do have some basic Excel skills, then this book is ideal for devoloping your understanding of Excel formulas and functions, and for showing you how to make the most of Excel formulas. It provides practical examples that aim to show you the best ways to develop your basic spreadsheet into a professional document. The book particularly focuses on the built-in functions in Excel, and is up-to-date in that it is written for Excel 2007.

Recommended for users with some experience of Excel

Level: Intermediate

Excel Workbook for Dummies

If you want to learn the basics of Excel, this is a good book for beginners. It will take you from the simple procedure of entering data, to the more advanced features, such as functions, formulas and basic Excel Macros.

Like the other "For Dummies" books, the writing is clear and entertaining, making the books easy to read and understand. This is a great book for beginners to intermediate Excel users, which is likely to also provide more advanced Excel users with a few new tips.

Level: Novice - Intermediate

Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets

I can't recommend this book highly enough! It really encouraged me to think about different ways to implement Excel functions and formulas, in order to achieve actions that I previously thought required macro programming.

Though the book is mostly aimed at users with some experience of Excel functions and formulas, the tips are graded, in terms of difficulty, so the novice could read the easier tips and progress to the more advanced ones over time. ... Highly recommended!

Level: Intermediate to Advanced

Excel VBA Programming for Dummies

Yet another book in the "For Dummies" series, which, as always, is written in a clear, light-hearted style. You should beware though, that Excel VBA programming is not an easy subject, so don't take the "For Dummies" label too seriously. However, for those who are confident with functions and formulas and want to take their Excel skills to the next level, this is a great introduction to Excel macros.

The book starts with the basics, such as the VBA editor and how to enter a macro, and leads you through the process of creating, running and debugging Excel macros.

Recommended for Intermediate - Advanced Excel users

Level: Intermediate - Advanced

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Most people use Excel for relatively simple tasks, and are unaware of the full extent of the program. Here is a book that takes your Excel skills to a completely new level. The book provides an explanation of how to develop professional-quality Excel-based applications that run efficiently and smoothly.

This book is not for Excel beginners. However, if you are confident with Excel and want to develop your skills to a professional level, this is the book for you.

Highly recommended for Advanced Excel users.

Level: Advanced


  Excel 2003 Books

Excel 2003 for Dummies

This book is fantastic for Excel Novices. The Excel 2003 commands, tools and functionality are explained in enough detail to enable the complete beginner to aquire confidence with the basics of Excel 2003 spreadsheets, and the style of writing is readable and entertaining, making the information easy to absorb and understand.

More advanced Excel users will probably find some new ideas to enhance their existing Excel skills, although they may find some areas of the book too basic for their needs.

Level: Novice - Intermediate

Office 2003 All-in-One Desk Reference for Dummies

This book provides an excellent overview of the basics of each of the Microsoft Office 2007 programs, and is recommended for Microsoft Office beginners, who want to ensure that they have an understanding of all the programs in the Microsoft Office suite.

Like the other "For Dummies" books, the style of writing is light and easy to read, and it is likely that users of all levels will pick up some useful tips. However, as the book covers all the Microsoft Office products, it may not provide enough depth for those wishing to develop their skills in any one Office program (such as Excel), to an advanced level.

Level: Novice

Excel 2003 Bible

If you need the ultimate encyclopedia of Excel 2003, this is the book for you. The book covers everything you could possibly need to know about Excel, starting with the most basic functionality and progressing to more advanced tools.

The book also includes an introduction to Macro programming, although those wanting to become proficient at Excel VBA programming will need to also read some more in-depth VBA literature.

Recommended as an excellent reference book.

Level: Novice - Advanced

Excel Formulas and Functions for Dummies

In line with other books in the "For Dummies" series, this book is written in a clear and entertaining style. However, do not make the mistake of thinking that the book is suitable for complete beginners. - You really should have a good foundation in basic Excel before approaching this book.

If you do have some basic Excel skills, then this book is ideal for devoloping your understanding of Excel formulas and functions, and for showing you how to make the most of Excel formulas. It provides practical examples that aim to show you the best ways to progress your basic spreadsheet into a professional document. The book particularly focuses on the built-in functions in Excel, rather than the more complex user defined macro functions.

Recommended for users with some experience of Excel

Level: Intermediate

Excel 2003 Formulas

This book doesn't focus on the basic Excel operations, so is not suitable for complete beginners. Instead it gets straight into a discussion of formulas, using Excel's built-in functions.

The book discusses Excel Array formulas, debugging methods and provides an introduction to user-defined formulas, through the use of Macros.

Recommended for intermediate to advanced Excel users.

Level: Intermediate - Advanced

Excel Workbook for Dummies

If you want to learn the basics of Excel, this is a good book for beginners. It will take you from the simple procedure of entering data, to the more advanced features, such as functions, formulas and basic Excel Macros.

Like the other "For Dummies" books, the writing is clear and entertaining, making the books easy to read and understand. This is a great book for beginners to intermediate Excel users, which is likely to also provide more advanced Excel users with a few new tips.

Level: Novice - Intermediate

Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets

I can't recommend this book highly enough! It really encouraged me to think about different ways to implement Excel functions and formulas, in order to achieve actions that I previously thought required macro programming.

Though the book is mostly aimed at users with some experience of Excel functions and formulas, the tips are graded, in terms of difficulty, so the novice could read the easier tips and progress to the more advanced ones over time. ... Highly recommended!

Level: Intermediate to Advanced

Excel VBA Programming for Dummies

Yet another book in the "For Dummies" series, which, as always, is written in a clear, light-hearted style. You should beware though, that Excel VBA programming is not an easy subject, so don't take the "For Dummies" label too seriously. However, for those who are confident with functions and formulas and want to take their Excel skills to the next level, this is a great introduction to Excel macros.

The book starts from basics, such as the VBA editor and how to enter a macro, and leads you through the process of creating, running and debugging Excel macros.

Recommended for Intermediate - Advanced Excel users

Level: Intermediate - Advanced

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Most people use Excel for relatively simple tasks, and are unaware of the full extent of the program. Here is a book that takes your Excel skills to a completely new level. The book provides an explanation of how to develop professional-quality Excel-based applications that run efficiently and smoothly.

This book is not for Excel beginners. However, if you are confident with Excel and want to develop your skills to a professional level, this is the book for you.

Highly recommended for Advanced Excel users.

Level: Advanced


Return to the ExcelFunctions.net Home Page

Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net