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

0. Introduction

01 - Advanced formatting in Excel

1. Formatting and Aligning Text

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

2. Formatting Numbers and Dates

07 - Dates and custom formatting
08 - Make consistent entries with Find and Replace
09 - Positive and negative numbers
10 - Format hours, minutes, and seconds
11 - M for millions and K for thousands
12 - Format numbers with Power Query

3. Working with Images and Shapes

13 - Group and align shapes
14 - Transform text into shapes with WordArt
15 - Place text inside a shape

4. Conditional Formatting

16 - Conditional formatting for duplicates
17 - Highlight fast-approaching dates
18 - Conditional formatting for icons
19 - Conditional formatting for strikethrough fonts

5. Formatting for Print

20 - Page numbers and page breaks
21 - Print preview
22 - Format your worksheets to control what gets printed

6. Workbooks and Worksheets

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

7. Tables, Slicers, Themes

25 - Format tables
26 - Format slicers
27 - Apply workbook themes and styles

8. Charts and Graphs

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

9. Advanced, Random, and Fascinating Formatting

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

Conclusion

35 - Getting the most from Excel