This project provides a comprehensive suite of VBA modules within Excel for bond pricing and analysis, incorporating external rate curves and LIBOR rates for accurate calculations, while also managing ...

Advanced users can even write VBA code to retrieve data from an Access database or a web service and update their Excel database automatically.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

Open the Excel workbook that contains the chart whose trend-line equation you want to access. Press "Alt-F11" to open Excel's Visual Basic Editor.