All articles with '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 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book.

What is in this session?

In this podcast,

• Updates: Why so much gap between episodes?
• Quick introduction to Power Query
• Why you should get this book?
• What is in this book?
• A very cool example of the techniques you will learn
• Conclusions

Quick update about Dashboards for Excel book:

As you may know, my first print book – Dashboards for Excel (co-authored with Jordan Goldmeier) is supposed to release today – 15th September, 2015. But unfortunately, there is some delay with the printing process, so the book is not available yet. Our publisher, Apress, tells us that it can take two more weeks.

Thanks to all of you who pre-ordered this book. I am sorry for this unexpected delay. Just few more weeks and you will be reading it. 🙂

Time for another round of Excel links

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 44th session of Chandoo.org podcast, let’s talk about failures.

What is in this session?

In this podcast,

• Book announcement about Dashboards for Excel
• Story of my first ever dashboard
• Important lessons – Requirement Analysis for dashboards
• Resources for creating awesome dashboards
  • Podcasts
  • Books
  • Courses

I have an exciting announcement to share with you. My first ever print book – Dashboards for Excel, co-authored with Jordan Goldmeier is releasing on 15th September.

Dashboards for Excel – what is it?

As the name suggests this book is a handy guide for anyone preparing dashboards, management reports and business intelligence workbooks using Excel. The key benefits are,

• Learn the visualization tools, charts, tables, and graphs important to management.
• Understand what management doesn’t want to see in a report
• Turn around dashboards faster and cheaper than ever before
• Understand the key role dashboards play in an organization
• Analyze real-world dashboards to apply important features to your own organization
• Utilize understated, but powerful, Excel formulas and VBA code
• Avoid common pitfalls in Excel development and dashboard creation
• Get started with the Excel data model, PowerPivot, and Power Query

As you can see, this is an advanced Excel book with lots of examples, case studies and practical tips.

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

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.

What is in this session?

Analytics is an increasingly popular area now. Every day, scores of fresh graduates are reporting to their first day of work as analysts. But to succeed as an analyst?

By learning & practicing of course.

And books play a vital role in opening new pathways for us. They can alter the way we think, shape our behavior and make us awesome, all in a few page turns.

So in this episode, let me share 3 must have books for (aspiring) analysts.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 5th session of Chandoo.org podcast, we are going to demystify form controls.

I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor – Debra Dalgleish about this topic.

In this podcast, you will learn,

• What are form controls
• When you would use them?
• Example form control – Combo box
• How form controls differ from active-x controls
• How to enable form controls in your Excel?
• Various important form controls
• Special bonus & how to obtain it

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the third session of Chandoo.org podcast, we are going to get BI curious. 😉

Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot & other Power BI family members. In this session, I am happy to feature Mike Alexander – Microsoft MVP, Author, Blogger & a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality.

You will learn,

• Introduction, what Mike is up to these days?
• What is BI, what does it mean to an average Excel analyst?
• What BI capabilities Excel has – brief intro to each of them
  • Power Pivot & what it does
  • Power Query & why it is important
  • Power View & how it works (and where it sucks)
  • Power Maps
• How to learn about these new technologies
  • Recommended Books
  • Websites
  • Courses
  • Live classes
• Special gift for our listeners

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions.

What is in this session?
In this session, we tackle one of the most important areas of Excel. The lookup functions.

You will learn,

• Why lookup functions are necessary
• 5 Important lookup functions in Excel – VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX
• When & how to use each of these 5 functions?
• Extreme scenarios:
  • What happens when the value you are looking up is not there?
  • What if too many items match the lookup value?
  • What if you have too many conditions in the lookup criteria?
• Using IFERROR function
• Re-cap of the new powers you acquired
• 4 Resources for you to learn lookup functions better

Hi folks,

What a night it has been. Unlike hi-fi product launches for a new perfume or car, my book launch did not have hot models or unlimited champagne. And yet, last 18 hours has been an intense and lovely experience. And finally,

My book is out.

You can purchase a copy thru Amazon or our website.

Go ahead and get your copy today.

Keen readers of Chandoo.org would have noticed a slow down in new posts recently. There are a few reasons for that.

• I went to Malaysia to conduct Excel Dashboards & Power Pivot masterclass.
• After coming back, we (our family) went to Goa to vacation for a few days.
• When we got back, we all fell in to a vicious loop of flu, body pains and fatigue.
• And it took a few days to recover and fall back in to routine.
• But the most important reason is, I am writing a book 🙂

Introducing The Vlookup Book

Friends, readers & supporters of Chandoo.org,

I am very glad to announce my newest book – the vlookup book to help you become awesome in answering any lookup related question.

Click here to get your copy.

Hurray, PHD blog crossed 2000 RSS Subscriber base. This is a very significant milestone for me.

To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resources for you.

My job takes me to numerous meetings, even though I hate to go to so many of them. Most of the time during the meetings I end up writing lots of notes about, good ideas things to do, action items usual meeting notes mind maps, diagrams and of course doodles well, this brings me to […]