Excel: Advanced Formatting Techniques

Introduction

• Advanced formatting in Excel

1. 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

2. 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

3. Working with Images and Shapes

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

4. Conditional Formatting

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

5. Formatting for Print

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

6. Workbooks and Worksheets

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

7. Tables, Slicers, Themes

• Format tables
• Format slicers
• Apply workbook themes and styles

8. Charts and Graphs

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

9. 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