Description

Demonstrate your advanced knowledge of Excel 2016 by becoming a Microsoft Office Specialist Expert. This course helps you prepare for exam 77-728.

Tags

Syllabus

Syllabus IntroductionWelcomeWhat to know before watching this courseUsing the exercise filesUsing the challenge files1. Microsoft Office Specialist (MOS) Expert Exam OverviewUnderstand the different kinds of Microsoft Office Specialist certificationsPrepare for the testOverview of the 2016 MOS Expert exam format and learning objectives2. Manage Workbook Options and SettingsManage workbooksReference data in another workbookReference data using structured referencesProtect worksheets and workbooksChallenge: Manage workbook options and settingsSolution: Manage workbook options and setting3. Apply Custom Data Formats and LayoutsCreate custom formats (number, time, and date)Populate cells by using advanced Fill Series optionsCreate custom conditional formatting rules using operators and formulasManage conditional formatting rulesCreate custom styles and themesInsert and configure form controlsConfigure data validationChallenge: Apply custom data formats and layoutsSolution: Apply custom data formats and layouts4. Create Advanced FormulasUse AND/OR functionsUse IFS functionsUse the LOOKUP functionUse the MATCH and INDEX functionsUse date and time functionsTroubleshoot formulasUse What-If AnalysisDefine named ranges and objectsUse the PMT financial functionCube functionsChallenge: Create advanced formulasSolution: Create advanced formulas5. Create Advanced Charts and TablesUse advanced chart formattingCreate PivotTables and filter with slicersFormat PivotTables and use GETPIVOTDATACreate and modify PivotChartsChallenge: Create advanced charts and tablesSolution: Create advanced charts and tables6. Final ChallengeChallenge: Full-length MOS Expert sample exam for Excel 2016Solution: Full-length MOS Expert sample exam for Excel 2016ConclusionNext steps Read more