Excel-Project

Back to Welcome Page

Excel-Project

Data Manipulation

• In the sheet ‘retail_sales_dataset’ add all available data between columns A – H into a ‘table’

• Using the ‘filter’ function, filter ‘Age’ to ‘largest to smallest’

• Using the ‘SUM’ function, show me the commission total in cell ‘P10’

• Using the ‘AVERAGE’ function, show me the average commission in cell ‘P11’

Data Visualision

• Objectives: create charts to visualise data in Microsoft Excel.

Part 1: Creating a Line chart

Part 2: Creating a Column Chart

Part 3: Creating a Pie Chart

• Background / scenario Data visuaulisation assists with the analysis and interpretation of data by graphically presenting relationships, trends, and inferences that cannot always be clearly derived examining the raw text and numeric values in a dataset.

Data Analysis

* Apply filter and sorting to show the best students in each subject.

* Calculate the average for all students and fill into Column E. (Use formula)

* Using the =MAX funtion, tell me what the students highest score was in column F.

• Apply filter and sorting to show the best student in this classroom by average.

• Apply filter and sorting to show the best student in this classroom by highest score.

* Use conditional formatting to clearly identify the highest and lowest average scores

Back to Welcome Page