English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 44m | 346 MB
View simple, powerful tips for making Excel data more readable and easier to manipulate. Author Dennis Taylor shows you how to emphasize individual cells with fonts, borders, and colors; adjust the position of cell contents; format numeric data; and increase the readability of worksheets. You can also learn how to add images to worksheets and discover automation techniques that can take the drudgery out of formatting even large amounts of data.
Topics include:
- Working with alignment tools
- Adjusting numeric formats
- Tables, styles, and themes
- Row, column, and sheet adjustments
- Worksheet formatting tools
- Displaying data as an outline
- Adding and formatting images
- Power formatting techniques
Table of Contents
1 Harness the power of Excel formatting techniques
2 Create angled text variations for variety and readability
3 Indent data and dollar signs
4 Use the Merge and Center button to simplify title adjustments
5 Use Wrap Text and Shrink to Fit to control titles and headings
6 Build custom numeric formats
7 Create custom date formats
8 Work with tables
9 Use styles and themes for consistent formatting
10 Work with rows, columns, and sheets
11 Use the Hide & Unhide options
12 Use the Format Cells dialog box and formatting part of a cell
13 Format text from Word or the web with the Justify feature
14 Add a background image to a worksheet
15 Set up data for outlines
16 Use the Subtotal feature to create outlines
17 Format picture styles
18 Add borders and effects to pictures
19 Format Sparklines for visual impact
20 Use WordArt for formatted titles and headings
21 Hide repeating titles in a column to clarify printed output
22 Restore missing title data in a column
23 Display large values without using formulas
24 Create picture links
25 Format column and row titles
26 Format a list for double-spaced printing
27 Next steps
Resolve the captcha to access the links!