|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/awesomeexcelassociatecertificationcourse/
课程评论：没有评论
Course Name: MOS Excel Associate Certification MO-200: Master Concepts This Coursera course prepares you for the MOS Excel Associate (MO-200) certification exam. It covers the fundamental concepts required for the exam, including: * **Managing worksheets and workbooks:** This section focuses on navigating, formatting, customizing options, configuring for collaboration, and importing data into your Excel files. * **Managing data cells and ranges:** Learn to manipulate data, format cells and ranges, define and reference named ranges, and visually summarize your data. * **Managing tables and table data:** This module covers creating, formatting, filtering, and sorting tables in Excel. * **Performing operations by using formulas and functions:** Master inserting references, calculating and transforming data, and formatting/modifying text using Excel's powerful formula and function capabilities. * **Managing charts:** Gain skills in creating, modifying, and formatting charts to visually represent your data. The course includes practical tips for exam success and provides practice exercises mirroring the MOS Excel Associate exam's question patterns. Passing the exam with a score of 70% or higher earns you the MOS Associate Excel certification, a valuable credential that demonstrates your Excel proficiency to employers and can positively impact your career and earning potential.
This course provides an overview of the MOS Excel Associate exam and covers the fundamentals of creating and managing worksheets as listed in the exam requirements. The course includes tips on how to do well on the test. Finally, the test includes exercises for each topic + test exercises that follow the pattern of questions asked in the MOS Excel Associate exam. Microsoft provides everyone who scores 70% on the exam with the MOS Associate Excel, or Microsoft Office Specialist Associate Excel certification. This certification demonstrates your proficiency in Excel to your employer or potential employer and is a great asset in your work, career, and salary potential. All the best.Become a Microsoft Office Specialist and Enhance Your CareerUse your knowledge to obtain certified statusUnderstand the MO-200 ExamLearn how to correctly prepare for the testGet advice from a seasoned professional who knows how to pass the examYou will learn how to:Manage worksheets and workbooks (10-15%)Import data into workbooksNavigate within workbooksFormat worksheets and workbooksCustomize options and viewsConfigure content for collaborationManage data cells and ranges (20-25%)Manipulate data in worksheetsFormat cells and rangesDefine and reference named rangesSummarize data visuallyManage tables and table data (15-20%)Create and format tablesModify tablesFilter and sort table dataPerform operations by using formulas and functions (20-25%)Insert referencesCalculate and transform dataFormat and modify textManage charts (20-25%)Create chartsModify chartsFormat charts
