There is no one-size-fits-all answer to this question, as the method for calculating dirty bond price in Excel will vary depending on the specific bonds being traded and the information available. However, some tips on how to calculate dirty bond prices in Excel include:
1. Use a bond pricing model that is appropriate for the type of bonds being traded.
2. Gather data on the relevant Bond market yield curves. This can be done, for example, by using Bloomberg or another financial data provider.
3. Use an Excel function such as PV() to calculate present value, taking into account factors such as coupon rate, time to maturity, and current yield curve conditions.