Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Monday, December 14, 2009 – Permalink –

Have a Geeky Christmas

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

Comments: Post a Comment


  Thursday, August 23, 2007 – Permalink –

Paint with Excel

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!


See the screen shots and download the free workbook:
Images to Excel



Excel 2003

Excel Picture

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

Comments: Post a Comment


  Saturday, March 24, 2007 – Permalink –

Splash Screens

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

Comments: Post a Comment


  Friday, February 16, 2007 – Permalink –

Progress Gauge

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:

Progress display

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

Comments: Post a Comment