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

£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

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

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.The qualification has the potential to prepare you for employment or further study...

Cyber Security NPA @ SCQF Level 5

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

If you want to have the opportunity to develop skills and knowledge for further study for entry into a career into the vast world of Cyber, then this is the course for you! This course provides you with the foundation knowledge and skills in Cyber Security. You will develop skills relevant to the use of Data Security, Digital Forensics an...