This course is for those who are able to use a computer to create and save files and want to develop their spreadsheet skills Topics that are delivered include: -Setting up spreadsheets with the correct formatting -Making calculations with the correct formula -Using SUM and AVERAGE functions -Filtering data -Creating different types of charts from a table -Freezing rows and columns on tables for easier viewing -Use conditional formatting -Import data from text sheets to the spreadsheet -Perform multiple column sorts
Name: Beginners/intermediate Excel Qualification title: Non regulated SFA formula funded provision, Level 2, ICT for Users, 5 to 6 hrs, PW A Qualification type: Course provider certificate (this must include an assessed element) Assessment Awarding Generic award - no awarding body Created 20170109 15:53:36 Updated 20170109 15:53:36
None
Wirral Met College
Further Education
wmc.enquiries@wmc.ac.uk
0151 551 7777
http://wmc.ac.uk/
Conway Park
Europa Boulevard
Town:
Birkenhead
County:Wirral
Title: Qualification: Classification: