The MS Excel tutorial provides basic and advanced concepts of Excel. Our Excel tutorial is designed for beginners and professionals. Microsoft Excel is a computer application program written by Microsoft. It mainly consists of tabs, groups of commands, and worksheets. It is mainly used to store tabular data. Our MS Excel tutorials cover all topics
Read moreMS Excel Tutorial
How to do addition in Excel
View image, showing additions of 10, 20 and 30. Select the cell where you want the result to appear in this example as cell C6. Then type in cell = sign in, now choose first cell C3 then type “+” sign then choose second cell C4, then type + and third cell choose C5. Now
Read moreSigma addition in Excel
Select the cell to display the result then click the Sigma button at the right end of the ribbon in the Home tab. You will see the image below: Now select the list of data you want to add. You will see the image below, and then press the Enter key to get the result.
Read moreHow to do subtraction in Excel
This is similar to the addition of only the sign with the minus sign “+”. Select the cell where you want the result to appear in this example as cell C6. Then type in cell = sign in, now choose first cell C3 then type – “sign then choose second cell C4. Now press enter
Read moreHow to calculate average in Excel
Select the cell to display the result e.g. Cell C9 in the image shown below. Now type “=” sign in the cell and type “average” then type the opening bracket. Now select the data, cell from C4 to C7 then press Enter key to get the result.
Read moreSigma calculate average in Excel
Select the cell to display the result. Click the small arrow next to the Sigma button in the Home tab, and left click the Average option. You will see the image below. Then press the Enter key to get the result.
Read moreExcel Fill Handle
The fill handle is a convenient Excel tool that is used to fill data with specific patterns. You can extend the desired number of cells, a range of dates and text combinations. To use the fill handle, move the mouse cursor to the right lower corner of the cell, this will turn into a prompt.
Read moreFill Handle with Text in Excel
Fill handle works in a similar way with texts. This helps the text to replicate the cells of the desired range. See the images shown below: The text is selected and then copied to other cells using the fill handle.
Read moreExcel Fill Handle with Text and Numbers
The Fill handle also works with both text and numbers. In this case, the text does not change but the number increases by one for each cell you select. View pictures:
Read more