....Home.....Project Finance.....Corporate Finance.....Databases.....Risk....Energy Analysis.....Excel Utilities......Writings

Execl Utilities and Documentation

email: edwardbodmer@gmail.com

Read PDF File.JPG

Generic Macros and Functions to Import

Download Excel Utilities and Documenation of Excel Techniques

The fm.xls file is a file that I have created which includes a whole lot of macros that do various things ranging from making a table of contents to fixing the problems with data tables in excel

Sometimes, companies that overdo the paranoia about protection and I have found some problems in opening and running the fm file. To address this issue I have separated the fm file in various components such as the table of contents, the data tables, the functions and other items. If you are having trouble with the fm file go to the fm components page and try the various components. For using the fm.xls file and other useful excel techniques, there are video instructions. To use the video instructions, select the item, watch the short video and listen to my irritating voice.

User Defined Short-Cuts.JPG
Watch Video

Colouring Titles.JPG
Watch Video

Table of Contents.JPG
Watch Video

Data Table Fix.JPG
Watch Video

List of Short-cut Keys including Apple Short-cuts

Download File that Includes Translations for Various Excel Functions

This file contains a list of functions in differnt languages. For example the average function in english is listed as MOYENNE in french. This file is useful if your computer is not in english and you are reading about excel in english or attending a course where the excel is in english. (The 2007 version of excel allows you to change languages meaning that this may be most useful for excel 2003 and earlier versions.)

The file below was created by Sergev from Moskow

Video Instructions for FM.xls file and Other Excel Techniques

Video Instructions for Adding Data Tables
Video Instructions for Including Payback, Volatility, Interpolate and Other Functions to Models
Video Instructions for Adding Table of Contents and Input Colours to Models
Goal Seek Macro Video
Solver Video
Solver Macro Video

File for adding flexible data tables to a model that allow macros and inputs from different sheets. Add all of the macros from this sheet into a financial model and then you can run the flexible data tables.

Video Instructions for Adding Multiple Data Tables to a File