Essential Excel For Business Statistics and Data Analytics

Applied Statistical Modelling For Business Cases With Excel

Created by: Minerva Singh
Bestselling Instructor & Data Scientist(Cambridge Uni)

What Will I Learn?

• Introduction to Excel and navigating around the interface
• Reading in external data (including data from webpages) into Excel
• Derive insights from the data via grouping and pivoting
• Describe your data (descriptive statistics, including identifying the best statistic)
• Data visualisation through charts
• Inferential statistics in Excel (including hypothesis testing)
• Regression modelling in Excel

Requirements

• Access to Microsoft Excel
• Interest in data processing and analysis
• Developing data visualisations in Excel
• Statistical modelling in Excel

Target audience

• Data analysts
• Business and management students
• Students and professionals seeking to use Excel for data tasks
• Those looking to use Excel for basic data visualisations
• Those looking to use Excel for basic statistical modelling