|
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.
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.
Sites with information on Excel
Some basic information to consider before you undertake certain tasks
Text files and ExcelFormatting as data (sorting on color).
Data across Multiple Sheets.
Database
Dates and timesNumbers in a formula
Running total in a cell using a circular reference
Sorting in Excel
Sorting dates in 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.
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).
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:
|
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.