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

Digital Leadership & Management

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

Digital tools are progressing at an unprecedented rate both in our personal and business lives, and it is easy to find ourselves behind the times and using dated methods that no longer achieve the best results. This is particularly true for managers and leaders, who need to adopt new processes and procedures from a technical aspect, but a...

Introduction to E-Sports NPA @ SCQF Level 5

Computing and IT esports

E-sports is one of the fastest growing professional sports in the world, with a projected forecast of a global worth of more than £4.6 billion by 2029. This course will give you an introduction into E-sports and advise you how you can progress within the computing industry which extends far beyond games development and E-sports, with a v...

SVQ in Business & Administration @ SCQF Level 5

Business

This SVQ is designed for individuals who are currently employed in an administrative role such as receptionist, junior secretary or clerical assistant Upon successful completion, you will gain a recognised qualification which guarantees you have the skills, knowledge and abilities required to carry out your role competently....