Description

Make evident your advanced knowledge of Excel by becoming a Microsoft Office Specialist (MOS) Expert. This course helps you prepare for the Excel 2013 Expert Part Two exam.

Tags

Syllabus

Syllabus IntroductionWelcomeWhat to know before watching this courseUsing the exercise files1. Microsoft Office Specialist (MOS) Expert Exam OverviewThe different kinds of Microsoft Office Specialist certifications2013 MOS Expert exam format and learning objectives2. Manage and Share WorkbooksCreate and modify templatesManage versions and merge multiple workbooksCopy styles from template to templateLink to external dataCopy macros from workbook to workbookProtecting cells and hiding formulas✓ Challenge: Manage and share workbooks✓ Solution: Management and share workbooks3. Apply Custom Formats and LayoutsCreate and apply custom formats: Number, accounting, time, and dateUse advanced Fill Series optionsCreate and apply custom stylesCreate form fields✓ Challenge: Apply custom formats and layouts✓ Solution: Apply custom formats and layouts4. Create Advanced FormulasUse a Nested IF functionUse the AND/OR functionsUse the SUMIFS, AVERAGEIFS, and COUNTIFS functionsConsolidate data and use the Watch windowEnable iterative calculations and use What-If Analysis toolsUse financial functions✓ Challenge: Create advanced formulas✓ Solution: Create advanced formulas5. Create Advanced Charts and TablesCreate new PivotChartsManipulate options in existing PivotChartsApply styles to PivotCharts✓ Challenge: Create advanced charts and tables✓ Solution: Create advanced charts and tables6. Sample Exam✓ Challenge: Full-length MOS Expert sample exam for Excel 2013✓ Solution: Full-length MOS Expert sample exam for Excel 2013ConclusionNext steps Read more