Microsoft Excel - Intermediate

The Microsoft Intermediate course is aimed at users of Excel who wish to develop their skills in this application.

Microsoft Excel Pre-requisites

Delegates must have attended an Excel Introductory course, or have an equivalent working knowledge of Excel.

Equipment Requirements

Learners should have a working version of Microsoft Excel installed on their device. While most participants use Office 365, the course content is applicable to other versions, though some features may vary.

Before attending, please ensure Excel is installed and ready to use.

Objectives

On successful completion of the course, delegates will be able to produce effective graphs, working with Sorting and Filtering Data, apply conditional formatting, understand logical functions and additional functions including SUMIF(), SUMIFS(), COUNTIF(), COUNTIFS(), SUBTOTAL(), use the Pivot Table functionality within Excel.

Course Content

• Overview of introductory topics e.g. formulas/functions, absolute referencing
• Charting
• Outlining – Group and Ungroup Data
• Group Edit
• Conditional Formatting
• Understand logical functions IF, OR, and AND functions
• Using NESTED IF Functions IFERROR
• Database Management – Sorting and Filtering
• SUMIF()/COUNTIF()
• SUMIFS()/COUNTIFS()
• SUBTOTAL()
• Pivot Tables
• Slicer and Timeline