Book

Suggestions

Delivered by FeedBurner

Bloglines

1906
2006

OfficeZealot

Scobleizer

TechRepublic

SpyJournal

 Web http://www.klippert.com

Monday, December 14, 2009 – Permalink –

## And a Functional New Year

It is rather late in the season, but this is a gift that gives all year long:
This hilarious clock is the perfect accessory for any Excel power user. Each numeral has been replaced with a suitable Excel function that will evaluate to that numeral.

We've used one function from as many function categories as possible to really provide a broad range of functions.

For instance:
=FACT(3) - The FACT() function returns the Factorial of a number. The Factorial of 10 is 10x9x8x7x6x5x4x3x2x1. This function is great for statisticians calculating combinations and permutations. In our case, the Factorial of 3 is 3x2x1 or 6

MrExcel.com:

Excel Function Clock

See all Topics

Labels: ,

<Doug Klippert@ 3:20 AM

Thursday, August 23, 2007 – Permalink –

## A range of expressions

Ivan F Moala of XcelFiles.com has created a fascinating use for Excel.

The application/macro converts Bmp (24Bit & 256), Gif, Jpg, Jpeg files into Excel spreadsheets!

Images to Excel

Excel 2003

This picture covers a range of A1:BL74, 4,736 cells, viewed at 15% zoom.

Excel 2007

This picture covers a range of A1:GR300, 60,000 cells, viewed at 10% zoom.

See all Topics

Labels: ,

<Doug Klippert@ 6:40 AM

Saturday, March 24, 2007 – Permalink –

## A nice sparkle

After working hours to perfect an Excel project, the last little piece that adds a touch of class, is a splash screen.

Here are the instructions to construct this type of user form including a workbook that you can download:
Userform - Splash screens

Ivan F Moala administers this interesting site called The Xcel Files

See all Topics

Labels: , ,

<Doug Klippert@ 5:26 AM

Friday, February 16, 2007 – Permalink –

## Don't go away

If your macro is going to take a bit of time to complete, it is good manners to inform your users what is going on. If screen updating is turned off, they may think their machine has frozen.

Andy Pope has some great charting examples and also demonstrates a number of
Progress meters

Here's a static example:

John Walkenbach, also, has tips about how to create a Progress indicator

also see:
Chip Pearson

Dick Kusleika

See all Topics

Labels: ,

<Doug Klippert@ 6:35 AM