In the 41st session of Chandoo.org podcast, Let’s take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article – 6 Charts you will see in hell.
In this podcast,
A significant portion of our time in Excel is spent navigating between various ribbon tabs and clicking buttons. Wouldn’t it be better if you can combine all the frequently used features in to one ribbon? Something like above:
Read on to learn how to create, edit and share custom ribbons in Excel. Continue reading
Analyzing top n (or bottom m) items is an important part of any data analysis exercise. In this article, we are going to learn Excel formulas to help you with that.
Let’s say you are the lead analyst at a large retail chain in Ohio, USA. You are looking at the latest sales data for all the 300 stores. You want to calculate the total sales of top 10 stores. Read on to learn the techniques. Continue reading
I’m on vacation this week…I’m spending the time with family, planning the upcoming blog changes, and relaxing! Photo by davidwilson1949. Licensed under Creative Commons.
The post On Vacation, August 2015 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).
We, adults can’t escape three things:
While I can’t help you with demanding bosses or taxes, when it comes to deadlines, I have the right tool for you.
A tracker that highlights all overdue items so that you know where to focus your attention.
Let’s learn how to use awesome powers of Excel to find-out which items are due. You can apply these concepts to nail down over due invoices, pending project tasks or scheduling workforce. Continue reading
We, adults can’t escape three things:
While I can’t help you with demanding bosses or taxes, when it comes to deadlines, I have the right tool for you.
A tracker that highlights all overdue items so that you know where to focus your attention.
Let’s learn how to use awesome powers of Excel to find-out which items are due. You can apply these concepts to nail down over due invoices, pending project tasks or scheduling workforce. Continue reading
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. Continue reading
In 2014 I decided I wanted to release monthly productivity forms with a seasonal theme. Fun tools make it more likely I will use them, and honestly, I get bored with the plain old print and line forms. In 2015 I decided to continue this tradition. So to that end, I will be releasing a […]
The post New Productivity Forms: August 2015 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).
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. Continue reading
In the 40th session of Chandoo.org podcast, Let’s talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs PowerQuery.Training website) and talk about this very exciting piece of technology and how it can make our life simpler.
In this podcast,
