Advanced Microsoft Excel

Book now Back to search results
A person using a laptop. On the screen are reports. On the desk a cup of coffee

Introduction

This 1 day course takes the skills learned in Introduction to Excel and Intermediate Excel, and moves to look at some more advanced Excel tools. It is particularly suited to those who use Excel as a means of modelling data to find solutions to problems

Course code

SAEX

Location

Dumfries Campus

Duration

1 day, Via Microsoft Teams

Price

£115.00

Availability

Location: Online
Teams Delivery (Copied for 13/05/2026 09:30:00) – 13 May 2026 09:30

Course Content

Key Topics

  • How to use scenarios
  • How to use the solver tool
  • Using spreadsheet auditing facilities
  • Creating conditional formats
  • Using data validation
  • Using the data analysis tools
  • Saving Excel templates
  • Introduction to creating and running macros.

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

Level 2 Certificate in Digital Marketing (TQUK)

This qualification aims to enhance learners' understanding of digital marketing. Upon successful completion, learners will gain insights into the fundamentals of digital marketing, its significance, and its role in driving business growth.Designed for individuals looking to expand their knowledge in digital marketing, this qualification i...

Read more

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

Read more

Cyber Security NPA @ SCQF Level 5

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

If you want to have the opportunity to develop skills and knowledge for further study for entry into a career into the vast world of Cyber, then this is the course for you! This course provides you with the foundation knowledge and skills in Cyber Security. You will develop skills relevant to the use of Data Security, Digital Forensics an...

Read more