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. 


Excel: Lookup Functions

  • 3 hours

Lookup calculations are very commonly used within Excel.  They allow you to search for and find values within tables that match certain criteria.  This course will introduce you to some traditional lookup functions, but more importantly the brand new and massively more powerful XLOOKUP function. 

To use this functon you will have an up to date and updated version of Office 365 on your computer, We are currently waiting for updates to Excel that will include this function.  Until then you are invited to note your interest in the course.  When course dates become available you will be contacted.

Whilst not mandatory, we do recommend very strongly that you attend our Excel: Working with Data course prior to attending In particular you will be using Tables and Structured References throughout this course.  An understanding of the basic of using spreadsheets is also required.


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.