Excel 365 in 30 Minutes – Formatting Part 2 (Basics 8 of 10)

In this Bigger Brains course, you’ll learn how to control the look and feel of your spreadsheets by aligning text, adjusting orientation, wrapping long entries, and indenting content for cleaner organization. You’ll see how to merge and unmerge cells, apply professional-looking borders and shading, and use both the Ribbon and the Format Cells dialog box to apply number and date formats correctly. You’ll also explore how Excel applies formatting to cells behind the scenes and how to clear formatting when you need a fresh start. 

You’ll learn practical techniques for building polished, easy-to-read worksheets that present your data clearly. You’ll see how Format Painter can dramatically speed up your workflow by copying and pasting formatting with just a click. By the end of this course, you’ll have the skills to transform basic spreadsheets into professional, visually consistent documents suited for everyday business use. 

Topics covered include: 

• Modifying the Horizontal and Vertical Alignment of a cell or range  

• Modifying Text Orientation for a cell or range  

• Wrapping text in a cell  

• Indenting text in a cell  

• Merging and unmerging cells  

• Applying borders to tables and cells  

• Applying shading to cells  

• Applying standard number and date formats using the Ribbon  

• Using the Format Cells dialog box to apply number formats  

• Describing how Excel applies formatting to the cell  

• Clearing all formatting from a cell  

• Using the Format Painter to copy and paste formatting 

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.