Brush- up

Practice 11 different tasks and compare your results with the given solution. These tasks cover most common features of Excel. Download the file and run it..

Snacks

Create a Pivot Table

TMA Data Processing

1. Filter data (download file on the right) for stations in Africa

2. Sort these stations according to their location from north to south.

3. Create charts for these stations of yearly rainfall (bars) and temperature.

4. Integrate these north-south profiles for rainfall and temperatur into a word document.

5. Write a step by step instruction on how to produce these profiles.

6. Send this word document to your tutor.

TMA Data Processing

1. Load sales data for stationary

2. Apply data analysing features to this data set.

3. Create a Word document showing and formulating conclusions and the respective tables created in Excel

4. Send this document to your tutor.