• # Recommended Books

In the interests of full disclosure here, each of these images contains an affiliate link, so I do make a (small) amount of money if you click through and purchase. If you find that offensive, you can always go directly to the site in question and purchase direct.

RibbonX - Customizing the Office 2007 Ribbon

Naturally, I get to plug this one first, since it's mine! This is the definitive guide for customizing the Ribbon in Office 2007 (and higher):

Excel Books

I've always been a fan of John Walkenbach's books. I've found them very easy to read, and packed with information. To my mind, you can't go wrong with one of John's books. He's got a ton of them, so even if you need a different version, hop over to Amazon and look for the same title with a different version number.

PivotTable Books

If you love PivotTables, or want to know more about them, then you'll want to read:

Charting Books

Data Visualization Theory Books

Other Books
And if you want to get into serious Excel development, this is the book for you:

Obviously there are a lot more books out there as well. Do you have any favourites? Post them in the comments!

I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

• ### Recent Forum Posts

#### Look up left / right cell to get maximum value

Assuming the word "Country" is in cell A1, then this formula placed in cell B3 and filled across will give you what you need : IF(AND(ISNUMBER(A2),ISNUMBER(C2),ISBLANK(B2)),MAX(A2,C2),"")....

Roger Haney Today, 04:48 AM

#### Power Query query not running in excel

Hi Ken,

you understand well.

In fact, that's what I'm going to do. I wanted to do without VBA but it seems...

msouppaya Yesterday, 03:00 PM

#### Adding columns of nested tables/ lists

If you want to be able to specify which column, I'd create a function for that that takes a table and column name as arguments - something like:
...

JoePublic Yesterday, 01:15 PM

#### Worksheet named from cell

That is certainly doable, we have a list of names.

I assume you would want SRM to only show the 4 staff designated at SRM, Basingstoke the...

Bob Phillips Yesterday, 01:20 AM

#### IF Formula

Yeah, you specify "" for false condition, e.g.

=IF(A2"",DATE(YEAR(A2)+10,MONTH(A2),DAY(A2)),"")...

Bob Phillips Yesterday, 12:58 AM