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

Introduction to E-Sports NPA @ SCQF Level 5

Computing and IT esports

E-sports 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 E-sports, with a v...

Read more

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

Read more

Cyber Security HND @ SCQF Level 8

Computing and IT - cyber security

This course is for students who have completed the 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 wil...

Read more