Excel
 
  List of Topics


Info-Stat is no longer active in adding Excel information.
This is now done at Jim Colville, CPA
   
 
Back to Main List of Topics
 
Version Differences
 
Home
Macros and VBA
     The Macro and VBA articles are on these
     pages and have their own List of Topics
 

Excel Print Ranges
     Excel prints the entire worksheet rather than
     just the highlighted range. Learn how to 
     fully understand the Excel printing process.
 

Printing without the Gridlines
     By default, Excel prints the worksheet gridlines.
     Learn how not to print them.
 

Work with Visible Cells Only
     When you highlight cells that surround hidden rows
     and columns, the next command may or may not 
     affect the hidden cells. Learn how to work with visible
     cells only.
 

Printing Mailing Labels from your Excel
   Database
     This exercise describes how to print mailing
     labels for your Excel Database using the mail 
     merge feature in Word.
 

Concatenating Cells and Text
     Adding text in one cell to the text in another
     cell gives SuperPower to your Excel worksheets.
 

Working with Dates in Excel
     Dates to be Treated as Text. Sometimes dates do
     not act as expected. Formatting them as text may
     solved the problem.
 

Working with Dates in Excel
     Numbers entered display as Dates. Why? This
     article discussed some of the traps retaled to Excel's
     Auto Formatting
 

Defined Names (Range Names)
     Refer to a range of cells by name rather than by
     references. A reference to SALESREPORT is much
     easier to work with than a reference such as B6:G140.
 

Importing Lotus Files into Excel
     Importing and working with files created in Lotus
     and other programs.
 

The Basics of Copying Cells in Excel
     A complete step-by-step easy-to-follow exercise for 
     those users with little or no Excel experience. When
     this exercise is completed, the user will have a full 
     understanding of the basic Copy, Cut and Paste 
     commands and the related icons, menus and 
     keyboard shortcuts.
 

Files Open or Close Slow
     If your files seem to open or close very slow, then
     read about a possible cause and workaround. 
 

Stupid Fun in Excel 97
     Excel's hidden flight simulator. Fly to the Excel
     credit screen, even get a lakeside view. 
 

Restoring Excel Menus
     How to reset Excel menus back to their defaults. This
     useful when there are custom menu items that are no 
     longer used or you inherit a PC with custom menu 
     items that do not apply to you. 
 

Customizing the Toolbar
     Learn how to add your own custom and useful buttons 
     to the Excel Toolbar.
 

Budget Sample
     Sample of a dynamic budgeting spreadsheet. Shows 
     actual balances to date and budgeted amounts for 
     the rest of the year. Clicking here will cause the file 
     to be downloaded to your PC. When downloaded, 
     simply doubleclick on the file name (Budget.exe) in 
     Window Explorer to extract it to an Excel file.
 

Zero Out
     Many spreadsheets contain lots of text, numbers and 
     formulas. Think of a typical periodic report. The text and
     formulas remaining the same from reporting period to reporting
     period (maybe month to month). However, the numbers 
     change each period. Typically, the user desires to call up
     last month's report, erase last's months numbers, leaving the 
     text and formulas intact. Then, simply add the new numbers
     for the current month. However, sometimes erasing the
     old numbers can very tedious, especially in a complex
     spreadsheet. Download this file for an example how
     to accomplish this both with and without macros.
 

Count Specific Characters in a Cell
    This function counts the numbers of specific characters in a cell.
    It may count the number of occurances of the letter A, the
    number of spaces, the number of backslashes or whatever
    character you choose. A variation on the same formula counts
    the number of words in the cell.

 
 
 
 
 

 

 
Top

 
 
 
 
 
 
 
 
 
 

 

solutions@info-stat.com


 
 
 
 

Excel Class Files