Intermediate Microsoft Excel

Book now Back to search results
A birds eye view of a person working on reports on a laptop

Introduction

This course seeks to improve proficiency with Microsoft Excel. It includes working with multiple worksheets, adding database capabilities, split screens and more Excel functions. It also takes charting a step further and introduces passwords to Excel.

Course code

SIEX

Location

Dumfries Campus

Price

£95.00

Availability

Location: Online
Virtual Delivery – 11 Nov 2025 09:30

Course Content

Key Topics

  • Creating, renaming and deleting worksheets
  • Navigating between worksheets
  • Using 3D formula
  • Using links in Excel
  • How to edit existing charts
  • Select and format chart elements
  • Using chart elements and options
  • Creating Sparklines
  • How to use IF function
  • How to use the VLOOKUP and HLOOKUP functions
  • How to name cells and use named cells
  • Sorting and filter tables
  • Introduction to data forms
  • Using database functions
  • Introduction to Pivot Table

Progression

Advanced Microsoft Excel | Dumfries and Galloway College

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

Cyber Security HNC @ SCQF Level 7

Computing and IT - cyber security

This course gives you the opportunity to develop knowledge and skills in areas such as data security and ethical hacking. This course is equivalent to the first year of degree study and we offer this course as a standalone HNC or as part of a three-year programme which will allow you to graduate with the University of West of Scotland B...

Read more

Introduction to Microsoft Word

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

Takes the inexperienced user through all the basic concepts of handling a document. After which it introduces proofing tools, text formatting, and page formatting.This can be considered the Word essentials course as it both lays the foundations of unlocking all future skills whilst giving the attendee a good working knowledge...

Read more

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

Read more