How to Use Excel in a Rate Card Formula. Use Excel in your rate card formulas to calculate discounts, dimensions and unit costs of your advertising rate document. Instead of manually calculating ...