1. Self Service Portal
  2. Client System Login
  3. Frameworks
Close Icon
  1. Self Service Portal
  2. Client System Login
  3. Frameworks

Excel Data Analysis - Part 2

Learn how to analyse your data in the best possible way

Note: For our contracted customers (CCS and CPFT only), there is no charge for attending this course, as it's already covered by our partner Service Level Agreement.

It is important that before you attend this training course you have completed the Excel Calculations course. If not, please register for it here Excel Calculations.

Excel Training Pre-requisites

Completed 1st

Completed 2nd
(in any order after the Fundamentals course)

Completed 3rd
(in any order after the Calculations course)

 ✓ Fundamentals ✓ Calculations
 ✓ Data Analytics - Part 1
 ✓ Tables
 ✓ Data Validation
 ✓ Pivot Tables, filter and sort
 ✓ Charts
 ✓ Data Formatting and Cleansing
 ✓ Dates and Times
 ✓ Data Analysis - Part 2 (max 4 delegates)
 ✓ Excel Macro Recording Fundamentals (on request - max 4 delegates

 

Who is it for?

According to Wikipedia, Data Analysis is defined as a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making. This course will help with that. You should be familiar with the subjects covered on the Microsoft Excel Calculations course. Also attending the Excel Data Analysis - Part 1 and the Excel Sort, Filter and Pivot Tables courses are also highly recommended, but not essential.

 

How long is the course?

2 hours

 

Objectives

By the end of the course you will be able to find answers to your data more easily.

 

Course Content

  • AGGREGATE: this returns an aggregate in a list or database, but has 19 functions as opposed to the 11 in the SUBTOTAL function. It allows you to apply functions such AVERAGE, SUM, COUNT, MAX, MIN, LARGE or SMALL and ignore errors or hidden rows.
  • VLOOKUP: looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order.
  • HLOOKUP: looks for a value in the top row of a table or array of values, and then returns a value in the same column from a row you specify.
  • MATCH: searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
  • INDEX: Returns a value or reference of the cell at the intersection of a particular row and column, in a given range. [Return the value of a specified cell or array of cells (Array form); or Return a reference to specified cells (Reference form)]
  • OFFSET: Returns a reference to a range that is a given number or rows and columns from a given reference.
  • How to use AutoCorrect or the Clipboard to insert a complex nested formula.
  • How to use Evaluate Formula to debug a formula by evaluating each part of the formula individually.

 

Training Dates

Kingfisher House, Huntingdon:

  • Dates to follow

Victoria House, Cambridge (CPFT employees only):

  • Wednesday 06 November 2019 - 13:30 to 15:30

Cavell Centre, Peterborough:

  • Dates are available on request

Healthy Living Centre, Peterborough:

  • Dates are available on request

 

If there are no suitable dates scheduled, please email the IT Training Team and we will endeavour to accommodate your request.

 

To book this course

NHS SBS staff - Email our Training Administration team
CPFT staff - Book via the Academy
CCS staff - Email our Training Administration team
Other organisations - Contact our IT Training team

 

 

If you are interested in other Microsoft courses, please select one of the topics below:

Access

Excel

Outlook

PowerPoint

Publisher

Word

Visio

Useful Pages

Share this page

Facebook icon Twitter icon Email icon

Print

Print icon