This workshop is aimed at members of the workplace with a clear working knowledge of Microsoft Excel who are involved in using spreadsheets each day and would like to introduce advanced techniques to automate everyday tasks. Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.
This Advanced Excel workshop will introduce you to some of Microsoft Excel’s more powerful features and functions.
Refreshments and a light business lunch is included.
In this workshop we will start to build on the Microsoft Excel skills you already use each day with the introduction of advanced spreadsheet techniques.
Topics covered will include:
Editing data
Displaying data
Sharing, comparing and merging worksheets
Password and security
Sorting
Filtering
Validating with Microsoft Excel
Linking and embedding
Hyperlinks
Using advanced functions
Using macros
Pivot tables
Scenarios
Auditing
LMC offers a wide range of courses, perfect for up skilling the workforce on day courses or more in-depth professional training packages. You may be interested in:
Lean Organisation Management Techniques – Level 2
Principles of Business Administration – Level 2
Principles of Customer Service – Level 2
Principles of Team Leading - Level 2
There are no formal entry requirements nor any formal assessments for this course and delegates will receive a College certificate upon completion.
This course costs £11.00, including exam fees.
You may be eligible for free study if you are 23 or under and this is your first full Level 2 or 3 course. Alternatively, if you are unemployed, receiving an eligible benefit, and taking the course to help you find employment.
You may also be entitled to additional financial support including course materials, uniforms, and childcare expenses depending upon your individual circumstances. Read more about Financial Support for adults.
If you would like to apply for this course, please click 'Apply' in the top right, follow the steps, and our Admissions Team will be in touch with you.
For more information, advice and guidance please phone Employer Engagement on 01524 521223 or 0800 306306 or email employerengagement@lmc.ac.uk
Course code: B64072