Description

Prep for the MOS Excel 2013 certification exam. Review worksheets and workbooks, cells and ranges, formulas and functions, charts, and other objects. Take the practice test.

Tags

Syllabus

Syllabus IntroductionWelcomeWhat you should know before watching 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 new workbooksAdd, copy, and move worksheetsUse hyperlinks to navigate workbooksUse named ranges in navigation and formulasUse Find and Replace for conditional formatting and data validationFormat using styles or themesFormat using the Page Layout ribbonInsert headers and footers into worksheetsInsert columns and rows; hide and unhide dataConfigure worksheets and workbooks for printingAdd values to workbook propertiesChallenge: Worksheets and workbooksSolution: Worksheets and workbooks3. Create and Modify Cells and RangesUse Append to insert data into cellsMove data between cells, worksheets, and workbooksFormat worksheets using merge, cell styles, and number formatsResize cells to accommodate textFormat cells using merge and align optionsApply conditional formattingCreate and use named rangesUse Find and ReplaceChallenge: Cells and rangesSolution: Cells and ranges4. Create and Modify TablesCreate tablesModify tablesFilter and sort tablesChallenge: Create and modify tablesSolution: Create and modify tables5. Apply Formulas and FunctionsUse relative and absolute references in formulasUnderstand the order of operations in formulasSummarize data using functionsUtilize conditional logic in functionsFormat with text functionsChallenge: Formulas and functionsSolution: Formulas and functions6. Create Charts and ObjectsCreate charts and add data seriesFormat chartsInsert and format graphic objectsChallenge: Charts and objectsSolution: Charts and objects7. Final Practice ExamChallenge: Full-length practice examSolution: Full-length practice examConclusionNext steps Read more