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 Topics Pivot TablesAdvanced Topics MacrosAdvanced Topics VLOOKUPsFinal Steps
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

Steps:

  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.

square

Also see

articles/Excel101square

Comments

New Comment

NOTE: (Put code blocks in [[[ and ]]] markup to be formatted.)

(Posted comments will be checked by the administrator before being published)



PrivacyCookies