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

AN INTRODUCTION TO CYBER SECURITY

This course provides learners with a baseline understanding of common cyber security threats, vulnerabilities, and risks. It’s an overview of the main information security risks and how to mitigate them. The course is focused on the needs of small organisations.Aimed at anyone who is interested in security, decuring data or information....

Esports 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 Esports, with a var...

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

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