Excel 3: Data Analysis

Loading Events

« All Events

  • This event has passed.
Event Series Event Series: Excel

Excel 3: Data Analysis

19 October, 2023 @ 9:30 am - 10:30 am

MS Excel logo

This advanced course looks at some of the data analysis tools and functions available in Excel 2010 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 2010 is also included.

Aimed at: Staff who wish to advance their knowledge of Excel or who are hoping to take the ECDL Advanced module in Spreadsheets.

Prerequisites: As this is an advanced course, previous attendance at Excel 1 and 2 or significant experience of creating spreadsheets using Excel 2007 or 2010 is recommended.

 

Access on iTrent

Details

Date:
19 October, 2023
Time:
9:30 am - 10:30 am
Series:
Event Categories:
,
Website:
https://hrwebapp.qub.ac.uk/tlive_ess/ess/dist/#/main/learning/courses/activity/76802500H4

Other

Time
Morning
Level
Basic