Spreadsheets, databases & statistics

Introduction to Excel

  • 2 half days

Learn how to use spreadsheets and manipulate spreadsheet data, build and revise formulae, sort and print data and much more using Microsoft Excel 2016. Familiarity of the Windows environment is recommended.


Introduction to Access

  • Full day

In this one day session delegates will find out about tables and table relationships in Access 2016, use forms and reports, Access Wizards and Query-By-Example to retrieve data. Familiarity with computing and the Windows environment required.


Introduction to NVivo

  • Half a day

Learn how to use this qualitative data analysis (QDA) computer software package. The software allows users to classify, sort and arrange thousands of pieces of information; examine complex relationships in the data; and combine subtle analysis with linking, shaping, searching and modeling.

Familiarity with computing and the Windows environment required.


Introduction to SPSS

  • 2 half days

SPSS is a statistical package particularly suited to social science and survey data. Delegates will learn about the variety of user interfaces, data and command files, graphical representation of data and the philosophy behind the package.

A familiarity of computing and statistical procedures required.


Excel: Introduction to Graphs & Charts

  • 1 half day

This session provides an introduction to creating and editing a range of Graph and Chart types using Excel 2016. Basic knowledge of Excel is advised.


Excel: Logic Calculations and Functions

  • 3 hours

Find out how to use logical operators within formulas and create single and multiple criteria calculations in Excel.


Excel: Pivot Tables

  • 3 hours

Find out how to use Pivot tables to extract, manipulate and analyse information in Excel 2016. This course will examine in detail the functions and features of Excel Pivot Tables.

* This course is one of several that replaces the Excel Datalists, Pivot Tables and more course. 


Excel: Working with Data

  • 3 hours

Excel 2016 is often used to store and analyse large data sets. This course will look at tools and techniques that enable and simplify the working with these data sets, both in performing calculations and in filtering the data.

* This course is one of several that replaces the Excel Datalists, Pivot Tables and more course. 


Visual Basic programming in Excel

  • 3 hours

This introduction to Visual Basic for Applications (VBA) programming in Excel aims to provide a brief introduction that will let you automate repetitive tasks in Excel, saving you time and improving accuracy.

This half day course is suited to anyone who needs to deal with data in Excel and is based on addressing real problems frequently faced by students.

A basic level of Excel knowledge (i.e. Introduction to Excel or Standard IT course) is essential.


 

Self-guided training

Introduction to Excel 2010 (Moodle)

This guide to Excel 2010 will take you through the basics of entering and editing data, performing calculations on data, using functions and creating charts. It will also demonstrate the importance of cell reference when performing calculations and using functions.