Course details

Excel 2019 for Windows: Formatting Data

Excel 2019 for Windows: Formatting Data

Expected Duration
Lesson Objectives
Course Number
Expertise Level


Formatting data makes it easier to see and work with. In this 14-video course, you will discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation. Learners will begin by observing how to set a data type, and then format their data, the tools of which can be used to change the appearance of text in tables. Then move on to aligning your data, by using tools to change where text appears within its respective cell. Next, observe how to use colors, which can help data stand out for the reader and make the table easier to read. Discover how to change the cell style; use document themes, and use formulas to modify the text case. Explore how to create clean, professional looking titles, and format titles to make them presentable. Create tables to ease organization; resize columns and rows; insert borders, and columns and rows. Conclude the course by observing how to transfer format styles.

Expected Duration (hours)

Lesson Objectives

Excel 2019 for Windows: Formatting Data

  • Setting your data type
  • Formatting your data
  • Aligning your data
  • Using colors
  • Changing your cell style
  • Using document themes
  • Using formulas to modify your text case
  • Creating a WordArt title
  • Formatting a title
  • Creating a table
  • Resizing columns & rows
  • Inserting columns & rows
  • Inserting borders
  • Transferring format styles
  • Course Number:

    Expertise Level