Excel 2016 Tips and Tricks Год выпуска: 04/2016 Производитель: Lynda Сайт производителя: lynda.com/Excel-tutorials/Excel-2016-Tips-Tricks/431183-2.html Автор: Dennis Taylor Продолжительность: 5:52 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Excel expert Dennis Taylor helps Excel 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly. The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "10 Tiny Tips" chapter for a quick productivity boost. Эксперт по Excel Деннис Тейлор помогает пользователям Excel 2016 взять свои навыки электронные таблицы на следующий уровень с этой коллекцией советы и рекомендации. Он начинается с его топ-10 ускорители производительности, и подсвечивает навигации, отображения и методы отбора, чтобы держать вас двигаться быстро. Затем курс погружений на ввод данных и методов редактирования, форматирования и перетаскивания приемы, сочетания клавиш для работы с формулами, стратегии управления данными, приемы и диаграммы. Короткий по времени? Убедитесь, чтобы проверить "10 крошечных Советов" главу для быстрого повышения производительности.
Содержание
Introduction 54s Welcome 37s Using the exercise files 17s 1. Top 10 Shortcuts 35m 18s Enter data or formulas in nonadjacent cells simultaneously 3m 17s Copy data or formulas down a column instantly 2m 49s Instantly enter today's date or time 3m 20s Convert formulas to values with a simple drag 5m 4s Adjust all or selected column widths or row heights in a flash 4m 43s Display all worksheet formulas instantly 3m 30s Create charts instantly with either of these keystroke shortcuts 2m 54s Display Print Preview instantly 2m 25s Undo, redo, and repeat with keystrokes 3m 53s Zoom in and out quickly 3m 23s 2. Ribbon and Quick Access Toolbar Tips 13m 50s Expand/collapse ribbon and fullscreen views 2m 43s Access ribbon commands with Alt key sequences 3m 36s Adjust the Quick Access Toolbar 7m 31s 3. Display Shortcuts 22m 42s Create split screens and frozen titles in a flash 8m 34s Restore missing labels and hide repeating labels 8m 46s Customize the display of status bar totals 5m 22s 4. Navigation Shortcuts 21m 52s Navigate between workbooks efficiently 3m 37s Navigate between worksheets efficiently 5m 15s Navigate within worksheets 7m 10s Open, close, save, and create new workbooks with keystrokes 5m 50s 5. Selection Shortcuts 15m 24s Select entire row, column, region, or worksheet 6m 58s Select noncontiguous ranges and visible cells only 8m 26s 6. Data Entry and Editing Shortcuts 33m 47s Accelerate data entry 9m 54s Enter dates and date series efficiently 7m 40s Enter times and time series efficiently 3m 15s Use custom lists for rapid data entry and list-based sorting 9m 18s Enhance editing tools 3m 40s 7. Drag and Drop Techniques 25m 29s Accelerate copy and move tasks 5m 46s Accelerate worksheet copying and moving 4m 12s Drag and insert cells with the Shift key 2m 49s Display Paste Special options instantly 5m 46s Accelerate Copy/Move/Paste actions with the right mouse button 6m 56s 8. Formula Shortcuts 38m 26s Create formulas rapidly 6m 26s Select all cells that depend on the active cell 5m 9s Select all cells that can affect the active cell 4m 9s Use AutoSum shortcuts 3m 53s Use rounding shortcuts 5m 30s Generate random numbers 5m 3s Count the number of unique entries 5m 14s Perform calculations without formulas 3m 2s 9. Operational Shortcuts 30m 5s Insert, delete, hide, and unhide columns and rows rapidly 5m 0s Re-align imported text 5m 44s Select and manipulate blank cells 6m 30s Collapse and expand detail quickly with outlining shortcuts 9m 58s Create double-spaced or triple-spaced printouts quickly 2m 53s 10. Formatting Shortcuts 43m 56s Use keystroke shortcuts for frequently needed numeric formats 6m 29s Accentuate data with alignment tools 6m 2s Add a color background to every 5th row in a range 5m 40s Use conditional formatting based on comparison criteria 5m 13s Use conditional formatting to highlight formula cells only 2m 54s Create custom formats: Dot leaders and more 6m 1s Use special formats for times over 24 hours 4m 9s Add/remove strikethrough and borders with keystroke shortcuts 3m 34s Quickly format phone and SS numbers 3m 54s 11. Data Management Techniques 40m 51s Sort data with single buttons 4m 34s Clean up spaces quickly with the TRIM function 4m 37s Identify and eliminate duplicates 6m 21s Split column data using Text to Columns and Flash Fill 5m 26s Join data with the TEXTJOIN function and Flash Fill 4m 46s Ensure unique entries with data validation rules 5m 19s Force typed dates to be weekdays only with data validation rules 4m 31s Display unique items from large lists 5m 17s 12. Charting and Visual Object Tips 21m 34s Manipulate chart placement with dragging techniques 3m 44s Create chart titles from cell content 2m 48s Create and manipulate shapes with the Shift, Ctrl, and Alt keys 7m 20s Create linked dynamic and linked static images 7m 42s 13. Ten Tiny Tips 7m 22s Become a more proficient Excel user with these short tips 7m 22s Conclusion 33s Goodbye 33s
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}