EXCEL INTERMEDIATE

Microsoft Excel offers powerful tools for organising and analysing larger sets of business data. This practical Excel Intermediate course is designed for existing Excel users who want to work more effectively with lists, reports and data analysis.

You’ll learn how to manage worksheets, create and customise tables, sort and filter information, work with named ranges and apply data validation and conditional formatting. The course also introduces more advanced functions and shows you how PivotTables can quickly summarise and analyse information.

Practical examples help you apply these techniques to financial, sales, budget and statistical data, giving you more control over the information you work with and helping you produce clearer, more useful reports.

1 Day Course

DEVELOP YOUR SKILLS

ACHIEVE YOUR GOALS

EXPAND YOUR HORIZONS

BOOK A COURSE

COURSE OBJECTIVES

By the end of the course, you’ll be able to organise and manipulate Excel data more efficiently, use sorting and filtering tools, manage worksheets and named ranges, and apply validation and conditional formatting.

You’ll also be able to create PivotTables to summarise and analyse information, work with subtotals and use functions such as VLOOKUP, IF and text functions to support more detailed data analysis.

COURSE CONTENT

Managing Excel Lists

Follow Excel data list principles, use the built-in Data Form, and create and customise tables.

Worksheet Management

Insert, move, name, hide and delete worksheets, copy sheets between workbooks, freeze rows and columns, and arrange workbook windows.

Hyperlinks & Navigation

Create hyperlinks and attach links to buttons, images and text to make workbook navigation easier.

Print Options

Set print titles and options, and work with headers, footers and page breaks.

Named Ranges

Create, define and edit named ranges to make worksheet information easier to reference and manage.

Sorting & Filtering

Perform single and multilevel sorts, use AutoFilter and custom filters, and work with advanced filters and database functions.

Subtotals & Outlines

Apply single and multiple subtotals, use SUBTOTAL function options, and organise information using grouping and outlining.

Data Validation

Apply validation criteria, restrict the types of data that can be entered and use validation lists to support accurate data entry.

Conditional Formatting

Apply and edit conditional formatting to highlight important information and patterns within your data.

PivotTables

Create and modify PivotTables, arrange rows and columns, apply filters, summarise data, display totals and drill down into underlying information.

Beyond Basic Functions

Work with VLOOKUP and IF, together with text functions such as LEFT and CONCATENATE.

Advanced Data Analysis

Use advanced filters and database functions including DSUM, DCOUNT and DAVERAGE to analyse information more effectively.

PRACTICAL LEARNING

Throughout the course, you’ll work with Excel data and apply the techniques to practical business situations. Exercises focus on organising, filtering and analysing information, creating reports and using PivotTables to turn larger sets of data into useful summaries.

This is particularly relevant for people who regularly work with sales, budgets, financial or statistical information.

BOOK A COURSE