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

Course code

SBEX

Location

Dumfries Campus

Duration

1 Day, Via MS Teams

Price

£75.00

Course Content

Key Topics

  • Excel Familiarisation
  • Understanding columns, rows and Excel navigation
  • Entering Text and Numbers
  • How to create formula (includes order of operation)
  • How to use autofill
  • Using relative and absolute addressing
  • How to format information in a spreadsheet
  • Using Auto Sum and aggregate functions
  • How to create charts
  • Chart editing and formatting
  • How to save workbooks
  • Create PDFs from Workbooks

Progression

INTERMEDIATE MS-EXCEL | Dumfries & Galloway College (dumgal.ac.uk)

ADVANCED MS-EXCEL | Dumfries & Galloway College (dumgal.ac.uk)

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: (hyperlink to the definitions)

  • 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

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 7

code on a laptop screen

Are you in S6 and considering a degree in Computing? Dumfries & Galloway College in partnership with University of West of Scotland is offering you the opportunity to start your degree programme whilst in school and get you on the pathway to your degree. This programme will help you prepare for university and start your learning on yo...

Cyber Security HNC @ SCQF Level 7

Computing and IT - cyber security

This course gives you the opportunity to develop knowledge and skills in areas such as data security and ethical hacking. This course is equivalent to the first year of degree study and we offer this course as a standalone HNC or as part of a three-year programme which will allow you to graduate with the University of West of Scotland Ba...