ࡱ> NPM%` 3bjbj 8H̟̟+6 6 6 6 4j j >>>>>>>$ hl"?Q>>QQ?>>T???Q >>?Q??rTu> ]Lz6 [j0V2#q2#uuh2#<>0n"?>>>??5 >>>QQQQ d  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  HYPERLINK "http://spreadsheetpage.com/downloads/xl/meetingbingo.xls" \o "http://spreadsheetpage.com/downloads/xl/meetingbingo.xls" Generate Meeting Bingo Cards Generate meeting bingo cards to liven up boring meetings.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/datecalculation.xls" \o "http://spreadsheetpage.com/downloads/xl/datecalculation.xls" Day Calculations A workbook that contains formulas to perform calculation  HYPERLINK "http://spreadsheetpage.com/downloads/xl/taskbar.xla" \o "http://spreadsheetpage.com/downloads/xl/taskbar.xla" Workbook Taskbar Add-In This add-in displays a toolbar that makes it easy to switch among all active workbooks.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/color-difference.xls" \o "http://spreadsheetpage.com/downloads/xl/color-difference.xls" Functions To Quantify Color Contrast This workbook contains VBA functions that can help you select legible colors for cell background and text.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/worksheet%20functions.xlsx" \o "http://spreadsheetpage.com/downloads/xl/worksheet%20functions.xlsx" Excel 2007 Function List An Excel 2007 workbook that contains a list of all worksheet functions, in a table.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/speechcommands.xlam" \o "http://spreadsheetpage.com/downloads/xl/speechcommands.xlam" 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  HYPERLINK "http://spreadsheetpage.com/downloads/xl/wordfrequency.xls" \o "http://spreadsheetpage.com/downloads/xl/wordfrequency.xls" Generate A Word Frequency List A workbook that demonstrates a VBA macro that creates a word frequency list.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/driveinfo.xls" \o "http://spreadsheetpage.com/downloads/xl/driveinfo.xls" Display Disk Drive Information Contains VBA macros that display information about the drives attached to your system.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/chart%20slide%20show.xls" \o "http://spreadsheetpage.com/downloads/xl/chart%20slide%20show.xls" Slide Show Demo Demonstrates a simple VBA macro that displays a full-screen slide show of all embedded charts on a worksheet.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/yearly-calendar-with-holidays.xls" \o "http://spreadsheetpage.com/downloads/xl/yearly-calendar-with-holidays.xls" Yearly Calendar - With Holidays This add-in provides several chart-related utilities:  HYPERLINK "http://spreadsheetpage.com/downloads/xl/yearly-calendar.xls" \o "http://spreadsheetpage.com/downloads/xl/yearly-calendar.xls" 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.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/mp3filelister.xls" \o "http://spreadsheetpage.com/downloads/xl/mp3filelister.xls" MP3 File Lister An Excel application that generates a list of MP3 files.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/animatedcolors.xlsm" \o "http://spreadsheetpage.com/downloads/xl/animatedcolors.xlsm" Animated Color Scales A 62x62 range of cells contain simple formulas that use the SIN and COS functions.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/smilechart.xls" \o "http://spreadsheetpage.com/downloads/xl/smilechart.xls" 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.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/mailmerge.xls" \o "http://spreadsheetpage.com/downloads/xl/mailmerge.xls" Mail Merge Demo Normally, Microsoft Word is used for mail merge operations.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/rangesel.xls" \o "http://spreadsheetpage.com/downloads/xl/rangesel.xls" Range Selection Demo Contains 15 VBA procedures that demonstrate how to make various types of range selections.  HYPERLINK "http://spreadsheetpage.com/downloads/xl/permute.xls" \o "http://spreadsheetpage.com/downloads/xl/permute.xls" Permutation Demo Demonstrates a recursive VBA procedure to generate all possible permutations of a text string.  HYPERLINK "Download:progind.xls" \o "download:progind.xls" \t "_parent" Progress Indicator Demo Demonstrates how to create a graphic progress indicator in a User Form.  HYPERLINK "Download:imagemap.xls" \o "download:imagemap.xls" \t "_parent" Clickable Image Map Demo Demonstrates how to create a clickable image map for navigation within a workbook.  HYPERLINK "Download:multiplebuttons.xls" \o "download:multiplebuttons.xls" \t "_parent" Multiple User Form Buttons With One Procedure With a User Form, each control on the form has its own  HYPERLINK "Download:nodupes.xls" \o "download:nodupes.xls" \t "_parent" Unique Items In A List Box Demonstrates a clever technique to fill a List Box with non-duplicated items in a list.  HYPERLINK "Download:colorpicker.xls" \o "download:colorpicker.xls" \t "_parent" 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.  HYPERLINK "Download:displayhelp.xls" \o "download:displayhelp.xls" \t "_parent" Displaying Help Topics This file demonstrates a technique that lets you display a series of help topics in a User Form.  HYPERLINK "Download:menumakr.xls" \o "download:menumakr.xls" \t "_parent" 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)  HYPERLINK "Download:formcharts.xls" \o "download:formcharts.xls" \t "_parent" Display Charts In A User Form Demonstrates how to display one or more charts in a User Form.  HYPERLINK "Download:hyperlinks.xls" \o "download:hyperlinks.xls" \t "_parent" User Form Hyperlink Demo Demonstrates how to simulate hyperlinks on a User Form.  HYPERLINK "Download:GetOption.xls" \o "download:GetOption.xls" \t "_parent" 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.  HYPERLINK "Download:soundex.xls" \o "download:soundex.xls" \t "_parent" Sound-x Demo Demonstrates a technique that lets you search for a text based on how it sounds.  HYPERLINK "Download:ChartSeriesInfo%20Class.xls" \o "download:ChartSeriesInfo%20Class.xls" \t "_parent" 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.  HYPERLINK "Download:custmfmt.xls" \o "download:custmfmt.xls" \t "_parent" Custom Number Formats This workbook contains several examples of useful custom number formats.  HYPERLINK "Download:hangman.xls" \o "download:hangman.xls" \t "_parent" Hangman Game The classic word-guessing game, programmed in VBA  HYPERLINK "Download:array%20formula%20calendar.xls" \o "download:array%20formula%20calendar.xls" \t "_parent" Array Formula Calendar This workbook contains a VBA macro that creates a "live" calendar in a worksheet.  HYPERLINK "Download:xlsketch.xls" \o "download:xlsketch.xls" \t "_parent" Excel Doodle Pad Etch-a-Sketch with a new twist.  HYPERLINK "Download:xlguitar.xls" \o "download:xlguitar.xls" \t "_parent" Guitar Scales And Modes This workbook depicts a guitar fret board. Select the key and scale/mode, and you see where the notes fall.  HYPERLINK "Download:apptcal.xls" \o "download:apptcal.xls" \t "_parent" Appointment Calendar Maker This workbook produces calendar/appointment pages that can be printed.  HYPERLINK "Download:gwynn2.xls" \o "download:gwynn2.xls" \t "_parent" Tony Gwynn's Hit Database An Excel database table with information about Tony Gwynn's first 3,000 hits  HYPERLINK "Download:supersub.xla" \o "download:supersub.xla" \t "_parent" Superscript / Subscript Formatting Add-In Simplifies individual character formatting for superscript, subscript, bold, italic, and font size  HYPERLINK "Download:namelist.xla" \o "download:namelist.xla" \t "_parent" 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)..  HYPERLINK "Download:gantt.xls" \o "download:gantt.xls" \t "_parent" Gantt Chart Demo Demonstrates how to create a "time line" (Gantt) chart in Excel  HYPERLINK "Download:rowdel.xla" \o "download:rowdel.xla" \t "_parent" Conditional Row Delete Add-In This add-in makes it very easy to delete rows based on the values in a specified column.  HYPERLINK "Download:keno.xls" \o "download:keno.xls" \t "_parent" Keno For Excel Of all the popular gambling games, none has worse odds than Keno  HYPERLINK "Download:selbyfmt.xla" \o "download:selbyfmt.xla" \t "_parent" 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  HYPERLINK "Download:datereport.xla" \o "download:datereport.xla" \t "_parent" Date Report Add-In The J-Walk Date Report add-in can help you identify such problems.  HYPERLINK "Download:xdate.zip" \o "download:xdate.zip" \t "_parent" Extended Date Functions (XDATE) Excel cannot work with dates prior to the year 1900.  HYPERLINK "Download:cellmath.xla" \o "download:cellmath.xla" \t "_parent" Cell Math Add-In The Cell Math add-in provides an easy way to modify cells without using formulas  HYPERLINK "Download:controls%20on%20sheet.xls" \o "download:controls%20on%20sheet.xls" \t "_parent" Active-x Control Demo: Demonstrates the use of ActiveX controls on a worksheet.  HYPERLINK "Download:time%20sheet.xls" \o "download:time%20sheet.xls" \t "_parent" Employee Time Sheet This workbook makes it easy for an employee to track his or her daily work hours  HYPERLINK "Download:clockchart.xls" \o "download:clockchart.xls" \t "_parent" Analog Clock Chart This workbook contains an XY chart that displays a working analog clock.  HYPERLINK "Download:calculator%20toolbar.xla" \o "download:calculator%20toolbar.xla" \t "_parent" Toolbar Calculator An add-in that displays a new toolbar that functions as a simple calculator.  HYPERLINK "Download:diceroller.xls" \o "download:diceroller.xls" \t "_parent" Dice Roller This workbook simulates rolling two dice  HYPERLINK "Download:hypocycloid%20-%20animated.xls" \o "download:hypocycloid%20-%20animated.xls" \t "_parent" 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.  HYPERLINK "Download:climate_data.xls" \o "download:climate_data.xls" \t "_parent" Climate Data Workbook A highly interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros.    k l | } 3 4 K L 3 4 Y Z ` a y z Z[|}fgTUstbcrsǸǸǣǸǸǸǸǸǸǸǸǸǸǸǸǸǸǸǸǸh&OJQJh" h0JOJQJjh" hOJQJUh" hOJQJh" OJQJ h" h" 5B* OJQJph'h" h" 5>*B* CJ4OJQJph@   E & Fgdtmgd &dPgd" 3no fg|}ST`aijyz56JK#$45EF^_hq%-.Yah" h&OJQJh" h&0JOJQJh" h0JOJQJjh" hOJQJUh" hOJQJL+4no1:=> "#$uv' ( 1 @ A o x z { !(!D!M!t!u!!!!!!!!""""""" # #Z#[#p#q#ضh&0JOJQJh" h&0JOJQJh" h&OJQJh" h0JOJQJh" hOJQJjh" hOJQJUHn=t!!" ##J$(%%&/''()K*++z,%--w.1//0h113 & Fgdtmq###$ $$$J$K$$$$$(%)%v%w%%%%%%%&&1&;&&&&&&&0'1'z'{'''''1(2([(\((())!)"))))) * *K*L*****++U+V+d+e+++++ ,,z,{,,,,,$-h" h&OJQJh" h0JOJQJjh" hOJQJUh" hOJQJQ$-%-&-m-n-----..$.%.w.x........../1/2///////@0A0S0T0001111h1i1111111c2d222222333]3^3s3t33ĺޯޯh" h&OJQJh&0JOJQJh" h&0JOJQJh" h0JOJQJh" hOJQJjh" hOJQJUh&OJQJA33 & Fgdtm33h" hRCOJQJ6&P 1h:p&. A!"#$% @@@ NormalCJ_HaJmH sH tH DA@D Default Paragraph FontRi@R  Table Normal4 l4a (k@(No List4U`4  Hyperlink >*ph+ H   En=t! J(/ !K"##z$%%%w&1''(h))++00000 0 0 0 0 0 0 0 0 0 0  0  0  0  0  0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  0! 0" 0# 0$ 0% 0& 0' 0( 0) 0* 0 0 0 0 0 0 0+Z00Z00 00Cq#$-33 !#33"3k|3K3Y`yZ|fTsb r n  f | S`iy5J#4E^-n=#u'@zt! ZpJ(v0z1 [ !!!!! "K"""#U#d### $z$$$%%m%%%&$&w&&&1''''@(S(())h))))c**+]+s++XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXiCjkĴ +++ +++B*urn:schemas-microsoft-com:office:smarttagscountry-region9*urn:schemas-microsoft-com:office:smarttagsplace ++3hq%-Ya+41: "(1(**+++M 6AUs|Pxn 6,rs|h^`OJQJ^Jo(hHoh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHAU,rPxnM                  Q'Nt~N$Nl?N1UFU vPt~N1UFU vPQ' 7R_tm+{" a`&RC@""T<""+@UnknownGz Times New Roman5Symbol3& z Arial7&{ @Calibri?5 z Courier New;Wingdings"hAFAFX%OX%O!924d++2QHX)?24Here are some tools that we find particularly useful ahmad.ladhani ahmad.ladhani    Oh+'0$ <H h t 8Here are some tools that we find particularly usefulahmad.ladhaniNormalahmad.ladhani2Microsoft Office Word@F#@g;z@g;zX%՜.+,D՜.+,` hp|  akuO+' 5Here are some tools that we find particularly useful Title 8@ _PID_HLINKSAh8xDownload:climate_data.xlsT%Download:hypocycloid - animated.xlsDownload:diceroller.xlsP!Download:calculator toolbar.xlaDownload:clockchart.xlsRDownload:time sheet.xlsc Download:controls on sheet.xlspDownload:cellmath.xla"Download:xdate.zip~Download:datereport.xlam{Download:selbyfmt.xlacxDownload:keno.xlsuDownload:rowdel.xla!rDownload:gantt.xlszoDownload:namelist.xlablDownload:supersub.xlaiDownload:gwynn2.xlsBfDownload:apptcal.xlsqcDownload:xlguitar.xlsk`Download:xlsketch.xls ]%Download:array formula calendar.xlsYZDownload:hangman.xlsvWDownload:custmfmt.xls%T$Download:ChartSeriesInfo Class.xlsFQDownload:soundex.xls8NDownload:GetOption.xlsKDownload:hyperlinks.xlsHDownload:formcharts.xlscEDownload:menumakr.xlsKBDownload:displayhelp.xlsQ?Download:colorpicker.xlsU<Download:nodupes.xlsR9Download:multiplebuttons.xlsj6Download:imagemap.xlsN3Download:progind.xls/'04http://spreadsheetpage.com/downloads/xl/permute.xls -5http://spreadsheetpage.com/downloads/xl/rangesel.xlsCT*6http://spreadsheetpage.com/downloads/xl/mailmerge.xlsbe'7http://spreadsheetpage.com/downloads/xl/smilechart.xlsvr$<http://spreadsheetpage.com/downloads/xl/animatedcolors.xlsm[!:http://spreadsheetpage.com/downloads/xl/mp3filelister.xlsv5<http://spreadsheetpage.com/downloads/xl/yearly-calendar.xlsLJhttp://spreadsheetpage.com/downloads/xl/yearly-calendar-with-holidays.xls=http://spreadsheetpage.com/downloads/xl/chart slide show.xlsTP6http://spreadsheetpage.com/downloads/xl/driveinfo.xlsYU:http://spreadsheetpage.com/downloads/xl/wordfrequency.xlsyb<http://spreadsheetpage.com/downloads/xl/speechcommands.xlamI Ahttp://spreadsheetpage.com/downloads/xl/worksheet functions.xlsxI =http://spreadsheetpage.com/downloads/xl/color-difference.xls*04http://spreadsheetpage.com/downloads/xl/taskbar.xla1*<http://spreadsheetpage.com/downloads/xl/datecalculation.xls9http://spreadsheetpage.com/downloads/xl/meetingbingo.xls  !"#$&'()*+,-./012345689:;<=>@ABCDEFGHIJKLORoot Entry FpLzQ1Table%N#WordDocument8HSummaryInformation(7DocumentSummaryInformation8?CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q