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, Up to 12 hrs, PW B Qualification type: Assessment Awarding Generic award - no awarding body Created 20161103 14:02:20 Updated 20161103 14:02:20
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: Non regulated SFA formula funded provision, Level 2, ICT for Users, Up to 12 hrs, PW B Qualification: Non regulated SFA formula funded provision, Level 2, ICT for Users, Up to 12 hrs, PW B Classification: Information and Communication Technology