Excel - Advanced

The module goals for ECDL are set by BCS. The advanced Excel Module has the following goals: Application of advanced formatting such as conditional formatting and customised number formatting and handle worksheets. Use of 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. Using validation and auditing tools on spreadsheet data. Enhancing productivity by using named cell ranges, macros and templates. Integration of data using linking, embedding and importing. Collaborative spreadsheets, reviewing spreadsheets. Application of security features