ECDL Advanced Spreadsheets

Course details

On completion of this course, you will be able to:

• Apply advanced formatting options such as conditional formatting and customised 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 analyse, 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 and review spreadsheets. Apply spreadsheet security features

What are the benefits of this module?

• Allows users to become more confident, efficient and effective in using a spreadsheet application
• Proves mastery of the application
• Enables users to produce better reports with deeper data analysis
• Improves user’s productivity
• Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content