->

Cert Prep: Excel 2013 Microsoft Office Expert Part One (77-427)

Cert Prep: Excel 2013 Microsoft Office Expert Part One (77-427)
Size: 414 MB | Duration: 2h 42m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Beginner | Language: English

 

Demonstrate your advanced knowledge of Excel by becoming a Microsoft Office Specialist (MOS) Expert. This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Excel 2013 Expert Part One exam, the first part of a two-part exam.


This course focuses on managing and sharing workbooks, applying custom 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 through all of the certification objectives, including hands-on experience with downloadable sample documents, so you can practice as you go. She wraps up with a full-length practice test that emulates exam 77-427, together with solutions to each of the exam challenges.

Topics include:
* Reviewing the exam format and learning objectives
* Tracking, retaining, and displaying all changes
* Identifying and troubleshooting errors with tracing
* Applying custom formats and layouts
* Applying advanced conditional formatting
* Using functions to format cells and apply advanced filters
* Preparing a workbook for internationalization
* Creating advanced formulas
* Using the LOOKUP and TRANSPOSE functions
* Using functions to serialize dates and times
* Creating advanced charts and tables

 

Cert Prep: Excel 2013 Microsoft Office Expert Part One (77-427)


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss