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

---

In addition to the formats built into Excel, you can also use custom formats. Learn to create and use custom date, time, number, and text formats, and work with the conditional formatting tools in Excel.

---

---

Objectives
Microsoft Excel 2016 for Mac: Custom and Conditional Formatting customize date and time formats in Excel 2016 for Mac create and customize number formats in Excel 2016 for Mac use custom text formats in Excel 2016 for Mac create conditional custom formats in Excel 2016 for Mac use conditional formatting tools in Excel 2016 for Mac create and use advanced conditional formatting tools