Complete Guide to Excel 365: Using Formatting Styles & Themes

Conditional formatting is a significant and powerful feature in Excel. In this course youll begin by using some of the more straightforward types of conditional formattings such as those based on specific values or ranking. Youll then use the more visually appealing types of conditional formatting such as data bars icon sets and color scales before advancing to more complex custom formatting rules using worksheet functions and a cells row and column information. Additionally youll distinguish the purpose of notes versus comments and how to work with them both. Finally youll learn to use built-in styles and themes create custom styles and themes and export them for use in other Office 365 products such as PowerPoint to apply a uniform look-and-feel to all your spreadsheets and presentations.