Formatting Cells and Worksheets 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 worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. 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 Cells and Worksheets in Excel 2013

  • change font formatting in Excel 2013
  • apply borders and fills and create a cell style
  • copy formatting with Format Painter in Excel 2013
  • change the alignment, indentation, and orientation of data in Excel 2013
  • merge cells and wrap text in Excel 2013
  • Course Number:
    mo_bgel_b03_dt_enus

    Expertise Level
    Beginner