种子简介

种子名称： Lynda - Excel 2016 Tips and Tricks
文件类型：
文件数目： 70个文件
文件大小： 1.17 GB
收录时间： 2016-7-8 14:42
已经下载： 3次
资源热度： 127
最近下载： 2024-9-17 11:12

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:8e6f04f2edb20ca10969eb69944baa8262ce1c75&dn=Lynda - Excel 2016 Tips and Tricks 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Lynda - Excel 2016 Tips and Tricks.torrent

01. Introduction/01_01-Welcome.mp44.9MB

01. Introduction/01_02-Using the exercise files.mp4945.96KB

02. Top 10 Shortcuts/02_10-Zoom in and out quickly.mp419.15MB

02. Top 10 Shortcuts/02_05-Adjust all or selected column widths or row heights in a flash.mp418.46MB

02. Top 10 Shortcuts/02_04-Convert formulas to values with a simple drag.mp415.04MB

02. Top 10 Shortcuts/02_06-Display all worksheet formulas instantly.mp410.98MB

02. Top 10 Shortcuts/02_09-Undo, redo, and repeat with keystrokes.mp410.58MB

02. Top 10 Shortcuts/02_08-Display Print Preview instantly.mp410.39MB

02. Top 10 Shortcuts/02_03-Instantly enter todays date or time.mp48.42MB

02. Top 10 Shortcuts/02_02-Copy data or formulas down a column instantly.mp48.41MB

02. Top 10 Shortcuts/02_01-Enter data or formulas in nonadjacent cells simultaneously.mp48.34MB

02. Top 10 Shortcuts/02_07-Create charts instantly with either of these keystroke shortcuts.mp47.68MB

03. Ribbon and Quick Access Toolbar Tips/03_03-Adjust the Quick Access Toolbar.mp421.56MB

03. Ribbon and Quick Access Toolbar Tips/03_01-Expandcollapse ribbon and fullscreen views.mp410.81MB

03. Ribbon and Quick Access Toolbar Tips/03_02-Access ribbon commands with Alt key sequences.mp410.8MB

04. Display Shortcuts/04_01-Create split screens and frozen titles in a flash.mp441.99MB

04. Display Shortcuts/04_02-Restore missing labels and hide repeating labels.mp430.4MB

04. Display Shortcuts/04_03-Customize the display of status bar totals.mp418.67MB

05. Navigation Shortcuts/05_03-Navigate within worksheets.mp432.8MB

05. Navigation Shortcuts/05_04-Open, close, save, and create new workbooks with keystrokes.mp417.76MB

05. Navigation Shortcuts/05_02-Navigate between worksheets efficiently.mp416.58MB

05. Navigation Shortcuts/05_01-Navigate between workbooks efficiently.mp410.52MB

06. Selection Shortcuts/06_02-Select noncontiguous ranges and visible cells only.mp431.78MB

06. Selection Shortcuts/06_01-Select entire row, column, region, or worksheet.mp429.14MB

07. Data Entry and Editing Shortcuts/07_04-Use custom lists for rapid data entry and listbased sorting.mp436.4MB

07. Data Entry and Editing Shortcuts/07_02-Enter dates and date series efficiently.mp423.78MB

07. Data Entry and Editing Shortcuts/07_01-Accelerate data entry.mp423.38MB

07. Data Entry and Editing Shortcuts/07_05-Enhance editing tools.mp412.42MB

07. Data Entry and Editing Shortcuts/07_03-Enter times and time series efficiently.mp48.78MB

08. Drag and Drop Techniques/08_05-Accelerate CopyMovePaste actions with the right mouse button.mp423MB

08. Drag and Drop Techniques/08_04-Display Paste Special options instantly.mp420.29MB

08. Drag and Drop Techniques/08_01-Accelerate copy and move tasks.mp416.58MB

08. Drag and Drop Techniques/08_02-Accelerate worksheet copying and moving.mp411.84MB

08. Drag and Drop Techniques/08_03-Drag and insert cells with the Shift key.mp49.68MB

09. Formula Shortcuts/09_01-Create formulas rapidly.mp419.66MB

09. Formula Shortcuts/09_02-Select all cells that depend on the active cell.mp419.14MB

09. Formula Shortcuts/09_07-Count the number of unique entries.mp418.27MB

09. Formula Shortcuts/09_06-Generate random numbers.mp417.13MB

09. Formula Shortcuts/09_03-Select all cells that can affect the active cell.mp415.22MB

09. Formula Shortcuts/09_05-Use rounding shortcuts.mp413.96MB

09. Formula Shortcuts/09_04-Use AutoSum shortcuts.mp49.95MB

09. Formula Shortcuts/09_08-Perform calculations without formulas.mp48.77MB

10. Operational Shortcuts/10_04-Collapse and expand detail quickly with outlining shortcuts.mp440.67MB

10. Operational Shortcuts/10_01-Insert, delete, hide, and unhide columns and rows rapidly.mp423.59MB

10. Operational Shortcuts/10_03-Select and manipulate blank cells.mp423.3MB

10. Operational Shortcuts/10_02-Realign imported text.mp415.99MB

10. Operational Shortcuts/10_05-Create doublespaced or triplespaced printouts quickly.mp410.14MB

11. Formatting Shortcuts/11_03-Add a color background to every 5th row in a range.mp425.04MB

11. Formatting Shortcuts/11_06-Create custom formats Dot leaders and more.mp420.58MB

11. Formatting Shortcuts/11_02-Accentuate data with alignment tools.mp420.23MB

11. Formatting Shortcuts/11_04-Use conditional formatting based on comparison criteria.mp419.83MB

11. Formatting Shortcuts/11_01-Use keystroke shortcuts for frequently needed numeric formats.mp416.1MB

11. Formatting Shortcuts/11_07-Use special formats for times over 24 hours.mp416.09MB

11. Formatting Shortcuts/11_08-Addremove strikethrough and borders with keystroke shortcuts.mp412.53MB

11. Formatting Shortcuts/11_09-Quickly format phone and SS numbers.mp411.85MB

11. Formatting Shortcuts/11_05-Use conditional formatting to highlight formula cells only.mp48.54MB

12. Data Management Techniques/12_03-Identify and eliminate duplicates.mp425.87MB

12. Data Management Techniques/12_08-Display unique items from large lists.mp424.37MB

12. Data Management Techniques/12_01-Sort data with single buttons.mp418.36MB

12. Data Management Techniques/12_02-Clean up spaces quickly with the TRIM function.mp417.53MB

12. Data Management Techniques/12_04-Split column data using Text to Columns and Flash Fill.mp416.11MB

12. Data Management Techniques/12_05-Join data with the TEXTJOIN function and Flash Fill.mp413.7MB

12. Data Management Techniques/12_06-Ensure unique entries with data validation rules.mp412.26MB

12. Data Management Techniques/12_07-Force typed dates to be weekdays only with data validation rules.mp411.41MB

13. Charting and Visual Object Tips/13_04-Create linked dynamic and linked static images.mp427.97MB

13. Charting and Visual Object Tips/13_03-Create and manipulate shapes with the Shift, Ctrl, and Alt keys.mp418.01MB

13. Charting and Visual Object Tips/13_01-Manipulate chart placement with dragging techniques.mp410.22MB

13. Charting and Visual Object Tips/13_02-Create chart titles from cell content.mp47.64MB

14. Ten Tiny Tips/14_01-Become a more proficient Excel user with these short tips.mp422.9MB

15. Conclusion/15_01-Goodbye.mp42.03MB