Login to online classes

Tag: books

CP005: Introduction to Form Controls – an interview with Debra Dalgleish

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

CP003: Business Intelligence for Masses – Interview with Mike Alexander

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

CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you

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

I am writing a book [and its coming soon]

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.

100 Excel Tips & Resources

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.

Why do notebook page layouts suck?

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 […]