تفاصيل الدورة
In this course, the participant will be introduced to the more advanced features of Microsoft Excel 2010. The participant will learn how to manage, filter and generate reports from Excel data. The course also shows the participant how to summarize and analyze data using tools such as Pivot Tables, Scenarios and Goal Seek. Additionally, participants will learn how to create macros to automate some repetitive tasks, as well as how to protect worksheets and workbooks. At the end of the course, the participant will be able to demonstrate the ability to manage and analyze data efficiently with Microsoft Excel 2010.
This course prepares the participants for the Microsoft Office Specialist exams.
COURSE OUTLINE
- Applying Workbook Settings
- Sharing Workbooks
- Using Conditional and Custom Formats
- Using Templates
- Working with Advanced Filters
- Creating/revising Pivottables
- Using Range Names
- Consolidating Worksheets
- Using Advanced Functions
- Using Other Functions
- Using Auditing Tools
- Using Scenarios and Goal Seeking
- Using Worksheet Protection
- Creating Charts
- Formatting Charts
- Using Advanced Charting Features
- Recording Macros
- Creating Macro Buttons
الموقع
نبذة عن معهد 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.
عرض الجميع دورات COMAT Training Services Pte Ltd- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Office 2016 Beginners Diploma Alpha Academy34 SGD
438 SGDمدة الدورة التدريبية: Upto 3 Days - Microsoft Office 2010 Access Advanced Alpha Academy34 SGD
384 SGDمدة الدورة التدريبية: Upto 3 Hours
