Share Description
In this course, you will learn :
- About data kinds, centre measures, and the fundamentals of mathematical notation before moving on to typical visual methods for quantitative data, spread measures, and the distinction between descriptive and inferential statistics.
- Learn the key steps of the data analysis process, as well as how to employ cell referencing and menu shortcuts.
- Data can be sorted and filtered, text and math functions used, columns split, and duplicates removed.
- Use aggregation and conditional functions to summarise data, as well as pivot tables and lookup functions.
- Create quantitative and categorical data visualisations, pie, bar, line, scatter, histogram, and boxplot charts, and professional presentations.
- Learn about business measurements used by analysts in marketing, sales, growth, engagement, and financial analysis, as well as how to calculate and analyse key performance indicators and develop plots to visualise metrics in Excel.
- Understand the principles of sales and financial forecasting models, then build forecasting models in Excel utilising advanced lookup and data validation tools (INDEX, MATCH, OFFSET).
Syllabus :
- Descriptive Statistics
- Spreadsheets: Getting Started
- Spreadsheets: Manipulate Data
- Spreadsheets: Analyze Data
- Spreadsheets: Visualize Data
- Metrics
- Excel Modelling
