• Home
  • Blog
  • Resume
  • Contact
  • Projects
  • Gallery
  • Amit’s Resume
  • About Nagpur
KEEP IN TOUCH

Excel Books

Sep06
2007
Leave a Comment Written by admin

Books on my shelf:
Professional Excel Development by Stephen Bullen, Rob Bovey

This is by far the most authoritative book on Excel development from Add-ins to APIs. A word of caution though, it is not for the beginners.

Excel Advanced Report Development by Timothy Zapawa

Ever wondered on using Excel as a report development tool? This might be an answer to it; however, my problem with this book is that it focuses too much on pivottables, and because of that it doesn?t do justification to the name of the book. At any rate, this is very good book to exploit pivottable to its limits.

Excel 2007 Power Programming with VBA by John Walkenbach

Of course, it cannot happen that you talk about Excel books and don?t mention Mr. Spreadsheet himself. I am his fan on personal and professional level. On personal level, I love his blog, and on professional level, I like his lucid language in his books. I recommend reading his books and blog both.
Excel 2003 Formulas by John Walkenbach

You thought you knew formulas? Just read this book and you?ll realize, which I do almost every day, that there just so much about Excel that we don?t know. John uses simple language, and introduces the readers from basic to advanced formulas. How advance you might ask, well, here is an example, which uses a formula similar to this:

Excel 2007 Formulas by John Walkenbach
Books I have Read:
Data Analysis and Decision Making with Microsoft Excel by S. Christian Albright

I borrowed this book from the library. It is a very good for beginners.

Excel 2003 Power Programming with VBA by John Walkenbach
Integrating Excel and Access by Michael Schmalz

I borrowed this book from the library too. Excellent reference on developing applications using Access, Excel, and VBA.
Mr Excel ON EXCEL by Bill Jelen

This is my first book I read on Excel, which is written by Bill Jelen aka Mr. Excel. Fantastic book. If you have begun knowing Excel just now, obtain a copy of this book right away. This is the right start for beginners. It uses very simple and clear language, and Bill provides great examples to make the learning useful.

Guerilla Data Analysis Using Microsoft Excel by Bill Jelen

I had an e-version of this book, but for some reason it’s not working anymore. I had chewed on this book a lot. It?s a great book for starters, especially, in data crunching.

Related posts:

  1. Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
Posted in Books - Tagged Access, Bill Jelen, John Walkenbach, VBA
SHARE THIS Twitter Facebook Delicious StumbleUpon E-mail
« A function to reverse a string
» Convert Text to Uppercase

No Comments Yet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

Tags

Access Alt F8 Books boxplot cells charts count cursor dashboard data mining dbase design error excel excel functions export filter flip LaTex MS query Number Err ODBC pipes Press Alt F11 Public Sub python R random numbers Range Cells report scripting software sparklines SQL SQL server stack columns statistics stemming string tag cloud text mining UDF VBA visualization wildcard

Network

View Ashutosh Nandeshwar's profile on LinkedIn

Recent Comments

  • W. McNabb on The search key was not found in any record in Access
  • Manuel on The search key was not found in any record in Access
  • Wendy Naples on The search key was not found in any record in Access
  • larry on Access Export to Excel (2007)
  • Betty Chou on Projects

Related Posts

  1. Super-Easy Guide to the Microsoft Office Excel 2003 Object Model

EvoLve theme by Blogatize  •  Powered by WordPress nandeshwar.info