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 25/11/2026 09:30:00) – 25 Nov 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

BS Business

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

Dumfries & Galloway College has partnered with the University of West of Scotland (UWS) to offer you the third year of the Business BA programme. In year one you will complete Business HNC, year two Business HND, and in year three in partnership with UWS. This degree will equip you with the skills and attitude to meet the challenges...

Read more