Intermediate Microsoft Excel


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



Dumfries Campus




Location: Online
Teams Delivery – 22 Feb 2024 09:30
Teams Delivery – 22 Feb 2024 09:30
Teams Delivery – 27 Feb 2024 09:30
Teams Delivery (Copied for 27/02/2024 09:30:00) – 27 Feb 2024 09:30
Teams Delivery – 08 May 2024 09:30
Teams Delivery – 20 May 2024 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


ADVANCED MS-EXCEL | Dumfries & 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

Booking Terms & Conditions | Dumfries & Galloway College (

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

IT Software Fundamentals


This IT Software course teaches you how to select appropriate types of software applications to present different types of information.- Learn how to input, organise and format data in different software applications to meet specific needs.- Understand how to produce information that is fit for purpose and how using a variety of layouts c...

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