Tag Archives: Office

How to Create New Categories of Data

This happens all the time; you get a set of data and you realize that whatever category is there, is wrong. Here’s a video showing how to re-categorize the data quickly and easily. It uses a few formulas, and we have videos showing those in detail. Continue reading

Posted in Best Practices, Excel, Video | Tagged , , , , , , , , , , | Leave a comment

The Art of Charting in Excel

As a Business Intelligence professional you need to know how to make a good chart 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 3 of a 3 part series on how to create compelling charts in Excel. Continue reading

Posted in Best Practices, Communication, Excel, Presentations, Video | Tagged , , , , , , , | Leave a comment

Confounded new tool, Whippersnappers, and why the new Excel is great!

Change is hard for people. People spend over half of their energy just trying to keep things the same. Then came “the new” Excel. Here are our favorite new features.. Continue reading

Posted in Best Practices, Communication, Excel, Purpose | Tagged , , , , , , , , , | 2 Comments

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.
Continue reading

Posted in Best Practices, Communication, Excel | Tagged , , , , , , , | 12 Comments

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. Continue reading

Posted in Best Practices, Communication, Excel, Presentations, Video | Tagged , , , , , , , | Leave a comment

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. Continue reading

Posted in Best Practices, Communication, Presentations, Uncategorized | Tagged , , , , , , , , , , , , | 3 Comments

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. Continue reading

Posted in Excel, Presentations, Video | Tagged , , , , , , , | 3 Comments

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.

Continue reading

Posted in Best Practices, Communication | Tagged , , , , | Leave a comment

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? Continue reading

Posted in Best Practices | Tagged , , , , , | 2 Comments

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. Continue reading

Posted in Uncategorized | Tagged , , , , , , , | 2 Comments