In the 48th session of Chandoo.org podcast, let’s make some animated charts!!!
What is in this session?
In this podcast,
Today is Diwali, the festival of lights. I wish you and your family a happy, bright and prosperous festive time. May your house shower with lots of light, laughter and love.
Diwali is one of my favorite festivals. It is a time when all family members get together, eat delicious food, laugh to hearts content and light up diyas (small oil lamps) to celebrate the victory of good over evil. This year, my kids (who are 6 yrs btw) are very excited about the festival. They are looking forward to lighting up diyas and crackers (fire works).
To celebrate the holiday, I made something for you.
An animated flower pot firework in Excel. Continue reading
One of the cries of the person who is looking for better ways to manage time is “I don’t have enough time!” While for some people this is true, at the same time, most people have bits of time they aren’t using. When we locate and use those bits of time, we can actually expand how much time we have to get things done.
Today we will look at how to find those hidden pockets of time and put them to the best use.
The post Find Hidden Pockets of Time appeared first on Whole Life Productivity.
Thanksgiving is this month. I believe in the power of gratitude, and especially for the bounty of the harvest, without which none of us could live. In our modern lives we lose touch with the land and the cycles. Thanksgiving is a time to honor that connection and to remember that we belong to the earth.
Enjoy the bounty of the harvest with a bounty of productivity!
The post November Productivity Form Released appeared first on Whole Life Productivity.
Imagine you are the head of training department at ACME Inc. You arrange training programs round the year to empower your team. It is hard work, coordinating between employees, trainers, department heads, venues and coffee machines. What if there is something to help you keep track of all this? I am not talking about getting you a shiny new iPad, you silly. I am talking about a tracker & calendar built in Excel that ties everything together (well, almost everything, you still have to fill the coffee machine.)
We are going to build a training program tracker & calendar using Excel. Continue reading
Have you ever been at a child’s birthday party? If the children are young enough, there is an almost-guaranteed scenario that will play out when it comes time for the cake.
Some child will want the piece with all the frosting flowers, and it will be claimed by someone else. And instead of accepting another piece, the child will sulk and refuse to eat any cake at all.
This type of behavior isn’t limited to spoiled children at birthday parties. I have seen full-grown mature adults approach their productivity the same way.
The post Are You A (Productivity) Spoiled Child? appeared first on Whole Life Productivity.
Here is a quick homework to keep you busy this weekend.
Can you extract number of days from below text.
Nov15 PUTS (23 days)
March15 TIKS (3 days)
March1 TIKS (25 days)
June11 TIKS (10 days)
Assume the data is from cell A1.
Your solution should return the following:
23
3
25
10
Post your answers (formulas, VBA code or Power Query M code) in the comments. Continue reading
Last night I asked members of our Chandoo.org facebook page to share an Excel problem you are struggling with. Francis asked,
How to save a file as .txt in vba without quotes? When I save as .txt, the file has got quotes inside of it. I used the code Print, but it didnt work because the file loses its delimitation.
Does anyone know how to solve this?
Let’s understand how to save a range as text and overcome the double quote problem. Continue reading
Last week we looked at how you can know if you are out of balance. Today we will give you 5 steps to get your life back into balance.
It’s not complicated. But it’s not easy, either.
The post 5 Steps To Adjust Your Balance appeared first on Whole Life Productivity.
Here is a quick visualization challenge for you.
There are 25 KPIs and each has a base value, current month, corresponding month values. The KPIs also have targets.
The data looks like this:
Click here to download the data for this contest.
Go ahead and make your chart(s). Continue reading
