All articles with 'excel books' Tag

So you have decided to up your game with Excel and / or Power BI this year and now ravenously looking for books to read. You have come to the right place. Here is my list of recommended best Excel books, and books on Power BI, visualization, dashboards, VBA, Macros and analytics.

Use below links to navigate the relevant section of this page:

• Excel Books
• Books for data & visualization
• Power BI Books
• Excel VBA Books
• My own books

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 34th session of Chandoo.org podcast, Let’s hear from Jordan Goldmeier – my friend, fellow blogger, Excel blogger & author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book – Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go.

What is in this session?

In this podcast,

• Introduction
• What is this book all about
• Sample chapter review – User forms
• Design principles for creating advanced user interactions
• How to become advanced Excel user – pathway recommended by Jordan
• More info about Jordan
• A secret for you

Outside of a dog, a book is a man’s best friend. Inside of a dog it’s too dark to read. -Groucho Marx

We don’t have a dog (yet), but we have a lot of books. Anytime I am in a bookshop, I feel like a mosquito in fat-camp. So you can imagine me smacking my lips when I saw your suggestions for favorite Excel books recently. There were more than 50 different books recommended by our readers. Of course I cannot buy all the 50 in one go. That would make Jo (my wife) angry. So I bought one that most of you recommended.

Ctrl + Shift + Enter by Mike Girvin

It is a book about array formulas, advanced formulas and data analysis techniques. I am eagerly waiting for the delivery to devour it. Once I am done with it, I will post a review here.

What about you? What Excel book are you reading now? Please share in comments.

Today lets talk about Excel books. The question is simple.

What is your favorite Excel book? Please share your answers using comments.

My favorite books are..,

Business analysis & modeling are new areas where a lot of fresh graduates find themselves when they start work. Unfortunately, this is also an area where there is very little structured information. Thanks to Danielle’s new book, Using Excel for Business Analysis, you can understand the basics of financial modeling, good spreadsheet design & business analysis

First up, let me congratulate my good friend Danielle for the successful launch of her first book. Today, I want to share my review of this book with you.
Who is this book for?

• You are someone who uses Excel to analyze & model parts of a business,
• You are not sure how to go about it
• You started using Excel in last few years and lack structured approach to spreadsheet design
• You are a fresh MBA hoping to become an analyst

Then this book is for you.

During last one week, we had a gala time with Dashboard Week on chandoo.org. To wrap-up the week, I am sharing a list of recommended resources, websites, tutorials & ideas for making dashboards.

Recommended Resources on Making Dashboards:
I have broken down this post in to various sections. Click on the links to quickly access the part you want to know or just keep scrolling to get the whole thing.

1. Books on Dashboards
2. Websites for Learning about Dashboards
3. Dashboard Training Programs
4. Add-ins & Software to Make Dashboards
5. Dashboard Tutorials & Downloads on Chandoo.org

Francis J Hayes runs probably one of the most popular excel news letters. His email newsletter, called as “The Excel Addict” has an interesting nugget, tip or trick every week. I have been reading his emails for the last few months and I really enjoy them. So naturally I got curious when I heard about Francis’ e-book titled “101 Secrets of a Microsoft Excel Addict“. Yesterday I purchased a copy of the book and there are so many hidden gems in the book that I had to tell you about it.

Anyone working on the data using excel will know the importance of lookup formulas. They are vital for making almost any spreadsheet or dashboard. That is why when my friend John Franco, who maintains Excel-Spreadsheet-Authors.com, wrote to me about his new book Excel lookup toolbox I was truly excited. In this post I am going to share my review of this product.

Our interview with John Walkenbach is here. Check it out and see what John has to say about Excel, spreadsheets and fun.