ICDL Advanced Spreadsheets

Description

Course Code APR0303  The ICDL (previously ECDL) Advanced Spreadsheet is part of the Level 3 ICDL Advanced course. Delivered remotely or in-house, ICDL Advanced Spreadsheet is a 2-day 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. This remote/in-house direct delivery course is interactive, and packed with exercises, it enables learners to effectively prepare for their exams. Upon completion of the course, learners will become fully competent in: 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  and Applying security features to spreadsheets.