SaraDaddy

Lynda Cert Prep Excel 2016 Microsoft Office Expert 77-728

Released : 1/27/2017
Included Exercise Files
Duration : 3h 21m
Skill Level : Advanced
Language : English
Size : 509,98 Mb

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

https://www.filefactory.com/file/2io803tpre33/