Transpose this address data [VBA homework]

Transpose this address data [VBA homework]

Here is an interesting problem to keep you busy.

Transpose the address data in column A into the format indicated in C:G using either VBA, formulas or Power Query. Once done, post your answers in comments section.

Continue »

Don’t make your charts heavier than they should be – The weight of the world chart [case study]

Don’t make your charts heavier than they should be – The weight of the world chart [case study]

Here is an interesting chart from Economist, ironically titled The weight of the worldCan you tell what is wrong with it?

Continue »

CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

In the 51st session of Chandoo.org podcast, let’s discuss most frequently asked questions about VLOOKUP.

What is in this session?

In this podcast,

  • What is VLOOKUP?
  • What happens when VLOOKUP can’t find the value?
  • Should my list be sorted?
  • Is VLOOKUP slower than INDEX + MATCH?
  • What if my list has multiple matches?
  • How to fetch 2nd / 3rd matching item?
  • How to fetch all matching items?
  • How to fetch items matching multiple conditions?
  • How to speed up VLOOKUP?
  • Why doesn’t my VLOOKUP work?
  • What to do in case of errors?
  • Resources for you
Continue »

How can I help you in 2016? [Survey]

How can I help you in 2016? [Survey]

A very happy new year to you. May 2016 be your most awesome year yet.

This year too I plan to share tutorials, tips, podcasts & videos to make you awesome. I hope to focus on

  • Excel 2016 – exploring new features
  • Power BI – What is it, how does it make you awesome.
  • Write a sequel to The VLOOKUP Book.
  • Launch a new online course on Power BI & New Excel.
  • Run 2 more batches of 50 ways to analyze data program in Feb & July 2016.
  • Run another dashboard contest on Chandoo.org
  • Write about awesome ways to work with data – formulas, charts, tables, pivots etc.
  • Talk about many advanced and work specific Excel scenarios in the podcast

But wait, what do you want to learn more…?

While these are my plans, I want to make sure Chandoo.org helps you the best. So please take a minute and answer this one question survey.

Continue »

2016 Calendar, daily planner Excel templates [free downloads]

Here is a New year gift to all our readers – free 2016 Excel Calendar & daily planner Template.

download-free-2016-calendar-daily-planner-templates

This calendar has,

  • One page full calendar with notes, in 4 different color schemes
  • Daily event planner & tracker
  • 1 Mini calendar
  • Monthly calendar (prints to 12 pages)
  • Works for any year, just change year in Full tab.
Continue »

Best of Chandoo.org – 2015

Best of Chandoo.org – 2015

2015 has been the busiest year since starting Chandoo.org.

Wow, that is 12 years of breaking previous records. Thank you.

In 2015, we published 124 posts (down 3% YoY), received 6,300+ comments (up 5%). Our forum too had busy year with 1000s of new members and 5,000+ new threads. Chandoo.org podcast continued to shine, we had 24 episodes this year and reached the 50 episode milestone. Our podcast episodes has been downloaded more than 900,000 so far since launch (in March 2014) with 600,000+ downloads this year alone!!!

Fun fact: People have spent 6.8 million minutes in 2015 listening to Chandoo.org podcast. (assuming only 50% of downloads materialized to listens)

We have trained more than 1,800 people thru my online classes – Excel School, VBA Classes & 50 ways to analyze data program.

Continue »

People & websites that helped me in 2015 [thank you message]

2015 has been the most awesome year since starting Chandoo.org Thank you so much for making it happen. This year, more than 11 million people visited our site (up 8%), learned something and took first step to become awesome in their work. 2015 has been an amazing journey, thanks to all your visits, listens, purchases, […]

Continue »