最新消息:网盘下载利器JDownloader--|--发布资讯--|--解压出错.密码问题

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

其他教程 killking 0评论
Lynda - Cert Prep: Excel 2013 Microsoft Office Expert Part Two (77-428)

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
Lynda - Cert Prep: Excel 2013 Microsoft Office Expert Part Two (77-428)
Download 百度云

以下隐藏内容只提供VIP赞助会员

sorry! The following hidden content sponsorship VIP members only.

您必须 登录 才能发表评论!