Excel: Working with Data Efficiently

The Excel courses I took were invaluable.
Laurent, BSc Anthropology

Our hugely popular IT Practical workshops in Excel will resume on 14 October 2019 and will only run during Michaelmas and Lent terms. If you wish to be kept informed of when they are available to book please sign up to our newsletter.

All classroom-based sessions are based on Microsoft Office 2016.

Calculations and Formulas

Excel 1: Calculated Worksheets (Workshop)

Prerequisites: none

This workshop will run during Michaelmas and Lent Terms only.

This workshop is ideal for those who are self-taught or new to Excel as it incorporates good practice principles. It is also useful for anyone who needs to be able to design and create a budget.

By the end of this session you will understand how to:

  • Create and copy formulas
  • Format numbers and text
  • Set a print range for large spreadsheet 

Check availability and book a place

Excel 2: Numeric Calculations (Workshop)

Prerequisites: Excel 1: Calculated Worksheets  

This workshop will run during Michaelmas and Lent Terms only.

This workshop builds upon the skills taught in the Calculated Worksheets workshop and covers skills that are fundamental to the accurate use of Excel in all contexts and industries.

By the end of this session you will understand how to:

  • write accurate and efficient formulas
  • calculate totals and percentage
  • complete large tables of calculated data

Check availability and book a place 

Excel 3: Essential Functions (Workshop)

Prerequisites: Excel 2: Numeric Calculations

This workshop will run during Michaelmas and Lent Terms only.

This workshop is ideal for anyone who needs to use Excel functions to do a number of calculations, such as quickly adding up columns of numbers and calculating averages. The session also contains additional formatting, calculation and troubleshooting techniques.

By the end of this session you will understand how to:

  • find the maximum and minimum value in a range
  • perform basic logical tests
  • understand how to fix errors
  • use automatic formatting
  • use statistical functions 

Check availability and book a place 

Excel 4a: Lookup Functions (Workshop)

Prerequisites: Excel 3: Essential Functions 

This workshop will run during Michaelmas and Lent Terms only.

This workshop is ideal for anyone who uses Excel as a tool for interrogating data tables or performing advanced calculations based on logical queries, particularly in numeric disciplines. 

By the end of this session, you understand how to:

  • use Excel logic and lookup functions to display text, perform calculations, or retrieve information
  • query information held elsewhere in the spreadsheet

Check availability and book a place

Excel 5: Complex Calculations (Workshop)

Prerequisites: Excel 4a: Lookup Functions

This workshop will run during Michaelmas and Lent Terms only.

This advanced application of Excel's calculation, logical and lookup functionality provides a solid basis for expanding your use of Excel's many advanced and specialist functions and is valued in any industry that uses Excel.

By the end of this session, you will be able to:

  • construct complex functions in Excel, utilising a number of different calculations and in-built functions, to complete complex tables of information accurately and efficiently. 

Check availability and book a place 

Visualising Data

Excel 4d: Charting Data (Workshop)

Prerequisites: Excel 2: Numeric Calculations 

This workshop will run during Michaelmas and Lent Terms only.

This workshop is ideal for anyone who needs to present data in chart form and assumes a basic understanding of how to create and format a simple chart. 

By the end of this session, you will be able to:

  • use Excel to create a number of different charts
  • use charts to compare different sets of data and predicting trends
  • represent percentages in chart form
  • display stock figures or confidence intervals

Check availability and book a place 

Working with large datasets

Excel 4c: Sorting and Filtering (Workshop)

Prerequisites: Excel 3: Essential Functions 

This workshop will run during Michaelmas and Lent Terms only.

This workshop is ideal for anyone who needs to quickly organise large amounts of data.

By the end of this session you will understand how to:

  • perform complex sorts
  • apply filters to retrieve a subset of information.
  • perform a basic summary calculation of information
  • set up worksheets for the repeated application of complex filters.

Check availability and book a place 

Excel 4b: Pivot Tables (Workshop)

Prerequisites: Excel 3: Essential Functions 

This workshop will run during Michaelmas and Lent Terms only.

This workshop is ideal for anyone who needs to quickly summarise large amounts of data and present it in an easily understandable format.  

By the end of this session you will understand how to:

  • summarise large amounts of data using Pivot Tables
  • present the information in a number of ways using formatting, charting, and calculation options 

Check availability and book a place

Automation with Macros

Excel 6: Using Macros (Workshop)

Prerequisites: Excel 4c: Sorting and Filtering

This workshop will run during Michaelmas and Lent Terms only.

This workshops and builds on all of the skills from the previous sessions.

By the end of this session you will understand how to:

  • record a complex macro in Excel
  • use VBA to edit a macro in Excel
  • use VBA to combine multiple macros

Check availability and book a place

 

 

I can definitely say that the IT training sessions have made me far more confident about using Excel, from discussing the applications of Excel in interviews to developing a personal skill that complements my academics very well.

- Daniel, BSc Economics