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

The following applies to Excel in Windows 10+

Before you start, you need to Open Microsoft Excel and create a new worksheet

Part 1: Set up a range of numbers from 1-20 in Column A


  1. Add a starting number to cell A1

  2. Using the left mouse button, drag the bold green dot, seen on the bottom right of the A1 cell, down to row 20

  3. Now select the menu button that appears at the bottom of the drag

  4. Select “Fill Series” to make the series 1-20 appear

    ALTERNATIVELY, from step 1 use the right mouse to drag the green dot down to see a slightly different approach

Part 2: Set up a range of numbers from 500-10000 in steps of 500 in Column B

  1. Now create a new column of numbers in column B as shown below:

    Tip: Place “500” into cell B1, then place “1000” into B2; then select both cells and drag the green dot down to row 20.