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





1 day, Via Microsoft Teams



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 (