Microsoft Excel 2016 for Mac: Formatting Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


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

Expected Duration (hours)
0.9

Lesson Objectives

Microsoft Excel 2016 for Mac: Formatting Data

  • set your data type in Excel 2016 for Mac
  • format your data in Excel 2016 for Mac
  • align your data in Excel 2016 for Mac
  • use color in Excel 2016 for Mac
  • change your cell style in Excel 2016 for Mac
  • use Excel 2016 for Mac themes to change the appearance of your spreadsheets
  • use formulas to modify your text case in Excel 2016 for Mac
  • use the WordArt tool to create titles
  • format titles in Excel 2016 for Mac
  • create tables in Excel 2016 for Mac
  • resize columns and rows in Excel 2016 for Mac
  • insert new columns and rows into your tables
  • transfer format styles in Excel 2016 for Mac
  • use border tools in Excel 2016 for Mac

    • Course Number:
    ds_msex16mc_04_enus

    Expertise Level
    Beginner