Productivity & Collaboration Tools     Microsoft Office for Mac 2016     Microsoft Office for Mac 2016: Excel (No Assessments)

---

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.

---

---

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