Week 4: May 12-16

Data Handing

By the end of the lesson, learners should be able to:

• Open and edit a saved excel sheet
• • Sort and filter data.
• Work with charts (Edit and format).
• Change charts type and format.

Classwork Activity-MS. Excel 2016

To insert a chart:

• Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart. In our example, we'll select cells A1:F6.

Insert tab, click the desired Chart command. In our, we'll select Column.

• Choose the desired chart type from the drop-down menu.
• The Selected chart will be inserted into the worksheet