Introduction to MS-Excel (YPG)

Introduction

This 1 day course is a fully funded through YPG and is aimed at those between 16 and 24 years old that are not currently in employment.

The 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 how to layout spreadsheets and create charts.

DATES: 22nd June, 0930 - 1630

Course code

SBEY

Location:

Dumfries

Duration

1 Day, Via MS Teams

Price

£TBA

Additional Entry Requirements

None

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

Assessments

No formal assessment

Additional funding information

Fully funded through Young Person Guarantee for those between 16 - 24 years old that are not currently in employment.  College students and school pupils are eligible to apply.

Course Contact Details

Telephone:(01387) 734 199
E-mail: shortcourses@dumgal.ac.uk