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. 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. 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 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 * Tracking and reviewing changes
Name: MICROSOFT EXCEL ADVANCED Qualification title: Non regulated provision, Level 2, ICT for Users Qualification type: Assessment Awarding Generic award - no awarding body Created 20160307 14:29:17 Updated 20160307 14:29:17
None
Lancaster & Morecambe College
Further Education
info@lmc.ac.uk
01524 66215
http://www.lmc.ac.uk
Morecambe Road Town: Lancaster County:Lancashire
Title: Non regulated provision, Level 2, ICT for Users Qualification: Non regulated provision, Level 2, ICT for Users Classification: Information and Communication Technology