Excel Links – from USA edition
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.
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.
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.
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]
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.
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.
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.).
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.
|How to create a column chart with background image in Excel ?||I am meeting Mr. Excel aka Bill Jelen tomorrow. What do you want to ask him? (book giveaway too)|