Author: Johnny

Posted on: January 13, 2011 Posted by: Johnny Comments: 12

Cut Data Reconciliations by 90%

You get a new data file and the numbers are close, but slightly different from the other file you already had. Suddenly, you’ve got two different sets of data. Now you have to spend two hours matching things up. Let’s use three steps and make this project a ten minute exercise.

Posted on: December 10, 2010 Posted by: Johnny Comments: 2

Diminishing Returns – The Business Intelligence Podcast [BIP]

I had a rare opportunity to speak with and get an e-mail from my Internet Business guru. Business term “The Law of Diminishing Returns”. And companies around the world spend up to $100 billion a year to train employees in the skills they need to improve corporate performance… But training typically doesn’t have much impact.” Find out why this happens?

Posted on: December 1, 2010 Posted by: Johnny Comments: 0

How to Create an Excel Chart that Amazes

A good chart can “land” you the client, separate you from other vendors, or make your message to management extremely persuasive. This VIDEO shows you EXACTLY how to create good Microsoft Excel charts. Here is part 2 of a 3 part series on how to create compelling charts in Excel.

Posted on: November 20, 2010 Posted by: Johnny Comments: 3

The best office holiday gift for your boss or coworker

The challenge was finding a gift that was not too showy, but would be remembered. Not too expensive, but display quality. After a lot of thoughtful research, I found a great gift… A pen. No, really, a very cool pen. For starters it’s historical. Pens were given by Presidents George Washington and Harry Truman and also used in Space.

Posted on: November 19, 2010 Posted by: Johnny Comments: 3

How to Create Compelling Charts in Excel

A good chart can “land” you the client, separate you from other vendors, or make your message to management extremely persuasive. This VIDEO shows you EXACTLY how to create good Microsoft Excel charts. Here is part 1 of a 3 part series on how to create compelling charts in Excel.

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

Cut 3 days of Frustration by Using these Office Secrets

I recently helped a co-worker cut 3 days of frustration off her project deadline, using 1 of my 3 office communication secrets. Here’s the scenario, she was trying to contact another employee to get his approval on the project. He was the last person who needed to sign off on the project changes… and he wasn’t responding. Sound familiar?

There are several techniques that I’ve learned that help keep project deadlines.

Posted on: October 20, 2010 Posted by: Johnny Comments: 1

3 Simple Steps for Charting Data

When you have to present Excel data, the last thing you should do is take a screen shot of the data and make it into a PowerPoint slide. The chart should tell a story that can be understood in 5 – 10 seconds. If you take longer than that, your audience will ignore you and focus on trying to understand the chart. Knowing your data is the critical step. Follow these simple steps for charting your data.

Posted on: October 7, 2010 Posted by: Johnny Comments: 1

Business Reporting Requirements Gathering

For 10 years, I’ve been building reports for Finance, Operations, Accounting, Marketing, Mid-level Managers, Executives, and some just for myself. This is the typical checklist I go through for reports