Formatting Data in Excel 2013


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. 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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
0.6

Lesson Objectives

Formatting Data in Excel 2013

  • format numbers in Excel 2013
  • use Auto Fill to copy and fill a series in Excel 2013
  • extract or add data using Flash Fill in Excel 2013
  • create and modify a hyperlink in an Excel 2013 workbook
  • Course Number:
    mo_bgel_b04_dt_enus

    Expertise Level
    Beginner