PART 3: EXCEL DATA ANALYSIS BASICS

So, you have a dataset in spreadsheet – now how to understand it?  Part 3 of Excel Basics is concerned with perhaps the most common usage of Excel: analysing data!

How to do it?  Data analysis is often misunderstood as a topic (perhaps it brings back bad memories of maths lessons at school – I have a few of them!) so, in part 2, we begin with basic topics and concepts in data analysis.  Understanding the type of data you are analysing, for example, is important – or you may end up applying the wrong technique in Excel.

In the 6 sessions, we undertake a detailed numerical and visual analysis of a simulated dataset, applying a range of techniques in Excel including powerful data analysis formulae (look out for DSUM!) and charts.  Make sure you download the Excel download file and work along with Chris to ensure you develop these critical Excel skills.  Let’s go!

Session Titles And Learning Outcomes

SESSION 1: Foundational Skills And Concepts In Data Analysis
  • understand the steps of a data analysis
  • understand difference between qualitative and quantitative data
  • understand difference between discrete and continuous data
  • create a COUNTA formula
  • create MAX and MIN formulae
  • understand the concept of dispersion in numerical data
  • create a STDEV formula
  • understand the difference between mean and median averages
  • create MEAN and MEDIAN formulae
SESSION 2: Apply Frequency And Create A Column Chart
  • create a FREQUENCY formula
  • visualise data distribution with a column chart
SESSION 3: Sort And Filter Data In Excel
  • sort data
  • do a multi-level sort
  • filter data
  • build a SUBTOTAL formula
SESSION 4: Single Criteria Analysis In Excel
  • use the UNIQUE formula
  • create a SUMIF formula
  • create a AVERAGEIF formula
  • create a partial absolute reference
SESSION 5: Multiple Criteria Analysis In Excel
  • create a SUMIFS formula
  • create a AVERAGEIFS formula
  • create a chart with multiple series
SESSION 6: Powerful Data Analysis Formulae
  • create a DSUM / DAVERAGE / COUNT formula

8 Lessons