Intermediate Microsoft Excel

Book now Back to search results

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

£75.00

Availability

Location: Online
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

Progression

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

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

UWS Computing Foundation Academy @ SCQF Level 6

code on a laptop screen

Are you moving into S5 and considering a degree in Cyber Computing? Would you love to undertake a degree but don’t have the qualifications? Dumfries & Galloway College in partnership with the University of West of Scotland is offering for you to start your degree programme whilst in school and get you on the pathway to your degree....

Cyber Security HND @ SCQF Level 8

Computing and IT - cyber security

This course is for students who have completed HNC Cyber Security and who want to progress to a degree in a Computing discipline or into employment in computing-related disciplines. This course is equivalent to the second year of degree study, and we offer this course as a standalone HND or as part of a three-year programme which will al...