Excel 2010: Formatting Data

Expected Duration
Lesson Objectives
Course Number
Expertise Level


You can make your data more meaningful by changing its appearance in the spreadsheet. Discover how to set data type, format data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.

Expected Duration (hours)

Lesson Objectives

Excel 2010: Formatting Data

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

    Expertise Level