peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Introduction to Business Graphics 1982

"In the back of my mind, I always knew that charts would help me," says the market researcher in this promotional video from 1982. Wow, did you really have to wait weeks for your data processing department to make your charts, back in the old days?

The graphs haven't changed much in the 28 years since this video, Introduction to Business Graphics, was filmed, but at least the presentation technology has improved. Do you remember using those gigantic overhead projectors, and scrambling to get your transparencies ready in time for the meeting?

Apparently Apple Business Graphics wasn't quite as popular as Excel though, because the announcer boasted that it was currently being used in "over 6000 offices".

If you want to make your Excel charts look like they were made in 2010, instead of 1982, see the Excel Charting tutorials on Jon Peltier's blog. He sells some Excel charting utilities

Continue reading Introduction to Business Graphics 1982

April 7th, 2010 | Category: Excel charts | One comment

Trouble Unhiding Excel Row and Columns

It's easy to hide rows and columns in an Excel worksheet, and you or your boss or co-worker might do that when setting up an Excel file.

However, if you hide Row 1 or Column A in an Excel worksheet, you might have trouble unhiding them. This short Excel tutorial video shows you a quick way to see those hidden rows and columns again.

___________

April 5th, 2010 | Category: Excel Formatting, Excel tips | 6 comments

Excel Treasure Hunt Game

If you have the day off, you can spend some time playing this Excel Treasure Hunt game. Or, if you celebrate Easter, give this to your kids -- it's cheaper and easier than hiding chocolate eggs!

How to Play the Game

The main worksheet has 25 dark green cells, invisibly numbered 1 to 25. Some of the cells have a flower (good) and some have a raindrop (bad).

Type a number, between 1 and 25, in each of the blue cells, to reveal the hidden items in those numbered cells. Your score -- the number of "good" items that you found -- appears below the green grid. To clear the blue cells, and scramble the hidden items, click the New Game button.

Change the Game

If flowers and raindrops aren't manly enough for you, or if you get bored easily, you can select a different game.

Click the data

Continue reading Excel Treasure Hunt Game

Related Posts Plugin for WordPress, Blogger...
April 2nd, 2010 | Category: Excel Data Validation, Excel Formatting, Excel Formulas, Excel Templates | 2 comments
« Newer Entries