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

Adding calculations

Here we will add a column D to multiply cells in C with those in A

  1. on cell D1 add the heading label "Salary"

  2. Click on C1, then click on the paintbrush icon to copy the formatting from the selection - then click on D1

  3. In D2 type in =A2*C2

  4. Drag the bold green dot seen in the cell border from D2 to D21

    This results in a table that may not have enough space to show the values in column D - the value ###### is shown where the number does not fit....

  1. Move the mouse cursor to over the right side of the column D header so that the icon changes to ; then double click at this point to auto-fit the column width replace any ### values in the column with the actual value.