Advanced Microsoft Excel

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 – 17 Jun 2025 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

Cyber Security NPA @ SCQF Level 5

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

If you want to have the opportunity to develop skills and knowledge for further study for entry into a career into the vast world of Cyber, then this is the course for you! This course provides you with the foundation knowledge and skills in Cyber Security. You will develop skills relevant to the use of Data Security, Digital Forensics an...

Takes the inexperienced user through all the basic concepts of handling a document. After which it introduces proofing tools, text formatting, and page formatting.This can be considered the Word essentials course as it both lays the foundations of unlocking all future skills whilst giving the attendee a good working knowledge...

With over 65 million internet users in the UK alone, and 4.48 billion social media users around the World, it is more important than ever to know how to stay safe online and protect children and young people online.This course is aimed at anyone looking to develop their knowledge, for personal or professional reasons, or employers, lookin...