ICDL Advanced Spreadsheets

Description

Course Code APR0303   Aspyra delivers this Level 3 ICDL Advanced Spreadsheets course either remotely or in house over a 2-day period. The 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 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, Applying security features to spreadsheets.