Excel 365 in 30 Minutes – Formatting (Intermediate 3 of 8)

In this Bigger Brains course, you’ll learn how to select and apply cell formats using the Format Cells dialog box, as well as how to create and modify your own Custom Number Formats for more precise control over how your data appears. You’ll see how to quickly remove unwanted formatting using the Clear Formats command, and you’ll explore practical scenarios where thoughtful formatting helps communicate your data more effectively. 

You’ll learn how to enhance analysis with Conditional Formatting and how to apply rules to highlight text and dates. You’ll explore three types of comparative analysis formatting to help you spot trends and variances at a glance. You’ll also learn how to create new rules from the New Formatting Rule dialog box, customize them using the Rules Manager, and set rule precedence to control which formatting takes priority. Designed for users comfortable with Excel basics, this course helps you present data more clearly and gain deeper insights through smarter formatting. 

Topics covered include: 

• Selecting a cell format from the Format Cells dialog box 

• Creating and modifying a Custom Number Format. 

• Removing formatting from a cell using Clear Formats command. 

• Applying Conditional Formatting Rules to text 

• Applying Conditional Formatting Rules to dates 

• Applying 3 types of Comparative Analysis Formatting 

• Describing how Comparative Analysis Formatting is applied 

• Creating a new rule from the New Formatting Rule dialog box  

• Customizing rules using the Rules Manager 

• Setting rule precedence in the Conditional Formatting Rules 

Enjoy award-winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.