Choose a dataset of your interest ( either from Kaggle or the existing datasets offered in the
course material). Your dataset should not be similar to any of the previous assignments.
Create some research questions (goals)
Use at least 7 of the following topics to apply a good quality data analysis and knowledge
discovery task to the dataset.
Range Names, Lookup Functions, Index Function, Match Function, Using Pivot Tables and slicers
to describe data
The Data Model, Filtering data and removing duplicates, Array Formulas and Functions
Text Functions, Date and Time Functions, Time & time functions
Summarizing Data by Using Histograms and Pareto Charts,
Importing Data from a Text File or Document,
Validating Data Reading.
Read more here: Source link