Lynda - Excel 2013 Tips and Tricks
- Type:
- Other > Other
- Files:
- 83
- Size:
- 779.66 MiB (817534539 Bytes)
- Tag(s):
- Business
- Uploaded:
- 2016-01-17 08:17:30 GMT
- By:
-
2boweb
- Seeders:
- 0
- Leechers:
- 1
- Comments
- 0
- Info Hash: 1DB540947CA649CE839FE4CDF42FE1B0A383D71D
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Excel 2013 Tips and Tricks This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. 4h 34m Appropriate for all Jul 16, 2014 | Uploaded in Jan 16, 2016 by 2boweb Subject: Business Software: Excel Office Author: Dennis Taylor Increase your Excel productivity with the power user tips and tricks packed into this fast-paced course. Dennis Taylor will show you how to create formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data-entry chores. Short on time? Make sure to check out the "Top Ten Shortcuts" and "Ten Tiny Tips" chapters for a quick productivity boost. Start now and get an immediate return on your investment, with powerful techniques that will save you hours every week. Topics include: • Converting formulas to values with a simple drag • Entering today's date or time instantly • Accessing Ribbon commands from the keyboard • Creating split screens fast • Navigating quickly • Entering data more efficiently • Performing calculations without formulas • Applying formatting with keyboard shortcuts • Using database techniques to work with Excel data ////////////////////////////////////////////////////////////////////
| Create split screens and frozen titles in a flash-182283.mp4 | 26.66 MiB |
| Create linked dynamic and static images-182343.mp4 | 26.55 MiB |
| Select noncontiguous ranges and visible cells only-182292.mp4 | 24.58 MiB |
| Select the current region of cells and move around region corners-182293.mp4 | 22.31 MiB |
| Use Custom Lists for rapid data entry and list-based sorting-182298.mp4 | 20.98 MiB |
| Navigate within worksheets-182289.mp4 | 20.67 MiB |
| Restore missing labels and hide repeating labels-182284.mp4 | 20.51 MiB |
| Insert, delete, hide, and unhide columns and rows rapidly-182316.mp4 | 19.91 MiB |
| Add a color background to every fifth row in a range-182324.mp4 | 19.74 MiB |
| Select an entire row, column, or worksheet-182291.mp4 | 19.4 MiB |
| Become more proficient with these short tips-182345.mp4 | 17.96 MiB |
| Clean up spaces quickly-182332.mp4 | 17.31 MiB |
| Collapse and expand detail quickly with outlining shortcuts-182319.mp4 | 17.21 MiB |
| Accelerate data entry-182295.mp4 | 16.14 MiB |
| Enter dates and date series efficiently-182296.mp4 | 15.91 MiB |
| Use keystroke shortcuts for frequently needed numeric formats-182322.mp4 | 14.82 MiB |
| Select and manipulate blank cells-182318.mp4 | 13.93 MiB |
| Create custom formats - Dot leaders and more-182327.mp4 | 13.89 MiB |
| Add and remove a strikethrough or a border with keystroke shortcuts-182329.mp4 | 13.6 MiB |
| Count the number of unique entries-182313.mp4 | 13.48 MiB |
| Create formulas rapidly-182307.mp4 | 13.41 MiB |
| Accelerate Copy, Move, and Paste actions with the right mouse button-182305.mp4 | 12.82 MiB |
| Select all cells that can affect the active cell-182309.mp4 | 12.42 MiB |
| Split column data into multiple columns with Flash Fill-182334.mp4 | 12.32 MiB |
| Accentuate date with alignment tools-182323.mp4 | 12.21 MiB |
| Navigate between worksheets efficiently-182288.mp4 | 11.84 MiB |
| Generate random numbers-182312.mp4 | 11.63 MiB |
| Accelerate worksheet copying and moving-182302.mp4 | 11.34 MiB |
| Identify and eliminate duplicates-182333.mp4 | 11.26 MiB |
| Accelerate copy-and-move tasks-182301.mp4 | 10.98 MiB |
| Create and manipulate shapes and use Shift and Ctrl keys-182342.mp4 | 10.87 MiB |
| Display Paste Special options instantly-182304.mp4 | 10.85 MiB |
| Sort data with single buttons-182331.mp4 | 10.76 MiB |
| Select all cells that depend on the active cell-182308.mp4 | 10.48 MiB |
| Undo, Redo, and Repeat with keystrokes-182276.mp4 | 10.37 MiB |
| Use rounding shortcuts-182311.mp4 | 10.31 MiB |
| Display unique items from large lists-182338.mp4 | 9.95 MiB |
| Adjust the Quick Access Toolbar-182281.mp4 | 9.25 MiB |
| Customize the display of Status bar totals-182285.mp4 | 9.15 MiB |
| Use special formats for times over 24 hours-182328.mp4 | 9.04 MiB |
| Access Ribbon commands with Alt key sequences-182280.mp4 | 8.83 MiB |
| Perform calculations without formulas-182314.mp4 | 8.82 MiB |
| Realign imported text-182317.mp4 | 8.78 MiB |
| Enhanced editing tools-182299.mp4 | 8.48 MiB |
| Convert formulas to values with a simple drag-182269.mp4 | 8.47 MiB |
| Navigate between workbooks efficiently-182287.mp4 | 8.18 MiB |
| Adjust all or selected column widths or row heights in a flash-182271.mp4 | 8.14 MiB |
| Manipulate chart placement with dragging techniques-182340.mp4 | 8.03 MiB |
| Expand and collapse the Ribbon and full-screen views-182279.mp4 | 7.89 MiB |
| Use Conditional Formatting to highlight formula cells only-182326.mp4 | 7.87 MiB |
| Create double-spaced or triple-spaced printouts quickly-182320.mp4 | 7.84 MiB |
| Use Conditional Formatting based on comparison criteria-182325.mp4 | 7.6 MiB |
| Use AutoSum shortcuts-182310.mp4 | 7.39 MiB |
| Force typed dates to be only weekdays with data validation rules-182337.mp4 | 7.26 MiB |
| Zoom in and out quickly-182277.mp4 | 6.64 MiB |
| Ensure unique entries with data validation rules-182336.mp4 | 6.41 MiB |
| Welcome-182265.mp4 | 6.22 MiB |
| Enter times and time series efficiently-182297.mp4 | 5.82 MiB |
| Drag and insert with the Shift key-182303.mp4 | 5.71 MiB |
| Join data from multiple columns into one column with Flash Fill-182335.mp4 | 5.37 MiB |
| Instantly display all worksheet formulas-182272.mp4 | 4.84 MiB |
| Enter data or formulas in non-adjacent cells simultaneously-182268.mp4 | 4.69 MiB |
| Copy data or formulas down a column instantly-182270.mp4 | 4.63 MiB |
| Display a print preview instantly-182274.mp4 | 4.39 MiB |
| Create chart titles from cell content-182341.mp4 | 4.22 MiB |
| Create charts instantly with either of these keystroke shortcuts-182273.mp4 | 3.07 MiB |
| Instantly enter today's date or time-182275.mp4 | 2.3 MiB |
| Next steps-182347.mp4 | 1.31 MiB |
| Using the exercise files-182266.mp4 | 1.29 MiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_04.xlsx | 581.93 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_01.xlsx | 341.46 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_11.xlsx | 240.71 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_10.xlsx | 233.73 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_03.xlsx | 189.97 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_05.xlsx | 152.4 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_12.xlsx | 138.16 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_06.xlsx | 120.1 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_07.xlsx | 104.44 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_09.xlsx | 101.94 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_08.xlsx | 101.91 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_02.xlsx | 57.64 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_04A.xlsx | 26.9 KiB |
| Ex_Files_Excel_2013_Tips/Exercise Files/Ch_13.xlsx | 12.61 KiB |
