OverviewStep 1 creating a seriesStep 2 adjust row heightsStep 3 add column totalsStep 4 add a names columnStep 5 add column headersStep 6 add currency formattingStep 7 freeze the column headingsStep 8 add a Salary columnStep 9 add a conditional formulaStep 10 add a COUNTIF formulaStep 11 utilising binary cellsStep 12 applying Conditional FormattingStep 13 adding text cellsStep 14 adding an AVERAGEStep 15 adding calculationsStep 16 adding a FilterStep 17 add a Pie Chart graphicStep 18 using the IF and CONCAT functionsADDITIONAL Work with timesADDITIONAL PrintingAdvanced Topic VLOOKUPsAdvanced Topics Pivot Tables
Excel training
First written: Feb-2024
last changed Mar-2024

Add an Average to the Salary column

  1. At the bottom of the Salary/D column (D22), add a formula to calculate the average of the column values by clicking on D22 and then the fx to get a Insert Function popup, then search for average

  2. Select the range D2:D21 for Number1 and click [OK]

  3. Check the result by comparing it with the value shown on the bottom right of the Excel window when you select the cells D2 through to D21

  4. Use the Format Painter icon to copy the formatting from the other total columns onto this new cell