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.

Register for email alerts Back to search results
A person using a laptop. On the screen are reports. On the desk a cup of coffee

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

MEng/BEng (HONS) Cyber Security

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

BEng Cyber Security will teach you how to protect and secure modern data infrastructure. The course will allow you to develop many industry relevant skills based around the ethical hacking framework underpinned by a thorough understanding of both networking and programming theory. As the country’s security and prosperity rests on digita...

Read more

Introduction to Microsoft Excel

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

Read more

Introduction to Microsoft Word

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

Read more