We all know that area charts are great for understanding how a list of values have changed over time. Today, let’s learn how to create an area chart that shows different colors for upward & downward movements.
The inspiration for this came from a recent chart published in Wall Street Journal about Chinese stock markets.
We will try to create a similar chart using Excel. We are going to create the above chart in Excel.
Looks interesting? Read on… Continue reading
Hi folks,
I am excited to announce Awesome August. It is a month-long effort to make you awesome in various aspects of Excel.
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.
There are 4 ways to participate in Awesome August
This site is currently under construction…please check back later, or mosey over to SimpleProductivityBlog.com and watch for announcements.
The post Under construction… appeared first on Whole Life Productivity.
So you’ve done a project, wrapped it all up, delivered it. Now what?
In July we are going to look at projects: how to pick what to do, how to get started, how to move forward consistently, how to fix stalled projects, and what to do after you finish a project.
Today we look at what you need to do after the project is done and the importance of handling “done”.
The post The Importance Of Handling “Done” appeared first on Simple Productivity Blog.
More great content can be found on the site at Simple Productivity Blog., or you can find me on Twitter (@SmplProdBlog) and Facebook (Facebook.com/SimpleProductivity).
In the 39th session of Chandoo.org podcast, Let’s learn about FOR loops.
There is a special giveaway in this podcast. It is a workbook with several FOR loop VBA code examples. Listen to the episode for instructions.
In this podcast,
Sometimes you can’t ignore the little voice that calls for change.
Read for more information on the future of SimpleProductivityBlog.com.
The post Winds of Change appeared first on Simple Productivity Blog.
More great content can be found on the site … Continue reading
Sometimes you can’t ignore the little voice that calls for change.
Read for more information on the future of SimpleProductivityBlog.com.
The post Winds of Change appeared first on Simple Productivity Blog.
More great content can be found on the site … Continue reading
On Fridays I pull the best of my blog readings to share with readers. Topics can come from anywhere, and cover anything. This week I highlight articles on
Frugal ways to unwind
Gadgets work-at-home people need
Camping cooking
Tips for traveling with … Continue reading
On Wednesday (15th July), I ran my first ever webinar, on a topic called, “How to be a BETTER Analyst?” (here is the replay link, in case you missed it). It was a huge success. More than 1,100 people attend the live webinar and hundreds more watched the replay. As part of the webinar, we had interactive Q&A. Viewers posted their questions and I replied to as many of them as I can.
After the webinar, I wanted to make sure I covered all the questions. So I downloaded the chat history. There were more than 700 messages in it. And I am not in the mood to read line by line to find-out the questions. A good portion of chat messages were not questions but stuff like ‘hello everyone, I am from Idaho’, ‘Wow, Chandoo has beard!”, “Enjoying a beer in Belgium while watching webinar” etc. So I wanted a quick way to flag the messages as question or not. Continue reading
Filtering is one of the most used feature in Excel. It is a quick way to take lots of data and narrow down to the subset we want.
But here is one common filtering scenario that is slow as snail.
Imagine you are looking at some sort of sales data (if you can’t imagine, look at the above demo).
Now, you want to filter this list for gender=male, profession=self-employed, product category = chocolates and quantity = 1.
If you use the right click, filter > filter by selected value approach, this will take several clicks.
Wouldn’t it be cool if you can select the entire combination and say filter?
Unfortunately, no such feature exists in Excel.
But you are not aiming to be ordinary in Excel. You are aiming to be awesome in Excel. That means, you don’t take no for answer.
Fortunately, we can quickly write a VBA macro that filters a list by selection. So let’s do that. Continue reading
