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

£75.00

Availability

Location: Online
Teams Delivery – 10 Apr 2024 09:30
Teams Delivery – 22 Apr 2024 09:30

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

Progression

INTERMEDIATE MS-EXCEL | Dumfries & Galloway College (dumgal.ac.uk)

ADVANCED MS-EXCEL | Dumfries & Galloway College (dumgal.ac.uk)

Course Contact Details

If you would like more information or to reserve a place on a course, please get in touch.

Telephone: 01387 734199
E-mail:shortcourses@dumgal.ac.uk

Booking Terms & Conditions | Dumfries & Galloway College (dumgal.ac.uk)

Other Courses at DGC

Digital Marketing

This course is ideal for anyone who wants to understand the essentials of how to deliver an effective digital marketing campaign. Digital Marketing will be stripped back to its core; removing buzzwords and jargon, to ensure you leave with hands on knowledge that you can implenent in your business.By the end of the day you will be able to...

Advanced Microsoft Excel

A person works on excel on a laptop while looking at reports

This 1 day course takes the skills learned in to Excel and Intermediate Excel, and moves to look at some more advanced Excel tools. It is particularly suited to those who use Excel as a means of modelling data to find solutions to problems...

Using IT to Increase Productivity

A birds eye view of a person working on reports on a laptop

Learn how to choose the most appropriate IT tools and systems to use for specific tasks. - Understand the factors that can affect an IT task (such as legal guidelines and constraints)- Learn to demonstrate the use of specific IT tools and systems and review their work approach to specific tasks to work out how this could be improved in th...