Business Functions Library for Excel

      1. Getting Started
      2. Using The Help File
      3. Top Dozen Functions
      4. Golden Rules
      5. Excel 2007
      1. Go To
      2. Function Selector
      3. CalculateFull
      4. Calculate WorkSheet
      5. Trace Facility
      6. Quick Paste Example
      7. Tutorials
      8. Function Finder
      9. Examples
      10. Help
      11. Excel"s Function Wizard
      12. Access Internet
      13. Usage of Functions (Audit)
      14. Uninstall
      1. Time Periods
      2. Inclusive and Exclusive Dates
      3. Using Daycount
      4. Examples of DayCount
      5. Annual Date Sequences
      6. ProjMode and Inclusive Dates
      7. Date Rolling Convention
      1. Rate Projections Functions Walkthrough
      2. Accruals and Cash
      3. Repeating Formulae
      4. Range Names and References
      5. Optional Parameters
      6. Using PmtsPerYear
      7. Modelling Seasonality
      8. Calculating Interest
      9. Using Business Functions in VBA (Visual Basic for Applications)
      10. Array Functions
      11. Volatility
      12. Annual Equivalent Rates
      13. Array Function
      14. Auto Multi Functions
      15. Variable Plurality
      16. GoalSeek
      1. Introduction To the Worked Examples
      2. Daycount
      3. General Projections
      4. Business Plans
      5. Cashbasis And Periods
      6. Using Timebases
      7. Using Dates
      1. How To Generate a time scale for a structured financing
      2. How To Project Rents off a Rental Forecast
      3. How To Run a model on different time bases
      4. How To Isolate The Cause of a Errors in Cells using Trace
      1. Introduction to the Utilities
      2. Audit
      3. Synchronized Range Insert/Delete
      4. Database Edit
      5. Insert Macro Button
      6. Link Analyser
      7. Range Describer
      8. PrintScript (beta)
      9. Create Local Range Name
      1. Number Formats
      2. Apply BF"s Color Palette
      3. Bullets
      4. Color Cells
      5. Conditional Formats
      1. Validation DropDowms
      2. Validation Standards
      1. Select Excel Function
      2. Array Function Tools
      3. Sort Sheets
      4. Range Value
      5. Named Range Manager
      6. Enforce WorkBook Settings
      7. Monte-Carlo
      8. TimeChart
      1. The ".ini" file
      1. Forum
      2. Online Help
      3. Templates
      1. Conversion of Input Strings to Values
      2. List of Holidays
      3. Acknowledgements and Trademarks
      4. Published Editions Changes in Behaviour
      5. Range Handling And Constraints
      6. Dates in Excel and Business Functions
      7. Old Composite DayCount Format
      8. DayCount in Excels"s Functions
      1. NPV of Annual To Periodic CashFlows - CorrectionM
      2. Interest - Simple, Annual, Continous and Discount Factors
      1. New Functions
      2. Obsolete Functions
      3. Discontinued Functions
      4. Deprecated Functions
    Introduction to the Utilities
    The Utilities that come with BF
    Although Business Functions is not a Utilities package, there a few utilities that we feel are just essential if you spend any length of time financial modelling. These don"t do anything you can"t do yourself through the standard Excel menus, they just do it (in our view) faster.
    The current list of Utilities is:
    • Range Value This takes its name from the Lotus 1-2-3 command that converts a range of cells to numbers (whether they contain formulae or not). It"s a bit like Excels Paste Special command.
    • Delete ┬┐Range Names┬┐ In some versions of Excel range names hung around even though you thought they were deleted. This utility deletes named ranges for good.
    • Go To The most common thing you need to do in Excel is navigate to the sheet in the workbook you are working on. This utility makes that easy, you can also navigate to a named range as well.
    • Enforce WorkBook Settings Sometimes it?s a good idea to enforce some settings you commonly have (eg show/hide grid etc) to the whole workbook, quickly. This utility uses settings you have in your BusFun.ini and enforces them on the current workbook.
    • Sort Sheets You can sort sheets in ascending or descending order with this sheet sorting algorithm.
    • Range Describer . This tells you information about a range, or a rangename. Its sometimes irritating trying to find out where in the workbook a rangename is - this utility addresses that.
    • Link Analyser. Finds the cell locations of links to other files, including in named ranges.
    • Create Local Range Name. Creates a local range name.

Business Functions Ltd, London, UK Website Design: Webpure