Course Details

Previous Page


Microsoft Excel 2016 Essentials: Formatting Data


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



Overview/Description
Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text, and apply styles to make your data stand out. In this course, you will learn how to create custom formatting and styles, and copy formatting from cell to cell. In addition to formatting and styling data in Excel 2016, you will learn how to position the data in your spreadsheet.

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

Prerequisites
None

Expected Duration (hours)
0.9

Lesson Objectives

Microsoft Excel 2016 Essentials: Formatting Data

  • start the course
  • apply formatting to different types of numerical data in Microsoft Excel 2016
  • format text data in Microsoft Excel 2016
  • create custom text and numerical formats in Microsoft Excel 2016
  • apply borders and fills to cells in Microsoft Excel 2016
  • apply cell styles to your data in Microsoft Excel 2016
  • create a custom cell style in Microsoft Excel 2016
  • use the Format Painter tool to copy formatting in Microsoft Excel 2016
  • insert and resize columns and rows in Microsoft Excel 2016
  • alter the alignment, indentation, and orientation of cell data in Microsoft Excel 2016
  • merge and split cell data in Microsoft Excel 2016
  • apply a cell style, format numbers and text, and modify the positioning of data in Microsoft Excel 2016
  • Course Number:
    mo_beel_a02_dt_enus