Data Analytics Workshop
Excel knowledge is important across various industries and professions. It empowers individuals to efficiently manage and analyse data, make informed decisions, and improve productivity in their work/studies.
There is a 30 minute break at 16:30, lunch vouchers will be provided.
Aimed at
All levels and all programsAims & Objectives
This Excel workshop is delivered to improve the Excel Skills of students and staff.
The objective of this workshop is to improve attendee’s data analytical skills which will be useful for their final year project. The workshop will also aim at improving attendee’s employability skills.
Learning Outcomes:
1. Design and structure appropriate spreadsheets to meet needs
2. Use spreadsheet software to record, format and organise data
3. Use relevant tools to manipulate and analyse data
4. Use software tools to verify accuracy and protect data
5. Use tools and techniques to prepare and report information
Topics Covered:
· Working with multiple worksheets
· Data entry
· Column and row adjustment
· Use of relevant, absolute and mixed references in the formula
· SUM, Average, Min, Max, COUNT, COUNTA, ROUND and IF
· Inserting Comments
· Freezing
No dates available
There are no dates currently scheduled for this workshop.
This workshop is provided by
Professional Life project Digital Records Manager