All articles with 'awesome august' Tag

Sparklines are fun and very insightful. They are easy to create, easy to maintain and fit into any dashboard.

But there is one tiny problem with them. Usually we have a lot of data, but we don’t to visualize all of it. We just want to visualize latest 30 days trend or last 12 months trend or QTD or something similar. What then?

In this video, learn a powerful and very simple way to create dynamic sparklines using Excel.

Excel has many powerful & time-saving features. Even by Excel’s standard, Flash Fill is magical. Introduced in 2013, Flash Fill is a rule engine to Excel’s fill logic. Every time you type something in a cell, Excel will try to guess the pattern and offers to fill up the rest of cells for you. That is some serious time saving magic.

Let’s understand what Flash Fill is and few sample use cases.

Hi folks,

I am excited to announce Awesome August. It is a month-long effort to make you awesome in various aspects of Excel.

Awesome August… What is it?

For each and every day of August 2015, I am going to publish a new piece of content – an Excel tip, a formula technique, a charting solution or a productivity booster. 31 days – 31 pieces of awesome content.

Sounds Yummy? Participate in Awesome August:

There are 4 ways to participate in Awesome August

1. Sign-up to Chandoo.org newsletter. Get weekly emails with links to all the Awesome August content.
2. Comment & Win: Comment on any of the Awesome August posts. 31 random commenters will each get $31 Amazon gift-card.
3. Follow Awesome August in social media – on twitter, facebook, youtube and iTunes
4. Ask your friends & colleagues to participate. Send them to Chandoo.org/AwesomeAugust