Author: Johnny

Posted on: September 22, 2010 Posted by: Johnny Comments: 0

You Are Not Alone

I broke my own rule this week. In a moment of desperation I began plugging values into cells, sorting and sifting through data trying to get this data table populated. It was brutal. Luckily, I’ve built enough procedures and processes that this type of thing doesn’t happen often. But it reminds me of the purpose of this site

Posted on: August 21, 2010 Posted by: Johnny Comments: 10

4 Excel tips that can save you 3.5 hours of work this week!

Here are some tips that I’ve been sharing on Twitter. When you use these kinds of tricks in your regular processes can save you hours of work. There’s no reason to be spending more than 10 minutes on any task. Use these tricks and spend less time on boring stuff, and allow you to focus on what you want to.

Posted on: August 19, 2010 Posted by: Johnny Comments: 9

How to segment your reporting users

The vast majority of your business users will never use your Business Intelligence tools. There are only 5% (or 1 in 20) of your “users” of business intelligence (BI) tools that will want to “self serve” their information requests. Separate your business users into these three tiers: Shadow IS, Advanced Users, and Managers.

Posted on: August 12, 2010 Posted by: Johnny Comments: 0

How to Deal with Emergency Reporting Needs… All The Time

I received this e-mail from a Sales Director: “I’m outside this customer’s office, and I have a presentation to make in 10 minutes. Can you make me a couple of slides showing revenue and units for the past 12 months?” Yes, that really happened.

Posted on: July 28, 2010 Posted by: Johnny Comments: 0

The best business practice for Excel

If you are working for more than 10 minutes on any one process in Excel, YOU ARE WASTING YOUR TIME! I was working on a process that was requiring a bunch of manual moving, copy, and pasting and my little mental timer went off…

Posted on: December 24, 2009 Posted by: Johnny Comments: 2

How to survive the New Year

It’s time to recharge the batteries, do a little site maintenance, and prepare for the exciting New Year. What do you do to reward yourself for a great year of hard work, share with the community?

Posted on: November 15, 2009 Posted by: Johnny Comments: 2

How to be thankful in Black Friday lines

While you’re in line try this activity to make the time pass faster – take each letter of the name of the store and come up with a thing you’re thankful for. We’ll call this the Positive Acronym Game.