Excel Links – Going to Togo Edition

Posted on September 4th, 2012 in excel links - 12 comments

After a long time, I am writing one more Excel links post. First let me share a quick personal update.

I am invited to Lome, Togo to spend a day at Ecobank – CFO conference in 3rd week of September. I will be conducting a one day masterclass on Advanced Excel & Dashboard Reporting. I am excited about this trip as I have never been to any African country. I will post some pics and tell you how it went once I am done with the conference.

Moving on to Excel Links for today,

Calendar Chart using PowerPivot, DAX and pixie dust

Rob at PowerPivotPro created this awesome calendar chart using powerpivot, DAX formulas, conditional formatting and probably lots of coffee. It is a clever idea. I will be shamelessly adopting it for some of my reports 😛

Multiple Criteria Lookups – INDEX or SUMPRODUCT?

Often we need to lookup a value that meets multiple criteria. Back when we did that lookup week, we had a round up of various techniques for doing mulch-criteria lookups (index+match, sumproduct, sumifs etc.). Doug at YourSumBuddy discusses more about 2 important approaches – INDEX+MATCH vs. INDEX+SUMPRODUCT

How to create a Panel Chart

Debra shares a simple yet wonderful recipe for cooking panel charts. Go check it out and impress someone today.

Checklist in Excel that works

Robert shares an excel check list template that use a bit of VBA magic to automatically check / uncheck items upon clicking the cell. Very nifty.

Using Arrows in percentage format

Mike at Bacon bits shows us how to get up and down arrow symbols in cells that have percentage change, using custom cell formatting codes. The best thing is the same formatting is applied to status bar as well, pretty cool.

That is all for now.

Got any Excel links that you want to share with us?

I am always looking for new websites and resources to learn Excel & Visualization. So if you came across something that is awesome and want to share it with us, send it to me at chandoo.d @ gmail.com or drop a comment here. Thanks in advance.

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

12 Responses to “Excel Links – Going to Togo Edition”

  1. Saran Kumar says:

    First of all congrats chandoo.. i m sure, u will make them awesome in excel in your trip..

    Good collection of links.

    Regards,
    Saran
    http://www.lostinexcel.blogspot.com
     

  2. Vaslo says:

    That last link of using the custom cell format is really brilliant.  You have to love simple solutions like that - really makes the values pop!

  3. Lorenzo says:

    Chandoo, excuse me for my bar englisch, i am italian.
    You are great for all your work. Thanks for all your suggestions
    Best regards
    Lorenzo 

  4. Kiev says:

    I like the last link so much, it is simple but more useful in practice. Thank you.

  5. Doug Glancy says:

    Thanks for the mention, Chandoo! Have a good trip.

  6. This Scoop It! page started by Kris, moderator of the Excel Hero LinkedIn group, may be of interest to you and your readers: http://www.scoop.it/t/excel-hero-linkedin-group/

  7. rajinikanth says:

    All the information in the links are awesome, specially the panel chart and percentage format.
    I used the arrows in %age but not in custom format...good tips.

  8. Pedro Wave says:

    Chandoo, I share with you and your blog visitors three links to play and view chess games without the risk of enabled macros.

    http://pedrowave.blogspot.com.es/2012/02/data-conversion-1-chess-viewer-in-excel.html
    http://pedrowave.blogspot.com.es/2012/03/data-conversion-2-chess-viewer.html
    http://pedrowave.blogspot.com.es/2012/08/data-converter-3-chess-game-with.html

    I'm improving this chess game only with iterative formulas.
    Have a good trip. 

  9. Robert says:

    Chandoo,
    many thanks for the link. Much appreciated. I am happy you liked the check list template.

Leave a Reply