Excel 2016 Essentials – Data Formatting

Overview

Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text and apply styles to differentiate your data. In this course, you’ll learn how to create custom formatting and styles, and how to copy formatting from one cell to another. In addition to formatting and styling data in Excel 2016, you will learn how to position data in a spreadsheet.

Objectives

• Applying formatting to different types of numeric data in Microsoft Excel 2016
• Formatting text data in Microsoft Excel 2016
• Creating custom text and numeric formats in Microsoft Excel 2016
• Applying edges and fills to cells in Microsoft Excel 2016
• Applying cell styles to your data in Microsoft Excel 2016
• Create a custom cell style in Microsoft Excel 2016
• Use the Format Drawing tool to copy formatting to Microsoft Excel 2016
• Insert and resize columns and rows in Microsoft Excel 2016.
• Change alignment, spacing, and targeting cell data in Microsoft Excel 2016
• merging and splitting cell data in Microsoft Excel 2016