Excel 365 in 30 Minutes – Formatting Part 1 (Basics 7 of 10)

In this Bigger Brains course, you’ll learn how to apply text and font formatting from both the Ribbon and the Format Cells dialog box to make your data easier to read. You’ll see how to use built in Cell Styles to quickly apply consistent formatting, and you’ll explore how to modify, reset, or delete styles when you need more control. You’ll also learn how to create your own custom Cell Styles and even merge styles across workbooks for consistent branding. 

You’ll explore Excel’s themes, see how to identify theme components, and learn to customize and save your own themes to give your worksheets a cohesive, professional look. You’ll also learn the basics of Conditional Formatting—how it works, when to use it, and how to apply rules that highlight key numbers at a glance. You’ll see how to clear formatting when needed and leave this course ready to make your spreadsheets both attractive and easy to interpret. 

Topics covered include: 

• Applying Font Settings from the Ribbon and the Format Cells dialog box 

• Applying formatting to a cell using built-in Cell Styles 

• Modifying, resetting, and deleting styles 

• Using a built-in style 

• Creating and applying a Custom Cell Style 

• Merging Styles between workbooks 

• Changing a workbook theme  

• Listing theme components 

• Modifying a theme and saving it as a custom theme 

• Describing the purpose and use of Conditional Formatting 

• Applying Conditional Formatting Rules to numbers 

• Clearing Conditional Formatting from a cell or range 

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.