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
Virtual Delivery – 11 Nov 2025 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 E-Sports NPA @ SCQF Level 5

Computing and IT esports

Esports is one of the fastest growing professional sports in the world, with a projected forecast of a global worth of more than £4.6 billion by 2029. This course will give you an introduction into E-sports and advise you how you can progress within the computing industry which extends far beyond games development and Esports, with a var...

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...

Cyber Security HND @ SCQF Level 8

Computing and IT - cyber security

This course is for students who have completed HNC Cyber Security and who want to progress to a degree in a Computing discipline or into employment in computing-related disciplines. This course is equivalent to the second year of degree study, and we offer this course as a standalone HND or as part of a three-year programme which will al...