Here are some tools that we find particularly useful



Finance Tools

By Ahmad Ladhani

Here are some tools that we find particularly useful. Some require Excel security to be set to "medium" because they contain VBA code, for a simple user interface. Click on the name to download any of the following for free

o Generate Meeting Bingo Cards Generate meeting bingo cards to liven up boring meetings.

o Day Calculations A workbook that contains formulas to perform calculation

o Workbook Taskbar Add-In This add-in displays a toolbar that makes it easy to switch among all active workbooks.

o Functions To Quantify Color Contrast  This workbook contains VBA functions that can help you select legible colors for cell background and text.

o Excel 2007 Function List An Excel 2007 workbook that contains a list of all worksheet functions, in a table.

o Speech Control Ribbon Enhancement Install this add-in, and you'll have a new group on the Review tab of the ribbon: Text to Speech

o Generate A Word Frequency List A workbook that demonstrates a VBA macro that creates a word frequency list.

o Display Disk Drive Information Contains VBA macros that display information about the drives attached to your system.

o Slide Show Demo Demonstrates a simple VBA macro that displays a full-screen slide show of all embedded charts on a worksheet.

o Yearly Calendar - With Holidays This add-in provides several chart-related utilities:

o Yearly Calendar Workbook A worksheet that displays a yearly calendar for any year between 1900 and 2100. Use the slider at the top to select the year.

o MP3 File Lister An Excel application that generates a list of MP3 files.

o Animated Color Scales A 62x62 range of cells contain simple formulas that use the SIN and COS functions.

o Smiley Chart The workbook contains a chart that looks like a smiley face. The amount of smiling (or frowning) is determined by the value of a cell.

o Mail Merge Demo Normally, Microsoft Word is used for mail merge operations.

o Range Selection Demo Contains 15 VBA procedures that demonstrate how to make various types of range selections.

o Permutation Demo Demonstrates a recursive VBA procedure to generate all possible permutations of a text string.

o Progress Indicator Demo Demonstrates how to create a graphic progress indicator in a User Form.

o Clickable Image Map Demo Demonstrates how to create a clickable image map for navigation within a workbook.

o Multiple User Form Buttons With One Procedure With a User Form, each control on the form has its own

o Unique Items In A List Box Demonstrates a clever technique to fill a List Box with non-duplicated items in a list.

o A Color Picker Dialog Box Demonstrates a custom VBA function that displays a User Form that lets the user select a color. Uses a class module.

o Displaying Help Topics This file demonstrates a technique that lets you display a series of help topics in a User Form.

o Menu Maker A table-driven technique that makes it very easy to create a custom menu for an Excel workbook or add-in. (Does not work with Excel 2007)

Display Charts In A User Form Demonstrates how to display one or more charts in a User Form.

o User Form Hyperlink Demo Demonstrates how to simulate hyperlinks on a User Form. Get Option Function Demonstrates a useful VBA function the displays a list of Option Buttons derived from an array. The User From and VBA code are created on the fly.

o Sound-x Demo Demonstrates a technique that lets you search for a text based on how it sounds.

o A Class Module to Manipulate a Chart SERIES A useful class module that makes it easy to work with the data used by a chart.

o Custom Number Formats This workbook contains several examples of useful custom number formats.

o Hangman Game The classic word-guessing game, programmed in VBA

o Array Formula Calendar This workbook contains a VBA macro that creates a "live" calendar in a worksheet.

o Excel Doodle Pad Etch-a-Sketch with a new twist.

o Guitar Scales And Modes This workbook depicts a guitar fret board. Select the key and scale/mode, and you see where the notes fall.

o Appointment Calendar Maker This workbook produces calendar/appointment pages that can be printed.

o Tony Gwynn's Hit Database An Excel database table with information about Tony Gwynn's first 3,000 hits

o Superscript / Subscript Formatting Add-In Simplifies individual character formatting for superscript, subscript, bold, italic, and font size

o Name Lister Add-In The Name Lister add-in displays a list of all names in a workbook, by category (Workbook level, Sheet level, Hidden, Linked, and Invalid)..

o Gantt Chart Demo Demonstrates how to create a "time line" (Gantt) chart in Excel

o Conditional Row Delete Add-In This add-in makes it very easy to delete rows based on the values in a specified column.

o Keno For Excel Of all the popular gambling games, none has worse odds than Keno

o Select By Format Add-In The J-Walk Select by Format Add-In makes it very easy to select cells based on their formatting attributes

o Date Report Add-In The J-Walk Date Report add-in can help you identify such problems.

o Extended Date Functions (XDATE) Excel cannot work with dates prior to the year 1900.

o Cell Math Add-In The Cell Math add-in provides an easy way to modify cells without using formulas

o Active-x Control Demo: Demonstrates the use of ActiveX controls on a worksheet.

o Employee Time Sheet This workbook makes it easy for an employee to track his or her daily work hours

o Analog Clock Chart This workbook contains an XY chart that displays a working analog clock.

o Toolbar Calculator An add-in that displays a new toolbar that functions as a simple calculator.

o Dice Roller This workbook simulates rolling two dice

o An Animated Hypocycloid Chart This workbook displays an infinite number of dazzling animated charts; similar may remind you of Hasbro's popular Spiro graph toy.

o Climate Data Workbook A highly interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download