EXCEL COURSE PART ONE - FORMATTING A …

So you want to see the gross margin percentage your salesmen are making on sales. We will use the Formulas option to calculate gross margin percentage (i.e. Margin divided by Net Sales value). Right click on the pivot table for menu. Select: Formulas – Calculated Field [In Excel 2003 the Formulas option is rather hidden away. ................
................