All articles with 'Excel Tips' Tag

Dashboards are daily staple for some of us who need to report status to our bosses, present them in weekly meetings or generally CC half the world with what is up on our end. There are several ways in which you can spice up the dashboard, one of the simple things to do is, to […]

When I saw the Olympic medals won by each country by year infographic on nytimes my jaw almost dropped, go ahead see it and come back, I am sure you will love it too. It is one of the coolest visualizations I have seen in the recent past and I see infographics all the time, […]

– During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action + – Inserts current date +

Excel concatenate() is seriously crippled, it can add 2 or more strings together, as long as they are supplied as separate parameters. This means, when you have a range of cells with text which you want to add up to create a large text, you need to write an ugly looking biggish concatenate() or use […]

Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and good looking. Better still, you dont even need to be a guru […]

Yesterday we were calculating our Washington trip expenses and it occurred to me that if there is an excel template where I could enter the trip expenses and who paid what to find out how much we need to pay up / collect, it would be great. I looked around for few seconds, couldn’t find […]