Advanced Microsoft Excel


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



Dumfries Campus


1 day, Via Microsoft Teams




Location: Online
Teams Delivery – 18 Mar 2024 09:30
Teams Delivery – 26 Mar 2024 09:30
Teams Delivery – 26 Mar 2024 09:30
Teams Delivery – 12 Jun 2024 04:30
Teams Delivery – 24 Jun 2024 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

Booking Terms & Conditions | Dumfries & Galloway College (

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 forecasts of a global worth of more than £1billion by 2023. 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 variety of comput...

Cyber Security HNC @ SCQF Level 7

Computing and IT - cyber security

This course gives you the opportunity to develop knowledge and skills in areas such as data security and ethical hacking. This course is equivalent to the first year of degree study and we offer this course as a standalone HNC or as part of a three-year programme which will allow you to graduate with the University of West of Scotland Ba...

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.With the addition of E-sports units, you will gain knowledge and understanding of p...