WEEK7: SPREAD SHEET SKILLS : MS EXCELL BASIC

Create a new workbook

Enter your data

Use AutoSum to add your data

AutoSum adds up the numbers and shows the result in the cell you selected.

Create a simple formula

For example, enter =2+4, =4-2, =2*4, or =4/2.

3. Press Enter. That runs the calculation.

You can also press Ctrl+Enter if you want the cursor to stay on the active cell.

Apply a number format

Pick a number format.

 

 

Put your data in a table

Now we can play with your data: Filter to see only the data you want, or sort it to go from, say, largest to smallest. Click the arrow in the table header of a column.To filter data, uncheck the Select All box to clear all check marks, and then check the boxes of the data you want to show in your table.

To sort the data, click Sort A to Z or Sort Z to A.

Show totals for your numbers

Add meaning to your data

For example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures.

Show your data in a chart

 

Note Excel shows different charts in this gallery, depending on what’s recommended for your data.

Save your work

Click the Save button on the Quick Access Toolbar, or press Ctrl+S.