Using the Excel Spreadsheet (Part 2)
Okay so I’ll be teaching you how to do simple mathematical operations on the excel spreadsheet and applying it to a simple sales record sheet. First of all we need to have to arrange cells in a tabular format starting from Column B2 like the picture below: We’ll then fill in values in rows for the following columns; S/N, Commodity, Price and Qty. I used a computer store as an example; Next I’ll highlight my cells using the Ctrl + A keys on the keyboard or click and drag from cell B2 then click on “Format as Table”; select a table colour of my choice and check the box “My table has headers. Now we can input the formula for total at F3. The formula would be “=[@Price]*[@Qty]” To get the subtotal, you could use a simple formula at the bottom of the total you could use the quick analysis by highlighting all the cells under the total column the press the Ctrl + A keys on the keyboard, Click Total and then SUM: OR you write the formula manua
