|
Recommended Excel Books
Home »
Excel-Books
The following books are all excellent Excel guides, but they are aimed at users with different skill levels.
Read the review to check that the book is suitable for your skill level, before you consider purchasing any of the books.
The books on this page are split into those written for Excel 2007, and those written for Excel 2003 (or written before Excel 2007 was released).
Click on one of the following links to go to the appropriate section :
|
|
If the book you are interested
in is not on this page, why not
search for it at Amazon.com :
|
|
|
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 2007 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
|
|
|
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
|
|
