Kickstart into the World of Data: An Introduction to Data Analysis with Excel!
We will focus on techniques such as:
- Boosting your excel proficiency: Increasing your confidence and skill in using Excel for data focused tasks, making you more efficient and valuable in a data driven sector
- Analyse data:
1. Preparing and managing data e.g. removing duplicate entries
2. Using text to columns to separate characters
3. Lookup functions (VLOOKUP)
4. Calculating averages and central tendency
- Observe trends: Discover methods for summarising data and creating visualisations (charts and graphs) to identify patterns and trends.
1. PivotTables: creating basic PivotTables to summarise large data
Whether you need this skill for your course, preparing for an internship/placement, preparing for your career in the real world or simply just curious about the multiple functionalities of Excel. This workshop is the perfect starting point to build your data analysis toolkit by using Microsoft Excel. No prior expert knowledge is required – Just bring your readiness to learn and let’s start upskilling!
*You will have access to the created content (guides and worksheets) for you to keep and use whenever you need.
Associated Badges:
In A Nutshell...
- Learn... how to use Excel for powerful data analysis.
- Gain hands-on experience... in transforming raw data.
- Build... foundational skills employers value.
- Improve... your Excel proficiency with handling data.
- Discover... ways to analyse, summarise and visualize data.
- Launch... your journey into data analysis.
- Earn up to 10 Rise points ... which can be recognised within your degree.
Schedule
-
10:00 to 12:00 on 20/01/26 - GM 101
Kickstart into the World of Data: An Intro to Data Analysis with Excel! Moving beyond basic spreadsheets to using Microsoft Excel for insightful data analysis. In this kickstart to data workshop you will experience a hands-on session to gain foundational skills needed to transforming data into meaningful information.