Course details
This course provides the basis for the practice-based test for ICDL Perform Advanced Spreadsheet Functions exam.
The exam requires the candidate to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The candidate shall be able to operate effectively at more than a basic level of competence and be able to edit and enhance numeric, text and graphical data and to sort, query and link data. The candidate shall be able to carry out advanced formatting and presentation operations on charts and graphs. The candidate shall be able to use functions such as those associated with logical, statistical or mathematical operations. The candidate shall be able to use available analysis and audit tools and to run and record simple macros.
COURSE OUTLINE
- Using Conditional and Custom Formats
- Using Templates
- Working with Databases
- Working with Advanced Filters
- Revising Charting Features
- Creating/Revising PivotTables
- Using Auditing Tools and Range Names
- Exporting and Importing Data
- Using Advanced Functions
- Using Scenarios
- Using Worksheet Protection
- Tracking and Merging Workbooks
- Recording Macros
- Comments
Course Location
About COMAT Training Services Pte Ltd
To be or not to be; this is the question which resides in us. All man of clay, our innate differences are subtle and few. The void spanning greatness hinges on existence of mean and will. COMAT holds an intrinsic belief that every inpidual has a potential to be realised. Betterment of society through advancement of its basic unit, empowerment through continuous learning – Upon these axioms were we founded, and today proudly uphold.
Love for the people around us, a desire for a better world, our passion is our profession. COMAT believes learning is a lifelong process and key to a meaningful existence. Spearheaded by a renowned team of highly experienced and motivated trainers, COMAT offers an extensive array of IT, safety and leadership & professional development courses, providing inpiduals with the means to excel.
While adhering to globally accepted quality standards, our intention goes beyond training and certification - COMAT provides a holistic experience, focusing on generation of inductive environments for stimulating philosophical thoughts. True learning lies in instillation of a sense of self-realisation, a will to become who they can be.
We pride ourselves on our innovations, our desire for continuous improvement, and the ability to perceive the needs and wants of each inpidual. Customized approaches for varying needs, we conjure solutions tailored to fit.
See all COMAT Training Services Pte Ltd courses- Microsoft Project Essentials 1TRAININGSGD 66Duration: Upto 10 Hours
- Microsoft Excel : Top 50 Formulas Course DriveSGD 32
SGD 214Duration: Upto 1 Hour