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

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

Other Courses at DGC

BS Business

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

Dumfries & Galloway College has partnered with the University of West of Scotland (UWS) to offer you the third year of the Business BA programme. In year one you will complete Business HNC, year two Business HND, and in year three in partnership with UWS. This degree will equip you with the skills and attitude to meet the challenges...

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

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