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

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

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

SVQ in Business & Administration @ SCQF Level 8

Business

This SVQ is designed for experienced professionals working in business administration roles who are actively involved in decision-making responsibilities. Ideal for those looking to advance their career.Upon successful completion, you will gain a recognised qualification which guarantees you have the skills, knowledge and abilities requir...

SVQ in Team Leading @ SCQF Level 6

Business

This SVQ is suitable for: Individuals who are currently in employment in a Supervisory or Team Leading role. Individuals who register for this SVQ are able to take advantage of 12 months of free studying membership with the Chartered Management Intitute (CMI).As the SVQ is a competency-based qualification, the following applies: You will...