Excel: Working with Data Efficiently

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

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 

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 

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

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 

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 

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 

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

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