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

Course code

SBEX

Location:

Dumfries

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

Course Contact Details

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