Lynda - Excel 2016: Prepare for the MOS Expert Certification Exam (77-728)

Size: 576 MB | Duration: 3h 18m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Advanced | Language: English

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 of 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:

* Managing workbooks

* Referencing data in another workbook

* Protecting worksheets and workbooks

* Creating custom formats

* Creating custom styles and themes

* Creating advanced formulas

* Defining named ranges and objects

* Crafting advanced charts and tables