Excel Solutions G-I

G
Games: Games and time-wasters, demonstrates different programming techniques.
Gantt Chart for Scheduling Resources
Gantt Chart Sample Add-In Available for Download
Gantt (Project) chart
Generate a Custom Greeting -- Uses a text string to generate a custom birthday greeting
Generate an Internet Calendar file. Hard to describe before you see the example .
Generate random passwords using Excel
Get the Format Painter to paint more
Get the windows directory
Getting around Reuters TS1 history date limitations
Getting the processor speed
GOTCHA! Watch out for this peculiarity of error-handling code.
Grab a single historical price
Grade Book: College of Saint Benedict | Saint John's University
Graph Co-Ordinates: Lets you determine to exact co-ordinates in a graph
Graphing Exponential Functions
Graphing Linear Functions
Graphing Polynomial Functions
Guidelines For Writing Spreadsheets
Gummy Stuff: Financial, stock information, plus using Excel.
"EVERYTHING ON THIS SITE MAY BE COPIED, CIRCULATED, DISTRIBUTED, REPRODUCED,
IGNORED, RIDICULED, etc. without seeking my approval"
Funny Excel pictures

Handling blank and zero values with live Reuters data
Handy Hints For SpreadSheets: Here you will find out how to use Excels Conditional Formatting and Data Validation. It explains in detail how you can use these great Excel features to work with duplications in your spreadsheets. Best of all it shows how they can be used to prevent them!
Hangman game
Heat map tool (VBA): It is an MS Excel macro that takes a table of numbers and turns it into a colored heatmap, where the brightness/hue is proportional to the size of the number.
Help Desk Metrics Spreadsheet: This demo file will be downloaded
Helpful Excel Web Site Links
Hide cell values
Hide/UnHide:: Some examples of how to hide and unhide sheets.
Hiding unused rows and columns
Historical Stock Quotes
How can I change the formatting of a cell immediately after data is entered?
How can I determine if a cell is within a particular range of cells?
How can I document my worksheet showing row and column heading?
How do I convert text dates to "real" dates? (an example among many possibilities!)
How do I save a file with the current date in the file name?
How to Dynamically fill a list box and pass the value to another routine .
How to get data validation messages to pop up automagically
How To Make a Bar Graph
How To Make a Graph
How To Make a Pie Chart
How to optimize PivotTable performance: This step-by-step article describes the options in steps 1 and 3 of the PivotTable Wizard, and explains how they affect memory usage, speed, and file size.
When you create a PivotTable, Microsoft Excel creates a hidden copy (cache) of the source data that it uses to perform aggregations and other PivotTable functions. By using this cache, Excel can quickly calculate PivotTables, while maintaining the integrity of the original data.
This cache can affect memory use, speed, and file size, depending on the options that you select when you create your PivotTable.
How to use the CHOOSE function
How To Use Web Graphics
HTML Color Chart
HTML Color Chart -- Here is the explanation.
Human Resources Audit Spreadsheet: This demo file will be downloaded

Igor Kolupaev: Excel Q & A from Belarus, Minsk city
Import Large Text Files: More than 65,536 records
Income Statements from the Internet
Increase Number of Undo Levels: By default Microsoft Excel keeps track of 16 undo levels, which provide an undo history for most actions you perform in Microsoft Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry. Microsoft recommends that you do not increase the number of undo levels beyond 100.
Increment A Set Of Dates By X Number Of Days Quickly
Increment Hours and Minutes in a String -- Module to build each time slot for a day
Input Boxes and Message Boxes:: A few simple examples of using input boxes to collect information and messages boxes to report the results.
Interactive Chart Creation: Choose on-the-fly where you want your chart to be drawn, and where to find the data you want to plot.
Investment Simulation Spreadsheet: This is a simulation of saving and investing for retirement. It shows how much you can accumulate in a tax-deferred retirement account (e.g. an IRA or 401k account) by saving a certain amount each year and investing it in a combination of fixed-interest and variable (equity) instruments.
Investment Simulation Spreadsheet: This is a simulation of saving and investing for retirement. It shows how much you can accumulate in a tax-deferred retirement account (e.g. an IRA or 401k account) by saving a certain amount each year and investing it in a combination of fixed-interest and variable (equity) instruments.
Invoice analyzer
Invoice\Stock keeper
IsError function
IT Risk Assessment Spreadsheet: This demo file will be downloaded

Last edited 07 March, 2010

Links verified 20 July, 2004