Introduction to Microsoft Excel

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

£85.00

Availability

Location: Online
Virtual Delivery (Copied for 28/10/2026 09:30:00) – 28 Oct 2026 09:30

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

Other Courses at DGC

Level 2 Certificate in Principles of Business Administration (TQUK)

A smiling woman in work clothes holding a tablet

This qualification provides the foundational knowledge needed to excel in various business administration roles. You’ll gain key insights into performing essential administrative tasks, such as managing information and supporting events. Additionally, you'll learn how to apply this knowledge across different industries and job roles.Lea...

SVQ in Business & Administration @ SCQF Level 5

Business

This SVQ is designed for individuals who are currently employed in an administrative role such as receptionist, junior secretary or clerical assistant Upon successful completion, you will gain a recognised qualification which guarantees you have the skills, knowledge and abilities required to carry out your role competently....

Advanced Microsoft Excel

A person using a laptop. On the screen are reports. On the desk a cup of coffee

This 1 day course takes the skills learned in 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...