Home»2022»December»12»Lynda Cert Prep Excel 2013 Microsoft Office Expert Part Two 77-428
19:53:14
Lynda Cert Prep Excel 2013 Microsoft Office Expert Part Two 77-428
Included Exercise Files
Skill Level : Advanced
Duration : 2h 46m
Language : English
Released : 5/4/2017
Size : 363,05 Mb
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.
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
