Download link
File List
-
01. Introduction/01_01-Welcome.mp4 4.9 MB
01. Introduction/01_02-Using the exercise files.mp4 945.96 KB
02. Top 10 Shortcuts/02_10-Zoom in and out quickly.mp4 19.15 MB
02. Top 10 Shortcuts/02_05-Adjust all or selected column widths or row heights in a flash.mp4 18.46 MB
02. Top 10 Shortcuts/02_04-Convert formulas to values with a simple drag.mp4 15.04 MB
02. Top 10 Shortcuts/02_06-Display all worksheet formulas instantly.mp4 10.98 MB
02. Top 10 Shortcuts/02_09-Undo, redo, and repeat with keystrokes.mp4 10.58 MB
02. Top 10 Shortcuts/02_08-Display Print Preview instantly.mp4 10.39 MB
02. Top 10 Shortcuts/02_03-Instantly enter todays date or time.mp4 8.42 MB
02. Top 10 Shortcuts/02_02-Copy data or formulas down a column instantly.mp4 8.41 MB
02. Top 10 Shortcuts/02_01-Enter data or formulas in nonadjacent cells simultaneously.mp4 8.34 MB
02. Top 10 Shortcuts/02_07-Create charts instantly with either of these keystroke shortcuts.mp4 7.68 MB
03. Ribbon and Quick Access Toolbar Tips/03_03-Adjust the Quick Access Toolbar.mp4 21.56 MB
03. Ribbon and Quick Access Toolbar Tips/03_01-Expandcollapse ribbon and fullscreen views.mp4 10.81 MB
03. Ribbon and Quick Access Toolbar Tips/03_02-Access ribbon commands with Alt key sequences.mp4 10.8 MB
04. Display Shortcuts/04_01-Create split screens and frozen titles in a flash.mp4 41.99 MB
04. Display Shortcuts/04_02-Restore missing labels and hide repeating labels.mp4 30.4 MB
04. Display Shortcuts/04_03-Customize the display of status bar totals.mp4 18.67 MB
05. Navigation Shortcuts/05_03-Navigate within worksheets.mp4 32.8 MB
05. Navigation Shortcuts/05_04-Open, close, save, and create new workbooks with keystrokes.mp4 17.76 MB
05. Navigation Shortcuts/05_02-Navigate between worksheets efficiently.mp4 16.58 MB
05. Navigation Shortcuts/05_01-Navigate between workbooks efficiently.mp4 10.52 MB
06. Selection Shortcuts/06_02-Select noncontiguous ranges and visible cells only.mp4 31.78 MB
06. Selection Shortcuts/06_01-Select entire row, column, region, or worksheet.mp4 29.14 MB
07. Data Entry and Editing Shortcuts/07_04-Use custom lists for rapid data entry and listbased sorting.mp4 36.4 MB
07. Data Entry and Editing Shortcuts/07_02-Enter dates and date series efficiently.mp4 23.78 MB
07. Data Entry and Editing Shortcuts/07_01-Accelerate data entry.mp4 23.38 MB
07. Data Entry and Editing Shortcuts/07_05-Enhance editing tools.mp4 12.42 MB
07. Data Entry and Editing Shortcuts/07_03-Enter times and time series efficiently.mp4 8.78 MB
08. Drag and Drop Techniques/08_05-Accelerate CopyMovePaste actions with the right mouse button.mp4 23 MB
08. Drag and Drop Techniques/08_04-Display Paste Special options instantly.mp4 20.29 MB
08. Drag and Drop Techniques/08_01-Accelerate copy and move tasks.mp4 16.58 MB
08. Drag and Drop Techniques/08_02-Accelerate worksheet copying and moving.mp4 11.84 MB
08. Drag and Drop Techniques/08_03-Drag and insert cells with the Shift key.mp4 9.68 MB
09. Formula Shortcuts/09_01-Create formulas rapidly.mp4 19.66 MB
09. Formula Shortcuts/09_02-Select all cells that depend on the active cell.mp4 19.14 MB
09. Formula Shortcuts/09_07-Count the number of unique entries.mp4 18.27 MB
09. Formula Shortcuts/09_06-Generate random numbers.mp4 17.13 MB
09. Formula Shortcuts/09_03-Select all cells that can affect the active cell.mp4 15.22 MB
09. Formula Shortcuts/09_05-Use rounding shortcuts.mp4 13.96 MB
09. Formula Shortcuts/09_04-Use AutoSum shortcuts.mp4 9.95 MB
09. Formula Shortcuts/09_08-Perform calculations without formulas.mp4 8.77 MB
10. Operational Shortcuts/10_04-Collapse and expand detail quickly with outlining shortcuts.mp4 40.67 MB
10. Operational Shortcuts/10_01-Insert, delete, hide, and unhide columns and rows rapidly.mp4 23.59 MB
10. Operational Shortcuts/10_03-Select and manipulate blank cells.mp4 23.3 MB
10. Operational Shortcuts/10_02-Realign imported text.mp4 15.99 MB
10. Operational Shortcuts/10_05-Create doublespaced or triplespaced printouts quickly.mp4 10.14 MB
11. Formatting Shortcuts/11_03-Add a color background to every 5th row in a range.mp4 25.04 MB
11. Formatting Shortcuts/11_06-Create custom formats Dot leaders and more.mp4 20.58 MB
11. Formatting Shortcuts/11_02-Accentuate data with alignment tools.mp4 20.23 MB
11. Formatting Shortcuts/11_04-Use conditional formatting based on comparison criteria.mp4 19.83 MB
11. Formatting Shortcuts/11_01-Use keystroke shortcuts for frequently needed numeric formats.mp4 16.1 MB
11. Formatting Shortcuts/11_07-Use special formats for times over 24 hours.mp4 16.09 MB
11. Formatting Shortcuts/11_08-Addremove strikethrough and borders with keystroke shortcuts.mp4 12.53 MB
11. Formatting Shortcuts/11_09-Quickly format phone and SS numbers.mp4 11.85 MB
11. Formatting Shortcuts/11_05-Use conditional formatting to highlight formula cells only.mp4 8.54 MB
12. Data Management Techniques/12_03-Identify and eliminate duplicates.mp4 25.87 MB
12. Data Management Techniques/12_08-Display unique items from large lists.mp4 24.37 MB
12. Data Management Techniques/12_01-Sort data with single buttons.mp4 18.36 MB
12. Data Management Techniques/12_02-Clean up spaces quickly with the TRIM function.mp4 17.53 MB
12. Data Management Techniques/12_04-Split column data using Text to Columns and Flash Fill.mp4 16.11 MB
12. Data Management Techniques/12_05-Join data with the TEXTJOIN function and Flash Fill.mp4 13.7 MB
12. Data Management Techniques/12_06-Ensure unique entries with data validation rules.mp4 12.26 MB
12. Data Management Techniques/12_07-Force typed dates to be weekdays only with data validation rules.mp4 11.41 MB
13. Charting and Visual Object Tips/13_04-Create linked dynamic and linked static images.mp4 27.97 MB
13. Charting and Visual Object Tips/13_03-Create and manipulate shapes with the Shift, Ctrl, and Alt keys.mp4 18.01 MB
13. Charting and Visual Object Tips/13_01-Manipulate chart placement with dragging techniques.mp4 10.22 MB
13. Charting and Visual Object Tips/13_02-Create chart titles from cell content.mp4 7.64 MB
14. Ten Tiny Tips/14_01-Become a more proficient Excel user with these short tips.mp4 22.9 MB
15. Conclusion/15_01-Goodbye.mp4 2.03 MB
Exercice Files/Ex_Files_Excel_2016_Tips.zip 2.14 MB
Download Info
-
Tips
“Lynda - Excel 2016 Tips and Tricks” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.