ADVANCED SPREADSHEETS

This competence of advanced spreadsheets provides the advanced for the spreadsheets in computer literacy’s practice-based. Is above the skills and knowledge contained within the spreadsheets in computer literacy. Advanced spreadsheets anticipates that the candidate has already acquired the skills and knowledge outlined in spread sheets in computer literacy. Advanced Spreadsheets requires the candidate to use the spreadsheet application to produce advanced spreadsheet outputs. The candidate shall be able to apply advanced formatting options such as conditional formatting and customized number formatting and handle worksheets. Use functions such as those associated with logical, statistical, financial and mathematical operations. Create charts and apply advanced chart formatting features. Work with tables and lists to analyze, filter and sort data. Create and use scenarios. Validate and audit spreadsheet data. Enhance productivity by working with named cell ranges, macros and templates. Use linking, embedding and importing features to integrate data. Collaborate on, review spreadsheets, and apply spreadsheet security features.