Description

Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist (MOS). Get training for the Excel Associate certification exams for Office 365 and Office 2019.

Tags

Syllabus

Syllabus IntroductionProve your Excel skills with a MOS certificationWho should take this course?About the exercise filesAbout the challenges1. Microsoft Office Specialist Exam OverviewDifferent kinds of Microsoft Office Specialist certificationsPrepare for the test and review learning objectives2. Manage Worksheets and WorkbooksImport TXT or CSV data into a new workbookImport TXT or CSV data into an existing workbookSearch for data within a workbookNavigate data with named ranges and hyperlinksFormat worksheets and workbooksCustomize headers and footersDisplay and modify content in different viewsModify basic workbook propertiesCustomize the Quick Access ToolbarInspect and export workbooksConfigure print settingsChallenge: Manage worksheets and workbooksSolution: Manage worksheets and workbooks3. Manage Data Cells and RangesPaste data using special paste optionsFills cells by using AutoFillInsert and delete columns, rows, and cellsFormat cells and rangesApply styles to cells and rangesDefine and reference named rangesInsert sparklinesSummarize data visually with built-in conditional formattingChallenge: Manage data, cells, and rangesSolution: Manage data, cells, and ranges4. Manage Tables and Table DataCreate and format tablesModify tablesFilter and sort table dataChallenge: Manage tables and table dataSolution: Manage tables and table data5. Perform Operations Using Formulas and FunctionsInsert relative, absolute, and mixed referencesReference named ranges and named tables in formulasUsing the AVERAGE(), MAX(), MIN(), and SUM() functionsCount cells using the COUNT(), COUNTA(), and COUNTBLANK() functionsPerform conditional operations using the IF() functionFormat text using the RIGHT(), LEFT(), and MID() functionsFormat text using UPPER(), LOWER() and LEN() functionsFormat text using the CONCAT() and TEXTJOIN() functionsChallenge: Perform operations using formulas and functionsSolution: Perform operations using formulas and functions6. Manage ChartsCreate chartsModify chartsAdd and modify chart elementsFormat chartsChallenge: Manage chartsSolution: Manage charts7. Final Practice ExamChallenge: Full-length practice examSolution: Full-length practice examConclusionNext steps Read more