MS Excel (Intermediate)

Overview

This one-day MS Excel (Intermediate) course builds on foundational spreadsheet skills, enabling learners to work more efficiently with data and create professional, visually appealing outputs. Delegates will develop practical abilities in managing tables, sorting and filtering data, applying text functions, creating links between worksheets and workbooks, working with subtotals, and protecting spreadsheets.

Participants will also learn to create and customise charts, manage worksheet display options, and work with graphics to enhance presentations. The course is delivered through interactive, facilitator-led sessions, ensuring learners gain the skills and confidence to handle intermediate-level Excel tasks in a workplace setting.

Objectives

• Apply data selection techniques for efficiency
• Create and work with Excel tables.
• Sort and filter data effectively, including advanced options.
• Use text functions to manipulate and format data.
• Create and manage links between worksheets and workbooks.
• Apply subtotals and outline worksheets.
• Protect worksheets and workbooks to control access and editing.
• Create and customise professional charts.
• Use graphics and visual elements to enhance spreadsheets.

Delivery Methods

Facilitated by a competent and experienced subject matter trainer using practical, experiential techniques such as questions, discussions, demonstrations, exercises, and assessments.

Who should attend?

This course is ideal for individuals who already have basic Excel skills and wish to advance to more complex spreadsheet functionality, including:

• Office Administrators and Assistants
• Data Capturers and Clerks
• Staff involved in reporting and data analysis
• Employees creating professional business reports

Includes:

• Comprehensive Manual
• Lunch and Refreshments (not applicable to on-site / online training)
• Electronic Certificate (on successful completion of the course)
• Electronic Delegate Feedback Questionnaire