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
    Getting Started
    A few pointers
    There"s a few ways to get started if you haven"t used a function library like Business Functions before. All these are available from the Business Functions menu.

    • Tutorials . This is perhaps the easiest introduction. The tutorials are under the examples menu, and the "Introduction" is the most basic.

    • Quick Paste Examples are found under the Examples menu. If you"ve got a blank worksheet in front of you then selecting this from the menu will paste an example right into your worksheet. There"s a handful of functions listed and they are all quite straightforward, but they show what the library is basically is about. Recommended.

    • The Function Finder is a browser to view the entire Business Function Library. You can also open a spreadsheet example of each function here.
    • The Examples section of the BF menu enables you to tap into the Worked Examples, on specific business themes, as well as the Component Examples (there are over 500, one for every single function). The Business Plan example is quite a good one. You can load up the spreadsheet from the menu and save it under a different name. The Project Budget is quite general purpose too.

    • Help. Have a look through this Help file, particularly at topics like Using The Help File, Top Dozen Functions and Introduction To the Worked Examples.

    • Once you get proficient, the Function Selector is the fastest way of accessing and browsing for functions. Its also the fastest way to load up a spreadsheet example of each function. Each example is a self-contained spreadsheet so you don"t make any changes to your existing worksheet.

    • On the web the is a Sample Models (or sometimes called Templates) page that has further examples.

Business Functions phone: +44 (0)20 8144 9374 (London UK)
Website Design: Webpure