5 things that helped me run 10k
As told earlier I have finished my 10 k run today (actually 13 k). Even though running 10 kilometers is not a big deal for many people, it is a HUGE deal for me and I thought I would write a small post sharing my experience of crossing this important milestone.
Say thanks with an excel tip
Tomorrow is thanksgiving day here. It is a harvest festival on which people express thanks for what they have. Much like Sankranthi (pongal) in India. At this moment I am very angry and frustrated about the terror strikes in Mumbai. I am not sure how a person can do something like this to others. I […]
Prevent users from scrolling away on your dashboards [dirty little trick]
Dashboards let users get all the information they want in a quick glance. Not if users start using scroll bars and scroll down to cell A64000. So here is a quick and dirty trick. Assuming your dashboard ends in row 40, select row 41 and go to menu > window > freeze panes. That way […]
Advanced Data Validation Techniques in Excel [spreadcheats]
Data validation is a great way to keep your users informed about possible values in a cell and guide them to select something appropriate. As part of the spreadcheats series, in this post we will discuss 2 advanced data validation techniques that can help you when you are modeling a complex worksheet.
Fun way to clean up modern art with visualization
TED Talks are a great way to keep your mind nourished. They inspire you, give you a ton of new ideas. I saw this ted talk (embedded below) Tidying up art by Ursus Wehrli and couldn’t resist sharing it with you. It is an entertaining one and I recommend watching it. In this talk the […]
Excel Links of the Week – PHD’s new tag line [Nov 24]
This is probably the 100th time I have changed this site’s tag line. So, it may not be a great news to you. But again, I need to say out this loud so that you, my dear reader, will know what this blog is going to stand for: Excel Tips, Charting Ideas and Visualization Oomph. […]
Introducing Excel Formula Helper
One of the most common comments we get here is “how does xxx formula works?” Even though there is vast documentation on excel formulas including the built-in help in MS Office, often it is difficult for us to learn a formula quickly and use it in a snap. So to help new users of excel […]