Course details
This instructor led course empowers participants to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The participants 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 participants shall be able to carry out advanced formatting and presentation operations on charts and graphs. The participants shall be able to use functions such as those associated with logical, statistical or mathematical operations. The participants 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
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- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office Essentials London Institute of Business & ManagementSGD 25
SGD 282Duration: Upto 67 Hours - Microsoft OneNote Global CoursesSGD 20
SGD 188Duration: 1 Hour