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.

Learning objectives

  • Create a new workbook and open a workbook in Excel 2013
  • Decide how to create a new workbook in Excel 2013
  • Move around Excel and enter data
  • Cut, copy, and paste in Excel 2013
  • Edit data in Excel 2013
  • Delete or hide a worksheet
  • Organise and modify worksheets in Excel 2013
  • Choose the best way to organise and modify worksheets in Excel 2013


Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

60 Minutes

365 Days