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

IT Software Fundamentals


This IT Software course teaches you how to select appropriate types of software applications to present different types of information.- Learn how to input, organise and format data in different software applications to meet specific needs.- Understand how to produce information that is fit for purpose and how using a variety of layouts c...

Introduction to Microsoft Excel

A birds eye view of a person 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....

Introduction To Power BI Desktop


PowerBi - a business analytical service provided by Microsoft is a great tool that lets you visualise data and share insights. It is a collection of software services, apps and connectors that work together to turn data from different sources into interactive dashboards and reports.This 3 hour online course covers the essential skills in ...