Advanced Microsoft Excel

This course is currently closed for new learners. Register for our email alerts and we’ll let you know when this or similar courses become available.

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

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

Level 2 Certificate in Digital Marketing (TQUK)

This qualification aims to enhance learners' understanding of digital marketing. Upon successful completion, learners will gain insights into the fundamentals of digital marketing, its significance, and its role in driving business growth.Designed for individuals looking to expand their knowledge in digital marketing, this qualification i...

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...

This course is for students who have completed the HNC Cyber Security and who want to progress to a degree in a Computing discipline or into employment in computing-related disciplines. This course is equivalent to the second year of degree study, and we offer this course as a standalone HND or as part of a three-year programme which wil...