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.
5 Responses
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.
Family pic is awesome Chandoo, just like ur Excel tips. Enjoy the stay and have a safe fly back..
Nice pic chandoo… Have a safe fly back..
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.
Nice work Chandoo. I loved your idea and concept and i just read your story as well. Your blog is a hit. Great work .