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

£135.00

Availability

Location: Online
Teams Delivery – 19 Nov 2024 09:00
Teams Delivery – 17 Feb 2025 09: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.

Additional funding information

No One Left Behind Training Allowance
Dumfries and Galloway Local Employability partnership (Funded by the Scottish Government) are proud to be working in partnership with DG College to offer eligible individuals funding to learn new, work-related skills and training.

You can use the money to build the skills you need for a job or get some training to take your career to the next level.

And because it’s not a loan, you don’t have to pay it back.

Check if you are eligible then follow the registration process.

Are you eligible?

You must meet all of the following criteria

  • 16 years of age or older
  • Resident in Dumfries and Galloway
  • Have the right to work and live in the UK.
  • Unemployed and looking to get back into work OR in employment and claiming an income-based benefit (i.e Universal Credit)

AND at least one of the following characteristics:

  • Parents with a child under the age of 19 (still registered in full time education)
  • Armed Forces Veteran
  • Asylum Seeker
  • Care Experienced
  • Caring responsibilities
  • Childcare needs
  • Criminal Convictions
  • Homeless or affected by housing inclusion.
  • Long Term health condition/ illness
  • No Limited work experience.
  • Refugee
  • Substance related conditions
  • Lack of Transport

If you meet the criteria, you could receive the full cost of your course fee.

Apply for your No One Left Behind Grant

To access support with the fees you must register with DG Works. Just follow the link or use the QR code. If you are already registered, please contact your Employment Key Worker for next steps.

Once you have completed the registration form and your eligibility has been checked someone from DG Works (part of Dumfries and Galloway Council) will contact you to ask you to provide the following evidence:

  • Reside in Scotland (e.g. evidence address)
  • Working Age (e.g. birth certificate)
  • Right to Live & Work in the UK (e.g. evidence of benefits)

https://forms.office.com/e/Qp2EB3McZB

If you have any questions please contact 01387 260035 or email DGEmployability@dumgal.gov.uk

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

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

Introduction To Power BI Desktop

INTRODUCTION TO POWER BI DESKTOP - Computing & IT

Training in this course covers the essential skills in Power BI: Extracting; Transforming and Loading Data into the Data Model and then Visualising it with a rich sets of Graphics; Charts and Dashboards. These can then be shared with colleagues or others with the Power BI service, and in many other ways....