Back to all courses

Microsoft Excel Introduction

The aim of the course is to enable you to understand the Excel environment and the popular tools used to create data in Worksheets.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Study Mode:

  • Other part-time day programme

Location:

  • Other

Start Date:

Duration:

  • One-day trainer led or virtual

Who is this course for?

This course would benefit all levels of staff within an organisation who have limited experience, capability or confidence using Microsoft Excel.

What qualifications will I gain?

Fife College Certificate of Attendance

What will I learn on the course?

Getting started with Excel

  • Exploring the interface
  • Create and save a new workbook
  • Open Files
  • Add basic data
  • Printing

Edit a workbook

  • Select cells and ranges
  • Edit cells
  • Cut, copy and paste
  • Undo, redo, repeat
  • Find and replace text
  • Hide columns and rows

Basic formulas

  • Formula basics
  • Absolute vs relative cell addressing
  • AutoFill series
  • SUM and AVERAGE
  • MIN, MAX and COUNT

Basic formatting

  • Format text
  • Align and merge cells
  • Format numbers and dates
  • Borders and background colours
  • Format painter
  • Row heights
  • Column widths

Manage worksheets

  • View worksheets
  • Move or copy worksheets
  • Insert, rename and delete worksheets
  • Freeze rows/columns

Application Information

What further course options are available?

  • Microsoft Excel - Intermediate 

How will this help my career?

This course enhances your proficiency within Microsoft Excel which you can take back into your workplace activities to improve productivity.

Related courses

View all courses