Excel 3: Data Analysis
Event Description
Course dates are in this 1-page PDF - new dates are added throughout the year - http://go.qub.ac.uk/trainingschedule
This advanced course looks at some of the data analysis tools and functions available in Excel and involves a range of practical exercises using different types of data. Participants will learn how to use a variety of what-if analysis tools that can be employed in data analysis and decision making, such as Data Tables, Scenarios, Goal Seek and Solver. In addition, the course will cover a wide range of useful functions, including text, logical, financial, lookup and date and time functions, which can be used to manipulate spreadsheet data. An introduction to the interface for creating PivotTable and PivotChart reports in Excel is also included.
Covid-19 restrictions
Due to Covid-19 restrictions face-to-face training will not be offered at this time. This course will take the following format:
- Course participants access a workbook and associated files here.
- Additional topic specific resources (see link below) can be accessed as required
Additional Resources
This collection of resources can be accessed via LinkedIn Learning, an online learning resource for staff. New users will need to complete the LinkedIn Learning sign up here.
Aims/Aimed at
Staff who wish to advance their knowledge of Excel or who are hoping to take the ICDL* Advanced module in Spreadsheets.
*Formerly known as ECDL.
Pre-requisites
As this is an advanced course, previous attendance at Excel 1 and 2 or significant experience of creating spreadsheets using Excel is recommended.
Booking Information
Currently self study
Course Contact Details
Name: IT Training and Assessment UnitTelephone: 6189
Email: itcourses@qub.ac.uk
New Course: No
Course Type(s): Spreadsheets - Continuing Professional Development
Staff Categories: All Staff
Keywords: Excel, Spreadsheets, data analysis, decision making, Data Tables, Scenarios, Goal Seeker, Solver, Functions, Advanced Functions, ECDL Advanced