|
Todo o mundo Demonstrate your advanced knowledge of Excel by becoming a Microsoft Office Specialist (MOS). This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Microsoft Office Specialist (MOS) Expert Exam for Excel 2016, which focuses on managing workbook options and settings, applying custom data formats and layouts, creating advanced formulas, and creating advanced charts and tables.
The course begins with an overview of the certification program and its costs. Next, Jennifer walks you through all the certification objectives, including hands-on experience with downloadable sample documents. She wraps up with a full-length practice test that emulates exam 77-728, together with solutions to each of the exam challenges.
Topics include:
- Identify two locations that offer users the ability to control how formulas are calculated.
- Recall two strategies for formatting decimal places.
- Recognize the importance of creating a combo box with specific values in a worksheet.
- Identify the purpose of the Trace Dependents Formula Auditing tool.
- Explain why the Scenario Manager is useful.
- List four options for grouping date values in a PivotTable.
[ Modificado: segunda, 2 dezembro 2019, 08:06 ] |