No Fear Data training
The one-day essential introduction to data analysis
For £200 + VAT, this day-long online course is designed for people who want to gain confidence using spreadsheets and datasets from the beginning. It teaches the basics of spreadsheets and data handling. By the end of the course, trainees will be able to take any basic dataset, analyse it, and start telling stories about the data with confidence.
Next session: Tuesday 10th December 2024
Course contents
Understanding data
- Understand basic terminology: “data table”, “dataset”, “database”, “CSV”
- See the different forms that data can take, including: curated tables, pure csv files, online portals, downloadable databases
- Understand basic data structure
- Understand the principles of data modelling and table joining
- Identify the difference between good and bad data structures and understand why data is more versatile when structured well
Mastering tables
- Understand the different kinds of data in tables: absolute, relative and calculated values; numerical, string and boolean data
- Understand the difference between cell contents and cell formatting
- Learn the basic syntax of a spreadsheet formula
- Learn SUM, COUNT(A), AVERAGE, MIN, MAX
- Understand percentages and how to calculate percentage changes between
- Learn how to drag-apply formulas, anchor fixed values, and keyboard shortcuts
Handling datasets
- Learn how to manipulate whole worksheets of data
- Learn how to navigate large datasets quickly using keyboard shortcuts and search functions
- Learn how to get quick summary answers out of datasets
Pivot tables
- Understand what pivot tables are and the function they serve in allowing large datasets to be summarised and analysed flexibly.
- Understand the requirements on data structure in order to make pivot tables possible and how to make structural corrections if necessary
- Learn how to create pivot tables, making use of the VALUE, ROW, COLUMN and FILTER fields
- Learn how to extract meaningful answers out of pivot tables and to use the built-in functions to assess the depth and reliability of those answers
- Learn how to make simple changes to a dataset to empower more analysis
Enquire now for more information
Want a programme like this tailored to your team? Contact our Customer Relationship Manager Mo Koppel on maurice.koppel@fullfact.org to find out more about our bespoke training offer.