Excel Level 2 online courses comprise of live, online moderated workshops using web conferencing software, e.g., Microsoft Teams or Zoom, Excel, and blended with self-directed study assignments after the training.

There is access to live, online tutor support throughout the course, and email support afterwards. Pick from any of the 90-minute sessions.

We deliver Microsoft Excel online training for both Windows and Mac users.

## Which online training session is right for you?

Choose from the three sessions summarised below or download the PDF outline at the bottom of the page.

If most of a team is reasonably proficient, they’re maybe just a few areas that need updating. A bespoke programme means tailored sessions matching current skill levels and work needs. You can choose from Excel Level 1, Excel Level 3, and Excel Level 4.

## Microsoft Excel Level 2 – Conditional functions

### Who should attend?

Any Excel user who needs to create and use more than a simple sum.

### Training Requirements

Participants must be using Excel and able to create simple formulae and use absolute cell references, e.g., \$C\$4.

### Aim

By the end of the session, you will be able to use a variety of functions to analyse your data depending on specific criteria, e.g., sum a range of total figures where the data in a country column is equal to “Australia.”

### What you will learn

• Understand when to use partial absolute referencing in formulas, e.g., \$B4 or B\$4
• Create an IF() statement to test for a condition and return one of two answers
• Use a nested IF() to test for multiple conditions and return multiple answers
• Combine AND() and OR() statements with an IF() to test for two or more conditions
• Build SUMIF() and COUNTIF() functions to total or count figures based on one set of criteria
• Total, average or count figures using the SUMIFS(), COUNTIFS() or AVERAGEIFS() functions based on multiple criteria

## Microsoft Excel Level 2 – Working with worksheets and files

### Who should attend?

This course is for everyone who uses Excel and needs to manipulate multiple worksheets or workbooks.

### Training Requirements

Participants must be confident users of Excel and able to create simple formulae and use absolute cell references, e.g., \$C\$4.

### Aim

By the end of the session, you will be familiar with a variety of worksheet options, e.g., consolidating data from more than one worksheet.

### What you will learn

• Quickly insert, delete, hide, move and copy worksheets
• Select multiple worksheets (group) to make quick changes on all worksheets
• Create formulas between more than one worksheet, e.g., summing across more than one worksheet
• Formulas between more than one workbook and edit the links
• Data consolidation

## Microsoft Excel Level 2 – Tables and Pivot tables

### Who should attend?

Anyone who uses Excel and needs to sort, filter, and summarise data for reports using Pivot tables.

### Training Requirements

Participants must be using Excel and able to create simple formulae and use absolute cell references, e.g., \$C\$4.

### Aim

By the end of the session, you will be familiar with formatted table options, e.g., structured references, and be able to build a basic Pivot Table report.

### What you will learn

• Preparation of data – Format as a Table option
• Using structured references to create calculations in a table
• Working with the Total row, e.g., creation of differing subtotals
• Applying slicers to a Table and a Pivot Table
• Create a Pivot Table by adding filters, columns, rows, and values

### Excel online level 2 sessions

1 file(s) 121.03 KB