Excel 2013: Advanced Formatting Techniques Год выпуска: 2013 Производитель: Lynda Сайт производителя: www.lynda.com/Excel-tutorials/Excel-2013-Advanced-Formatting-Techniques/144858-2.html Автор: Dennis Taylor Продолжительность: 2h 58m Тип раздаваемого материала: Видеоурок Язык: Английский Описание: 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.-Получить простые и мощные средства советы для принятия решений информацию из таблицы легко читаемым и понятным в приложении Excel 2013. Деннис Тейлор показывает, как подчеркнуть конкретные ячейки со шрифтами, границы и цвет; отрегулируйте расположение содержимого ячейки; формат числовых данных; и добавить стиль и читаемость для листов. Вы также узнаете о том, как добавить снимки на рабочих листов и откройте для себя методам автоматизации, ставшего из форматирование даже самых больших объемов данных.
Содержание
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}