Excel: Advanced Formatting Techniques

Course details

Formatting is not just font colors and pretty graphs. Get simple, powerful tips for making Excel data more readable and understandable in this advanced formatting course from Excel MVP Oz du Soleil. Oz begins with formatting and aligning text, numbers, and dates. Next, he shows how to work with images and shapes. Oz covers advanced features in the conditional formatting menu, and shows how to optimize spreadsheets for print. He also covers formatting tips for tables, slicers, charts, and graphs. Oz concludes with an assortment of interesting, and useful formatting features in Excel. This course not only shows how to make data more readable, it also shows ways to customize your work environment inside Excel to make it more pleasant to work in.

Concepts

Introduction

Advanced formatting in Excel

Formatting and Aligning Text

Subscript, underline, and strikethrough text
Center across a selection vs. merged cells
Create angled text for readability and organization
Indent cell contents and add new lines within a cell
Insert symbols - Bullet points, stars, and Fran ois

Formatting Numbers and Dates

Dates and custom formatting
Make consistent entries with Find and Replace
Positive and negative numbers
Format hours, minutes, and seconds
M for millions and K for thousands
Format numbers with Power Query

Working with Images and Shapes

Group and align shapes
Transform text into shapes with WordArt
Place text inside a shape

Conditional Formatting

Conditional formatting for duplicates
Highlight fast-approaching dates
Conditional formatting for icons
Conditional formatting for strikethrough fonts

Formatting for Print

Page numbers and page breaks
Print preview
Format your worksheets to control what gets printed

Workbooks and Worksheets

Format multiple sheets at once
Set workbook defaults to open with your preferences

Tables, Slicers, Themes

Format tables
Format slicers
Apply workbook themes and styles

Charts and Graphs

Grid lines, legends, and other chart formatting
3D, shadows, and other advanced chart formatting

Advanced, Random, and Fascinating Formatting

Install and uninstall fonts
Format your worksheet's background with an image
Manage hyperlinks
Color-picker and RGB code for colors
Clear Formatting

Conclusion

Getting the most from Excel