Intermediate Microsoft Excel

Book now Back to search results

Introduction

This course seeks to improve proficiency with Microsoft Excel. It includes working with multiple worksheets, adding database capabilities, split screens and more Excel functions. It also takes charting a step further and introduces passwords to Excel.

Course code

SIEX

Location

Dumfries Campus

Price

£95.00

Availability

Location: Online
Teams Delivery (Copied for 11/11/2026 09:30:00) – 11 Nov 2026 09:30

Course Content

Key Topics

Creating, renaming and deleting worksheets
Navigating between worksheets
Using 3D formula
Using links in Excel
How to edit existing charts
Select and format chart elements
Using chart elements and options
Creating Sparklines
How to use IF function
How to use the VLOOKUP and HLOOKUP functions
How to name cells and use named cells
Sorting and filter tables
Introduction to data forms
Using database functions
Introduction to Pivot Table

Progression

Advanced Microsoft Excel | Dumfries and Galloway College

Course Contact Details

If you would like more information or to reserve a place on a course, please get in touch.

Telephone: 01387 734199
E-mail:shortcourses@dumgal.ac.uk

Booking Terms & Conditions | Dumfries & Galloway College (dumgal.ac.uk)

Other Courses at DGC

Introduction to Microsoft Excel

A woman working on reports on a laptop

This 1 day course aims to give the new Excel user all the basic skills that they need to be able to use Excel with confidence.Tips are included on using Excel quickly and efficiently, and you will learn how to layout spreadsheets and create charts....

Advanced Computing (NQ) @ SCQF Level 6

code on a laptop screen

This course will enable you to further your learning and knowledge of areas such as cyber security, web development, data science and programming and provides a good basis to progress onto more advanced HE study or to gain employment as a junior IT trainee.The qualification has the potential to prepare you for employment or further study...

Digital Leadership & Management

Dumfries and Galloway College Birds Eye View with criffel in the background

Digital tools are progressing at an unprecedented rate both in our personal and business lives, and it is easy to find ourselves behind the times and using dated methods that no longer achieve the best results. This is particularly true for managers and leaders, who need to adopt new processes and procedures from a technical aspect, but a...