2013
Lynda
Dennis Taylor
2h 58m
English
Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover automation techniques that take the drudgery out of formatting even the largest amounts of data.
Introduction
1m 17s
Welcome
51s
Using the exercise files
26s
1. Controlling Fonts, Borders, and Cell Color
15m 39s
Adjusting fonts, font sizes, and font colors
4m 39s
Applying underline, strikethrough, subscript, and superscript formatting
3m 48s
Applying border styles and adjusting gridlines
3m 56s
Using fill color and patterns for cell backgrounds
3m 16s
2. Alignment Tools
17m 3s
Adjusting horizontal and vertical cell alignment
4m 9s
Creating angled text variations for greater variety and readability
2m 40s
Indenting data and dollar signs
1m 44s
Simplifying title adjustments with the Merge & Center button
3m 23s
Controlling titles and headings with the Wrap Text and Shrink to Fit options
5m 7s
3. Adjusting Numeric Formats Quickly
28m 25s
Working with numeric formatting options
6m 21s
Essential numeric formatting keystroke shortcuts
5m 34s
Setting special formats for dates, times, phone numbers, ZIP codes, etc.
4m 53s
Building custom numeric formats
5m 53s
Building custom date formats
5m 44s
4. Accentuating Dynamic Data with Conditional Formatting
22m 50s
Creating value-based formatting using logical operators
3m 17s
Creating value-based formatting using data bars, color scales, and icons
7m 39s
Creating formats based on formulas
6m 15s
Conditional formatting in PivotTables
5m 39s
5. Tables, Styles, and Themes
14m 6s
Working with tables
8m 34s
Using styles and themes for consistent formatting
5m 32s
6. Row, Column, and Sheet Adjustments
17m 43s
Adjusting single and multiple row heights and column widths without commands
5m 12s
Working with rows, columns, and sheets
6m 9s
Working with the Hide and Unhide options
6m 22s
7. Other Worksheet Formatting Tools
12m 49s
Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar
2m 47s
Applying different formatting styles within the same cell
2m 45s
Copying formats quickly with dragging techniques and the Format Painter
4m 14s
Formatting text from Word or the web with the Justify feature
3m 3s
8. Displaying Data as an Outline
10m 55s
Setting up data for outlining
7m 15s
Using outlining symbols and levels
3m 40s
9. Adding Pictures
16m 1s
Formatting picture styles
3m 12s
Adding borders and effects to pictures
4m 7s
Formatting sparklines for optimum impact
6m 15s
Using WordArt for formatted titles and headings
2m 27s
10. Specialized Power Formatting Techniques
21m 35s
Hiding repeating titles in a column to clarify printed output
2m 23s
Restoring missing title data in a column
4m 3s
Displaying large values without using formulas
3m 37s
Creating linked worksheet images
7m 37s
Formatting column and row titles
2m 1s
Formatting a list for double-spaced printing
1m 54s
Conclusion
29s
Goodbye
29s
www.lynda.com/Excel-tutorials/Excel-2013-Advanced-Formatting-Techniques/144858-2.html
Download File Size:532.51 MB
|
