Candidates with ECDL Advanced Spreadsheets certified skills can:

• Produce higher quality information
• Pinpoint key information quicker and more easily
• Provide more sharply-defined analysis
• Produce more sophisticated reports
Use advanced editing, data handling, functions and analysis features Use macros within the spreadsheets application

In today’s competitive market, give yourself the edge and go to the next level with the ECDL Advanced Spreadsheets certification

ECDL Advanced Spreadsheet is targetting people both at the workplace, business and the education and it is particularly suitable for:

• Personnel who require advanced integrated office skills to timely execute their duties and/or support their executives, directors and managers
• Secretaries, Personal and Management Assistants who prepare complicated budget reports, use financial data and develop graphs in their reports and documents for the executives, directors and managers 
• Financial and accounting personnel in organizations who integrate financial data to produce charts, graphs and documents of high quality 
• Students in high school, college and university, especially those of the economic, management, financial and engineering sectors who prepare documents and reports of high quality with content integrated from various office applications as part their normal assignments and work
•  Teachers at all levels of education who wish to enhance and enrich their skills and apply advanced techniques to their work of assignments and test assessment 
• Employees in organizations of all types who provide a first or second line of IT support to end-users who use Spreadsheet applications

who will find the ECDL Advanced Spreadsheet qualification valuable and useful for their everyday work.

ECDL Advanced Spreadsheets is also suitable for those candidates who have completed the ECDL Core Module 4 - Spreadsheets qualification and wish to prove their skills and competence in the use of computer applications at a higher, proficient level.

Benefits of ECDL Advanced Spreadsheets (AM4)

What are the benefits for the Candidate?

As a certified ECDL Advanced Spreadsheets Candidate you will:

• be confident, efficient and effective in using the spreadsheet application
• be able to prove that you have mastery of the application
• produce better reports with deeper data analysis
• produce higher quality management information
• improve your productivity
• increase your prospects for employment or promotion
• have an internationally recognised qualification.
  

What are the benefits for Organisations?

Personnel with ECDL Advanced Spreadsheets certified skills can:

• produce higher quality information
• manage information better
• pinpoint information quicker and more easily
• provide more sharply-defined analysis
• increase their productivity
• provide instant access to key management information
• give a greater insight into the marketplace
• enable the organisation to make better decisions

In order to take the test in any ECDL Advanced Module the candidate must have completed successfully the corresponding ECDL Core Module; in this case the ECDL Core Module 4 in Spreadsheets. There is no other requirement in order to register and achieve the ECDL Advanced Module 4 in Spreadsheets.

The main areas covered in the ECDL Advanced Spreadsheets (AM4) Syllabus are:

1. Editing
With the ECDL Advanced Spreadsheets certification one can:

• Prove your mastery of many advanced data manipulation tools within spreadsheet applications.
• Acquire the skills to use subtotalling features to calculate key subtotals instantly and to create what-if tables to display outcomes based on variable scenarios.
• Use conditional formatting options to apply different formats to selected data within a spreadsheet or use paste special options to remove formulae from data and to transpose data for presentation purposes.

2. Data Handling
The ECDL Advanced Spreadsheets Syllabus covers a wide range of valuable advanced data handling options:

• Sorting - Sort data by multiple columns (e.g. apply multiple sort criteria simultaneously) or perform custom sorts (e.g. sort data alphabetically by day or by month).
• Querying/Filtering - Extract clear, accurate information from lists by creating single or multiple criteria queries or by using advanced query and filter options.
• Linking - Use the powerful linking tool to link data or charts within a worksheet, between worksheets, between spreadsheets or into a word processing document. Linked information remains constantly updated, thereby keeping all your information current and reducing your workload.
• Templates - Use and edit templates to create customised worksheets.
• Charts - Create and manipulate charts within a spreadsheet to create sophisticated, professional-quality work.

3. Functions
Acquire the skills to use a battery of effective tools to create enhanced data analysis. Use date/time functions, mathematical functions, statistical functions, text functions, logical functions, financial functions, lookup and reference functions and available database functions to extract precise information from the data.

4. Analysis
Make data analysis easier using the following:

• Pivot Tables/Dynamic Crosstab - This impressive number-crunching tool can collapse large quantities of data into concise management information. With ECDL Advanced Spreadsheets you can gain the skills to create and edit pivot tables or dynamic crosstab reports to manipulate large quantities of data by various criteria to produce pinpoint-accurate information summaries.
• Scenarios/Versions - Create a variety of scenarios to produce instant reports that illustrate a variety of circumstances.
• Auditing - Use auditing tools to show formulae used to create reports to trace cells feeding into formulae and to add and edit comments.

5. Special Tools
Record and run simple macros and assign a custom button to a macro on a toolbar.