Description

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

Tags

Syllabus

Syllabus IntroductionWelcomeWho should take this courseUsing the exercise filesUsing the challenges1. Microsoft Office Specialist Exam OverviewCompare the different Microsoft Office Specialist certificationsPrepare for the examExam format and registration process2. Create and Manage Workbooks and WorksheetsCreate worksheets and workbooksNavigate in worksheets and workbooksFormat worksheets and workbooksConfigure page setup and headers/footersCustomize options and views for worksheets and workbooksConfigure worksheets and workbooks for distributionChallenge: Create and manage workbooks and worksheetsSolution: Create and manage workbooks and worksheets3. Manage Data Cells and RangesInsert data in cells and rangesFormat cells and rangesSummarize data with conditional formattingSummarize and organize dataChallenge: Manage data, cells, and rangesSolution: Manage data, cells, and ranges4. Create TablesCreate and manage tablesManage table styles and optionsFilter and sort a tableChallenge: Create and manage tablesSolution: Create and manage tables5. Perform Operations with Formulas and FunctionsSummarize data by using functionsUse conditional operation functions: IF and COUNTIF functionsUse conditional operation functions: SUMIF and AVERAGEIFFormat and modify text by using functionsCombine text using functions and flash fillChallenge: Perform operations with formulas and functionsSolution: Perform operations with formulas and functions6. Create Charts and ObjectsCreate chartsFormat chartsInsert and format objectsChallenge: Create charts and objectsSolution: Create charts and objects7. Final Practice ExamChallenge: Full-length practice examSolution: Full-length practice examConclusionNext steps Read more