In this module we focus on gathering the right data for analysis, and how you can use Excel to generate insights from this data.
- Develop a good working knowledge of the Excel functions that are most commonly used to analyse datasets
- Understand how to format Excel spreadsheets and ensure accurate presentation of analysis
- Be aware of the potential pitfalls associated with datasets, including risks from datasets which are based on small samples of data and/or from biased data samples
- Practise data analysis skills on Excel