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
H
-
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
I
-
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