Description

Demonstrate your advanced knowledge of Excel 2013 by becoming a Microsoft Office Specialist (MOS) Expert. Prepare for the first part of the 77-427 exam: Excel 2013 Expert Part One.

Tags

Syllabus

Syllabus IntroductionWelcomeWhat to know before watching this courseUsing the exercise files1. Microsoft Office Specialist (MOS) Expert Exam OverviewUnderstand the different kinds of Microsoft Office Specialist certificationsReview the exam format and learning objectives2. Manage and Share WorkbooksTrack, retain, and display all changesManage commentsIdentify and troubleshoot errors with tracingChallenge: Manage and share workbooksSolution: Manage and share workbooks3. Apply Custom Formats and LayoutsApply advanced conditional formattingUse functions to format cells and apply advanced filtersModify tab order among workbook elements and objectsPrepare a workbook for internationalizationPrepare a workbook for accessibilityManage multiple options for +Body and +Heading fontsChallenge: Apply custom formats and layoutsSolution: Apply custom formats and layouts4. Create Advanced FormulasUse the LOOKUP functionUse the HLOOKUP and VLOOKUP functionsUse the MATCH and INDEX LOOKUP functionsUse the TRANSPOSE functionUse the NOW and TODAY functionsUse functions to serialize dates and timesChallenge: Create advanced formulasSolution: Create advanced formulas5. Create Advanced Charts and TablesAdd trendlines and view chart animationCreate dual axis charts and custom chart templatesCreate, format, and filter PivotTablesGroup records and use calculated fieldsUse PowerPivot and manage relationshipsChallenge: Create advanced charts and tablesSolution: Create advanced charts and tables6. Full-Length MOS Expert Sample Exam for Excel 2013Challenge: Full-length practice examSolution: Full-length practice examConclusionNext steps Read more