Celebrate 'The VLOOKUP Book' birthday with us. Last day to get 50% discount on the e-book (31 October only).

Click here for details

Excel Links – from USA edition

Posted on May 8th, 2013 in excel links - 5 comments

Hello there,

My travel to US was fantastic and fun. Many thanks to Jocelyn & Rob Collie, who found a nice apartment for us and made sure we are settled down in almost no time. Weather has been excellent so far too with lots of sunshine and blue skies. We went to a nearby park the other day and kids really loved walking on trials and exploring.

Gentle reminder

Today is last day to sign-up for my USA Masterclass

Today is last day to join my USA Advanced Excel & Dashboards masterclass with early bird discount. If you live near Chicago, Washington DC or Columbus and love Chandoo.org style of teaching, then you will benefit alot from my masterclass. We have very few spots left in Chicago & Columbus. So go ahead and book yours today and save $200.

Click here to know more and join us.

Excel links – after a long time

After a long time, I have a few more Excel links to share. Check out these for useful Excel tips, information & ideas.

Neat compilation of Excel keyboard shortcuts

Dave & Lisa (his wife) created this beautiful, searchable, PC & Mac compatible list of Excel keyboard shortcuts. Check it out to learn something useful. [More keyboard shortcuts]

Create small multiples (panel charts) automatically [Excel workbook]

James sent me this beautiful Excel VBA file using which you can generate small multiples chart from a large, cluttered chart. You just enter all the data, create one big chart, tell how you want your small multiples and press a button – bingo, your small multiples are ready.

Making pretty annual report in Excel

Joey at Darkhorse analytics discusses how we can create a beautiful annual report using Excel alone and why it is important to make your work look pretty as well. Check out the downloadable file and see it yourself. PS: You need install a font if you want to see it perfectly.

Building waffle charts in Excel

Mike shows us how to create waffle charts, which are nothing but square pie charts. Very interesting technique. (You can create waffles with conditional formatting too.).

Summing data across multiple sheets with multiple criteria

Liam shows us how to calculate sum of all values across multiple sheets that meet a given criteria using INDIRECT formulas, tables and Excel trickery.

PS: here is a pic of Chandoo family in Chagrin falls park in Cleveland :)
PPS: If you live in Cleveland or near by shout out in comments. We can catch up for some coffee next week.

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

5 Responses to “Excel Links – from USA edition”

  1. Tonie Salzano says:

    Beautiful pic Chandoo. I grew up a few miles from that park and have many happy memories. Too bad I’m in Arizona now, or I’d spring for the coffee.

  2. Venu Madhav says:

    Family pic is awesome Chandoo, just like ur Excel tips. Enjoy the stay and have a safe fly back..

  3. Abhilash VK says:

    Nice pic chandoo… Have a safe fly back..

  4. Joey says:

    Thanks for linking chandoo. You’ve got a significant amount of influence in the community and it was cool to see the spike in traffic.

  5. Ankit Bansal says:

    Nice work Chandoo. I loved your idea and concept and i just read your story as well. Your blog is a hit. Great work .

Leave a Reply