Intermediate Microsoft Excel

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 – 27 Jun 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)

Additional funding information

No One Left Behind Training Allowance
Dumfries and Galloway Local Employability partnership (Funded by the Scottish Government) are proud to be working in partnership with DG College to offer eligible individuals funding to learn new, work-related skills and training.

You can use the money to build the skills you need for a job or get some training to take your career to the next level.

And because it’s not a loan, you don’t have to pay it back.

Check if you are eligible then follow the registration process.

Are you eligible?

You must meet all of the following criteria

16 years of age or older
Resident in Dumfries and Galloway
Have the right to work and live in the UK.
Unemployed and looking to get back into work OR in employment and claiming an income-based benefit (i.e Universal Credit)

AND at least one of the following characteristics: (hyperlink to the definitions)

Parents with a child under the age of 19 (still registered in full time education)
Armed Forces Veteran
Asylum Seeker
Care Experienced
Caring responsibilities
Childcare needs
Criminal Convictions
Homeless or affected by housing inclusion.
Long Term health condition/ illness
No Limited work experience.
Refugee
Substance related conditions
Lack of Transport

If you meet the criteria, you could receive the full cost of your course fee.

Apply for your No One Left Behind Grant

To access support with the fees you must register with DG Works. Just follow the link or use the QR code. If you are already registered, please contact your Employment Key Worker for next steps.

Once you have completed the registration form and your eligibility has been checked someone from DG Works (part of Dumfries and Galloway Council) will contact you to ask you to provide the following evidence: