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.
For more information, advice and guidance please phone Employer Engagement on 01524 521483 or 0800 306306 or email advice@lmc.ac.uk
Course code: B6867