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 Column Headings

  1. right click on cell A1, then select Insert... and Entire row

  2. Type in the following column names : ID, Name and Daily Rate

  3. select all three heading cells and then set the following format options

    • bold (from the Font ribbon toolbar)
    • horizontally centred (from the Alignment ribbon toolbar)
    • vertically aligned to the top of the cell (from the Alignment ribbon toolbar)
    • with a background colour of “a blue”(from the Font ribbon toolbar)
    • with a foreground colour of “white” (from the Font ribbon toolbar)

... resulting in.....