ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2010) هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

ICDL Advanced Spreadsheets is a high level certification programme which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information.

Individual with ICDL 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

TARGET AUDIENCE

Prospective candidates should ideally have the ICDL certification and/or previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a spreadsheet application in a personal or professional context. Spreadsheet applications enable candidates to manipulate and produce precise information and conduct crucial data analysis. The ICDL Advanced Spreadsheets certification has been specifically designed to provide candidates with the skills to exploit the full potential of the spreadsheet application.

COURSE CONTENT

• Formatting
• Cells
• Worksheets
• Functions and Formulas
• Using Functions and Formulas
• Sorting and Filtering
• Scenarios
• Validating and Auditing
• Validating
• Auditing
• Enhancing Productivity
• Naming Cells
• Paste Special
• Templates
• Linking, Embedding and Importing
• Charts
• Creating Charts
• Formatting Charts
• Analysis
• Using Tables
• Automation
• Collaborative Editing
• Tracking and Reviewing
• Security