Lynda Excel 2016 Tips and Tricks | 8E6F04F2EDB20CA10969EB69944BAA8262CE1C75

Lynda Excel 2016 Tips and Tricks

Name	Lynda - Excel 2016 Tips and Tricks	DOWNLOAD Copy Link
Total Size	1.3 GB
Total Files	71
Hash	8E6F04F2EDB20CA10969EB69944BAA8262CE1C75

/01. Introduction/
01_01-Welcome.mp4	5.1 MB
01_02-Using the exercise files.mp4	968.7 KB
/02. Top 10 Shortcuts/
02_10-Zoom in and out quickly.mp4	20.1 MB
02_05-Adjust all or selected column widths or row heights in a flash.mp4	19.4 MB
02_04-Convert formulas to values with a simple drag.mp4	15.8 MB
02_06-Display all worksheet formulas instantly.mp4	11.5 MB
02_09-Undo, redo, and repeat with keystrokes.mp4	11.1 MB
02_08-Display Print Preview instantly.mp4	10.9 MB
02_03-Instantly enter todays date or time.mp4	8.8 MB
02_02-Copy data or formulas down a column instantly.mp4	8.8 MB
02_01-Enter data or formulas in nonadjacent cells simultaneously.mp4	8.7 MB
02_07-Create charts instantly with either of these keystroke shortcuts.mp4	8.1 MB
/03. Ribbon and Quick Access Toolbar Tips/
03_03-Adjust the Quick Access Toolbar.mp4	22.6 MB
03_01-Expandcollapse ribbon and fullscreen views.mp4	11.3 MB
03_02-Access ribbon commands with Alt key sequences.mp4	11.3 MB
/04. Display Shortcuts/
04_01-Create split screens and frozen titles in a flash.mp4	44.0 MB
04_02-Restore missing labels and hide repeating labels.mp4	31.9 MB
04_03-Customize the display of status bar totals.mp4	19.6 MB
/05. Navigation Shortcuts/
05_03-Navigate within worksheets.mp4	34.4 MB
05_04-Open, close, save, and create new workbooks with keystrokes.mp4	18.6 MB
05_02-Navigate between worksheets efficiently.mp4	17.4 MB
05_01-Navigate between workbooks efficiently.mp4	11.0 MB
/06. Selection Shortcuts/
06_02-Select noncontiguous ranges and visible cells only.mp4	33.3 MB
06_01-Select entire row, column, region, or worksheet.mp4	30.6 MB
/07. Data Entry and Editing Shortcuts/
07_04-Use custom lists for rapid data entry and listbased sorting.mp4	38.2 MB
07_02-Enter dates and date series efficiently.mp4	24.9 MB
07_01-Accelerate data entry.mp4	24.5 MB
07_05-Enhance editing tools.mp4	13.0 MB
07_03-Enter times and time series efficiently.mp4	9.2 MB
/08. Drag and Drop Techniques/
08_05-Accelerate CopyMovePaste actions with the right mouse button.mp4	24.1 MB
08_04-Display Paste Special options instantly.mp4	21.3 MB
08_01-Accelerate copy and move tasks.mp4	17.4 MB
08_02-Accelerate worksheet copying and moving.mp4	12.4 MB
08_03-Drag and insert cells with the Shift key.mp4	10.1 MB
/09. Formula Shortcuts/
09_01-Create formulas rapidly.mp4	20.6 MB
09_02-Select all cells that depend on the active cell.mp4	20.1 MB
09_07-Count the number of unique entries.mp4	19.2 MB
09_06-Generate random numbers.mp4	18.0 MB
09_03-Select all cells that can affect the active cell.mp4	16.0 MB
09_05-Use rounding shortcuts.mp4	14.6 MB
09_04-Use AutoSum shortcuts.mp4	10.4 MB
09_08-Perform calculations without formulas.mp4	9.2 MB
/10. Operational Shortcuts/
10_04-Collapse and expand detail quickly with outlining shortcuts.mp4	42.6 MB
10_01-Insert, delete, hide, and unhide columns and rows rapidly.mp4	24.7 MB
10_03-Select and manipulate blank cells.mp4	24.4 MB
10_02-Realign imported text.mp4	16.8 MB
10_05-Create doublespaced or triplespaced printouts quickly.mp4	10.6 MB
/11. Formatting Shortcuts/
11_03-Add a color background to every 5th row in a range.mp4	26.3 MB
11_06-Create custom formats Dot leaders and more.mp4	21.6 MB
11_02-Accentuate data with alignment tools.mp4	21.2 MB
11_04-Use conditional formatting based on comparison criteria.mp4	20.8 MB
11_01-Use keystroke shortcuts for frequently needed numeric formats.mp4	16.9 MB
11_07-Use special formats for times over 24 hours.mp4	16.9 MB
11_08-Addremove strikethrough and borders with keystroke shortcuts.mp4	13.1 MB
11_09-Quickly format phone and SS numbers.mp4	12.4 MB
11_05-Use conditional formatting to highlight formula cells only.mp4	9.0 MB
/12. Data Management Techniques/
12_03-Identify and eliminate duplicates.mp4	27.1 MB
12_08-Display unique items from large lists.mp4	25.6 MB
12_01-Sort data with single buttons.mp4	19.3 MB
12_02-Clean up spaces quickly with the TRIM function.mp4	18.4 MB
12_04-Split column data using Text to Columns and Flash Fill.mp4	16.9 MB
12_05-Join data with the TEXTJOIN function and Flash Fill.mp4	14.4 MB
12_06-Ensure unique entries with data validation rules.mp4	12.9 MB
12_07-Force typed dates to be weekdays only with data validation rules.mp4	12.0 MB
/13. Charting and Visual Object Tips/
13_04-Create linked dynamic and linked static images.mp4	29.3 MB
13_03-Create and manipulate shapes with the Shift, Ctrl, and Alt keys.mp4	18.9 MB
13_01-Manipulate chart placement with dragging techniques.mp4	10.7 MB
13_02-Create chart titles from cell content.mp4	8.0 MB
/14. Ten Tiny Tips/
14_01-Become a more proficient Excel user with these short tips.mp4	24.0 MB
/15. Conclusion/
15_01-Goodbye.mp4	2.1 MB
/Exercice Files/
Ex_Files_Excel_2016_Tips.zip	2.2 MB
Total files 71