Here is a familiar problem: You create a workbook to track some data. You ask your staff to fill up the data. Almost all the input data is fine, except the date column. Every one types dates in their own format. Here is a fun, simple & powerful way to warn your users when they […] Continue reading
Last week I talked about my problems with Getting Things Done in the article “When Getting Things Done Gets In the Way”. Readers were quick to email and comment that they wanted to know what I would use. (In hind sight, I should have indicated this art… 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:
Morning routines and stress relief
Turning off FM radio
Cleaning burnt pans
Getting meetings ba… Continue reading
I am in Sydney and yesterday we had a meetup of Sydney Excel users. Around 15 people turned up for the event and we talked about various Excel related topics over few drinks. One of the questions that came up was,
I learn and use Excel in better ways. But my boss doesn’t how to open the workbook and use simple stuff like filters, slicers, sorting and selecting. So I end up sending screenshots or PDFs instead of powerful Excel files. What to do?
Although we discussed various possible solutions to the problem, I thought it would be a good topic for us discuss here.
So how would you train your boss to use Excel?
Please share your thoughts, experiments, experiences and suggestions in the comments. Let’s make our bosses awesome. Continue reading
One of the most frustrating things is when you get somewhere and realize you don’t have everything you need. I’ve recently started working with binders to help avoid that problem. Here is why and how to use binders to boost your productivity and simpli… Continue reading
When Getting Things Done (GTD) was introduced in 2002, it quickly became the go-to productivity system. It had the advantage of being one of the first formal methodologies combining not only time management, but project and goal management as well.
I h… Continue reading
They say you can take the girl out of Wisconsin, but you can’t take Wisconsin out of the girl. I’ve lived in Virginia for almost 20 years, but Wisconsin is still “home”. And as the granddaughter of a dairy farmer, I have been around cows my entire life… Continue reading
This is a pretty spectacular illustration that I don’t always have it together. I have overextended myself…I knew I was doing it, but told myself that if I just worked a little bit harder, I could still keep everything moving along, and no one would know the difference. Right. (<- read this with sarcasm) The […]
The post Well, this is embarrassing… 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).
Here is a fairly annoying problem.
Imagine a chart showing both sales & customer data. Sales numbers are large and customer numbers are small. So when you make a chart with both of these, selecting the smaller series (customers) becomes very difficult.
In such cases, you can use arrow keys – as shown above. Continue reading
This is a little-known and huge time saver in Microsoft Excel. Using this tip, you can save time in Excel by formatting multiple sheets at the same time.
The post Save Time In Excel By Formatting Multiple Sheets appeared first on Simple Productivity Bl… Continue reading
