Lynda - Cert Prep: Excel 2013 Microsoft Office Expert Part Two (77-428)

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

Genre: eLearning | Level: Advanced | Language: English

Make evident 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 Two exam, the second part of a two-part exam. This course takes the topics from the first course further: managing and sharing workbooks, applying custom formats and layouts, creating advanced formulas, and creating advanced charts and tables. In the managing workbooks chapter, learn how to work with templates, versions, and macros. In the formatting and layout chapter, see how to apply custom formats and styles. The advanced formula chapter covers additional functions including a nested IF. The charts and tables chapter shows how to create a new PivotChart. The course concludes with a sample exam you can use for practice.

Topics include:

* Using templates

* Managing versions

* Leveraging macros

* Linking to external data

* Protecting cells

* Hiding formulas

* Using advanced Fill Series options

* Creating form fields

* Using advanced functions: AND/OR, SUMIFS, AVERAGEIFS, and COUNTIFS

* Manipulating options in existing PivotCharts