Advanced Microsoft Excel

Book now Back to search results

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

£95.00

Availability

Location: Online
Teams Delivery – 12 Jun 2024 09:30
Teams Delivery (Copied for 12/06/2024 14:30:00) – 12 Jun 2024 14:30
Teams Delivery – 24 Jun 2024 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

Advanced Computing (NQ) @ SCQF Level 6

code on a laptop screen

This course will enable you to further your learning and knowledge of areas such as cyber security, web development, data science and programming and provides a good basis to progress onto more advanced HE study or to gain employment as a junior IT trainee.With the addition of E-sports units, you will gain knowledge and understanding of p...

Intermediate Microsoft Excel

A woman working on reports on a laptop

This course seeks to improve proficiency with Microsoft Excel. It includes working with multiple worksheets, adding database capabilities, split screens and more Excel functions. It also takes charting a step further and introduces passwords to Excel....

UWS Computing Foundation Academy @ SCQF Level 6

code on a laptop screen

Are you moving into S5 and considering a degree in Cyber Computing? Would you love to undertake a degree but don’t have the qualifications? Dumfries & Galloway College in partnership with the University of West of Scotland is offering for you to start your degree programme whilst in school and get you on the pathway to your degree....