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

Utilising binary computed cells

Here we are going to utilise the previously computed field in order to take the data to the next step

To do this we are going to add a new column (F) with a label of Latest Salaries to multiple the Ind column values by those in the Daily Rate column

  1. In F2 add a new formula =E2*C2 and drag this down to E21

  2. Add a column heading reading Latest Salaries and format it using the paintbrush icon

  3. Click on the column header for `F, then move the mouse to close to the right of the column header cell so that the mouse icon becomes

  4. Then double click on the mouse position so that the column becomes wide enough to show the contents of all cells (in this case wide enough for the whole column heading to be visible)
square