Note: This is a not an Excel tips post. It is a dairy of one of the most awesome conferences I have ever attended.
I just finished attending PASS Business Analytics conference in Santa Clara (USA) and am now heading back home to India. And it has been one of the most fun, uplifting and educational experiences of my life. I met so many remarkable people in this trip.
Read on for some pics & gossip. 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
ways to break bad habits
Microsoft Office Lense
cleaning dusty candles
some cool office organiza… Continue reading
In the 34th session of Chandoo.org podcast, Let’s hear from Jordan Goldmeier – my friend, fellow blogger, Excel blogger & author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book – Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go.
In this podcast,
In this episode I talk about how a portable office setup has affected my productivity.
The post Thursday From The Trenches Episode 12 appeared first on Simple Productivity Blog.
More great content can be found on the site at Simple Productivity Blog.,… Continue reading
One of the best ways that you can boost your productivity at the computer is to learn the keyboard shortcuts for some of the most commonly used actions. Instead of grasping the mouse and clicking the Copy button, for example, you could press a couple o… Continue reading
One of the best ways that you can boost your productivity at the computer is to learn the keyboard shortcuts for some of the most commonly used actions. Instead of grasping the mouse and clicking the Copy button, for example, you could press a couple o… Continue reading
True story:
On Friday (17th April – 2015), I flew from Vizag (my town) to Hyderabad so that I can catch a flight to San Francisco to attend a conference. As I had 10 hours of overlay between the flights in Hyderabad, I checked in to a lounge area so that I can watch some sports, eat food while pretending to do work on my laptop. There was a gentleman sitting in adjacent space doing some work in Excel. As I began to compose few emails, the gentleman in next sitting space asked me what I do for living. Our conversation went like this.
Me: I run a software company
He: Oh, so you must be good with computers
Me: smiles and cringes at the stereotyping
He: What is the formula to select all the blank cells in my Excel data and highlight them in Yellow color
Mind you, he had no idea that I work in Excel. We were 2 random guys in airport lounge watching sports and eating miserable food.
Me: Well, what are you trying to do?
He: You see, I am auditing this data. I need to locate all the blank rows and set them in different color so that my staff can fill up missing information. Right now, I am selecting one row at a time and filling the colors. Is there a one step solution to this problem?
Needless to say, I showed him how to do it faster, which led to an interesting 3 hours at the lounge.
End of true story.
So today, let’s understand how to find & highlight all the blank cells in the data. 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
How to clean the heating shell of a slow cooker
How to make steel cut oatmeal easily
Getting ove… Continue reading
We all know pivot table functionality is a powerful & useful feature. But it comes with some quirks. For example, we cant insert a blank row or column inside pivot tables.
So today let me share a few ideas on how you can insert a blank column.
Imagine you are looking at a pivot table like above.
And you want to insert a column or row. Go ahead and try it. Continue reading
We all know pivot table functionality is a powerful & useful feature. But it comes with some quirks. For example, we cant insert a blank row or column inside pivot tables.
So today let me share a few ideas on how you can insert a blank column.
Imagine you are looking at a pivot table like above.
And you want to insert a column or row. Go ahead and try it. Continue reading
