Martin Green's Office Tips
|   Home   |   Excel   |   Access   |   Word   |   Outlook   |   VBA   |   eBooks   |   Handouts   |   Site Index   |   RSS   |
Excel Bookshelf
  Group training for Excel and Access for just 425.
  1-to-1 training for Excel and Access for just 275.    

WWW    Office Tips

Are you looking for Microsoft Office training for yourself, your colleagues or your staff? If you like what you see here you can get personal training from me. Find out more on my Training Page.

Development & Consultancy

Do you need someone to build you an Access database or an application in Excel? Or perhaps you are just looking for help and advice. I can help. Find out about my development and consultancy services on my Consultancy Page.


Recommended Books: Microsoft Excel

Here you will find my recommendations for books on Microsoft Excel. But don't just take my word for it! You can follow the links to the online bookstore at (USA) or (UK) where you will find more details and reader reviews.

Buy this book from
Excel 2010 Power Programming with VBA

Author: John Walkenbach
ISBN-13: 9780470475355

If you were to buy just one book on Excel programming then this is it! John Walkenbach is a well-known and respected Excel guru. His web site The Spreadsheet Page is often the first port of call when I'm looking for the answer to an Excel VBA problem. This book covers most of the topics you are ever likely to encounter working with Excel VBA and contains a wealth of sample code. The author's writing style makes this book suitable for both novice and experienced Excel programmers. If you work with a different version of Excel you can follow one of the links below:

Microsoft Excel 2007 Power Programming with VBA
ISBN-13: 9780470044018
Find it at (USA) or (UK)

Microsoft Excel 2013 Power Programming with VBA
ISBN-13: 9781118490396
Find it at (USA) or (UK)

Buy this book from
Buy this book from
PowerPivot for Excel 2010

Authors: Marco Russo & Alberto Ferrari
ISBN-13: 9780735640580

As a trainer I love it when I get "oohs and aahs" from the people I'm training. When I introduce them to PowerPivot in Excel is one of those times. PowerPivot is a free Add-in from Microsoft that works with Excel 2010 and 2013. Easy to use, it adds enormous power to data analysis, allowing Excel to interface with almost any data source from SQL Server to Access and even plain text files. Its processing power lets you work with anything from a few hundred rows of data to hundreds of millions of rows, all from the familiar Excel environment. With PowerPivot Excel can work like a relational database, linking tables of data for analysis in its own PivotTables and PivotCharts, and presenting it in professional looking dashboards. In this book Marco Russo and Alberto Ferrari have done a brilliant job of explaining how to get the best out of your data and cover all aspects of PowerPivot from importing data, calculating and manipulating data with DAX (Data Analysis Expressions) to creating sophisticated data models. Anyone who works with data in Excel should get this book! There's a revised version for Excel 2013, follow the links below:

Microsoft Excel 2013: Building Data Models With PowerPivot
ISBN-13: 9780735676343
Find it at (USA) or (UK)

Buy this book from
Buy this book from
Excel 2007 Data Analysis for Dummies

Authors: Stephen L Nelson
ISBN-13: 9780470045992

If I'm embarking on an unfamiliar topic I often start with a Dummies book. I have a shelf full of them! Often that's all I need to get me up and running. The Dummies style is great at telling you exactly what you need to know in an easy and understandable style. This book is no exception. If you need to analyse data in Excel and don't know where to start, or maybe you need some new ideas, this book is for you. Starting with obtaining and cleaning data, it guides the reader through the intricacies of pivot tables and pivot charts before getting down to some serious data analysis and modelling. You'll learn how to use all those data and statistical functions in Excel and get some great tips for presenting your data. Written for Excel 2007 its topics are relevant for all the current versions of Excel from Excel 2003 to 2010 and 2013.

Buy this book from
Buy this book from
Excel 2010 Formulas

Author: John Walkenbach
ISBN-13: 9780470475362

Calculating is what Excel does best but most Excel users make use of only a fraction of what the program can do for them. As Excel has been developed successive versions have made the writing of formulas more intuitive for the user but most people still need help and guidance when it comes to creating anything more than the most basic of formulas. As usual Mr Spreadsheet, the renowned Excel guru John Walkenbach, comes to the rescue. In Excel 2010 Formulas the author shows you how to create powerful formulas and guides you through the wealth of functions available in Excel. There are chapters explaining how to use financial functions, demistifying array functions, and even how to create your own custom functions with VBA. This book should be on every Excel user's bookshelf. If you work with another version of Excel follow one of the links below:

Excel 2007 Formulas
ISBN-13: 9780470044025
Find it at (USA) or (UK)

Excel 2013 Formulas
ISBN-13: 9781118490440
Find it at (USA) or (UK)

Buy this book from


  ©2000-2013 Martin Green All rights reserved