We Provide Real World Training In

Microsoft Office Specialist (MOS) 77-420: Excel 2013

£89.00

Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Syllabus:

  • Creating Workbooks, Worksheets, and Data in Excel 2013
  • Saving and Printing Data in Excel 2013
  • Formatting Cells and Worksheets in Excel 2013
  • Formatting Data in Excel 2013
  • Presenting Data using Conditional Formatting and Sparklines in Excel 2013
  • Performing Calculations Using Functions in Excel 2013
  • Presenting Data in Tables and Charts in Excel 2013
  • Creating and Customizing Visual Elements in Excel 2013
  • Customizing Options and Views in Excel 2013
  • Manipulating Data in Excel 2013
  • Data Search, Data Validation, and Macros in Excel 2013

Course Duration:     11 hours
Course Delivery:    Online

Purchase Course