ICDL Advanced Spreadsheet Distance Learning

Description

Course Code APR0304 The European Computer Driving Licence (ECDL) qualification has been rebranded by the awarding body to International Certification of Digital Literacy (ICDL) reflecting its international reach. Advanced Spreadsheet is part of the Level 3 ICDL Advanced course that enables learners to develop existing knowledge, skills and expertise in using the Microsoft Excel Spreadsheet software to advanced level whilst supporting the demands of the workplace. ICDL Advanced Spreadsheet provides the basis for the the practice based ICDL Advanced Spreadsheets test. The course is interactive, and packed with exercises, it enables learners to effectively prepare for their exams by using the spreadsheet application to produce advanced spreadsheet outputs. Upon completion of the course, learners will become fully competent in the following: Applying advanced formatting options, including Conditional Formatting, Customised number formatting and handle worksheets, Using functions associated with logical, statistical, financial and mathematical operations, Creating charts and applying advanced chart formatting techniques, Working with tables and list including analysing, filtering and sorting data, Validating and auditing spreadsheet data, Enhancing productivity by working with named cell ranges, macros and templates Integrate data through using linking, embedding and importing features, Collaborating on and reviewing spreadsheets, Applying security features to spreadsheets