The Smokey Lake

Excel Help

site

Need help with Microsoft Excel?

 

Data in Excel   (Aug 19, 2005)

Covers how data is stored and formatted in cells.

Editing tips

A compilation of sheet editing tips and techniques for intermediate users. It's not a tutorial, just a once-over.  Not too terse, not too wordy.

Excel web resources

Sites with information on Excel

Excel truths

Some basic information to consider before you undertake certain tasks

Formatting as data (sorting on color).
Data across Multiple Sheets.
Database
Dates and times

Numbers in a formula
Running total in a cell using a circular reference
Sorting in Excel
Sorting dates in Excel

Text files and Excel  

A treatise on the "universal language of data," ASCII, or text files. 

Text Write Program    (Updated Mar 30, 2007)

A downloadable free utility.  It writes any worksheet to a text file with lots of options.  It's an Excel workbook with a macro program. Not affected by Windows settings, so dates and other things get written exactly as they appear in the workbook.

Excel Juke-box program

A downloadable free utility.  It makes a list of your audio files (wav, mp3, whatever) from your folder, and lets you play them at random.  Also allows you to make a separate playlist.  Completely finger-driven (can be operated without the mouse for fast on-stage use).

VFAQ

Some very frequently asked questions about Excel.  Not a giant collection of every question that's ever been asked -- just the biggies.  Actually not in Q/A format for quicker scanning.

Would you rather have me do it for you?

I can help you unleash the power of Excel with workbook design, macro coding, and other areas of your project.  Or I can develop it completely for you. Call or write for a quote.  I am a retired IBM Systems Engineer (27 years) and Microsoft Excel Most Valuable Professional (5 years now). 

Customers include:

A radio station (commercial and private donor management)

An oil distribution company (storage tank management and automated information submission to state commission)

A hospital communications company (floor design/component configuration).

A fertilizer distribution company (marketing contact management, fertilizer program tool)

An insurance firm (sales representative records)

A physical therapy firm (patient records).

Five years now (2002-2006), a Microsoft Excel MVP.

http://mvp.support.microsoft.com/

 

OK, so it's been a few years since this pic was taken.  I was in Hawaii at the time.

Earl Kiosterud

4437 Smokey Lake Drive

Virginia Beach, VA 23462

757 495-2578

Email: 

Sorry for the email not being a link, but the spambots (spam robots) are everywhere.