Skip to main content
2aspire Lincolnshire Adult Skills and Family Learning Service
Lincolnshire County Council Logo

You will need a 2aspire account before enrolling onto a course.

Advanced Excel  

 

Visual of the course

Course Summary

Code: 23JAN3106  

Starting: Tuesday 17 December 2024 

Duration: 1 sessions over 1 week(s)

Start Time: 09:00 

Provider: Lincoln College  

Telephone: 01522 876258  

Email: adult@lincolncollege.ac.uk  

Location: Lincoln College  

Cost: Free  

Description

An advanced course aimed at those with a working knowledge of spreadsheets and using Microsoft Excel. This short one day course will develop candidate's working knowledge of using Microsoft Excel to create spreadsheets.
The course content will cover using more complex functions including,
Use and apply Conditional Formatting
Use Flash Fill function
Apply Passwords and Protection to sheets and cells
Create and apply Data Validation rules to cells
Create and manipulate Pivot Tables
Use Subtotals
Create and use named ranges
Use vlookup/match and iferror functions
To enrol
https://www.lincolncollege.ac.uk/course/advanced-excel

For further information email adult@lincolncollege.ac.uk
  

 

Time and duration

Start Date: 17 December 2024
Start Time: 09:00
Day: Tuesday Morning
Session Duration: 06:00
Number of Sessions: 1

Location

Lincoln College  
Lincoln College  
Monks Road
Lincoln  
Lincolnshire LN2 5HQ

Find us here