Lynda - Excel 2013 Tips and Tricks

1. Create split screens and frozen titles in a flash-182283.mp4 27.30 MB
2. Create linked dynamic and static images-182343.mp4 27.19 MB
3. Select noncontiguous ranges and visible cells only-182292.mp4 25.17 MB
4. Select the current region of cells and move around region corners-182293.mp4 22.84 MB
5. Use Custom Lists for rapid data entry and list-based sorting-182298.mp4 21.48 MB
6. Navigate within worksheets-182289.mp4 21.16 MB
7. Restore missing labels and hide repeating labels-182284.mp4 21.01 MB
8. Insert, delete, hide, and unhide columns and rows rapidly-182316.mp4 20.38 MB
9. Add a color background to every fifth row in a range-182324.mp4 20.21 MB
10. Select an entire row, column, or worksheet-182291.mp4 19.87 MB
11. Become more proficient with these short tips-182345.mp4 18.39 MB
12. Clean up spaces quickly-182332.mp4 17.73 MB
13. Collapse and expand detail quickly with outlining shortcuts-182319.mp4 17.63 MB
14. Accelerate data entry-182295.mp4 16.53 MB
15. Enter dates and date series efficiently-182296.mp4 16.29 MB
16. Use keystroke shortcuts for frequently needed numeric formats-182322.mp4 15.18 MB
17. Select and manipulate blank cells-182318.mp4 14.27 MB
18. Create custom formats - Dot leaders and more-182327.mp4 14.22 MB
19. Add and remove a strikethrough or a border with keystroke shortcuts-182329.mp4 13.92 MB
20. Count the number of unique entries-182313.mp4 13.80 MB
21. Create formulas rapidly-182307.mp4 13.73 MB
22. Accelerate Copy, Move, and Paste actions with the right mouse button-182305.mp4 13.12 MB
23. Select all cells that can affect the active cell-182309.mp4 12.71 MB
24. Split column data into multiple columns with Flash Fill-182334.mp4 12.61 MB
25. Accentuate date with alignment tools-182323.mp4 12.50 MB
26. Navigate between worksheets efficiently-182288.mp4 12.13 MB
27. Generate random numbers-182312.mp4 11.91 MB
28. Accelerate worksheet copying and moving-182302.mp4 11.62 MB
29. Identify and eliminate duplicates-182333.mp4 11.53 MB
30. Accelerate copy-and-move tasks-182301.mp4 11.24 MB
31. Create and manipulate shapes and use Shift and Ctrl keys-182342.mp4 11.13 MB
32. Display Paste Special options instantly-182304.mp4 11.11 MB
33. Sort data with single buttons-182331.mp4 11.01 MB
34. Select all cells that depend on the active cell-182308.mp4 10.73 MB
35. Undo, Redo, and Repeat with keystrokes-182276.mp4 10.61 MB
36. Use rounding shortcuts-182311.mp4 10.56 MB
37. Display unique items from large lists-182338.mp4 10.19 MB
38. Adjust the Quick Access Toolbar-182281.mp4 9.47 MB
39. Customize the display of Status bar totals-182285.mp4 9.36 MB
40. Use special formats for times over 24 hours-182328.mp4 9.26 MB
41. Access Ribbon commands with Alt key sequences-182280.mp4 9.04 MB
42. Perform calculations without formulas-182314.mp4 9.03 MB
43. Realign imported text-182317.mp4 8.99 MB
44. Enhanced editing tools-182299.mp4 8.69 MB
45. Convert formulas to values with a simple drag-182269.mp4 8.67 MB
46. Navigate between workbooks efficiently-182287.mp4 8.38 MB
47. Adjust all or selected column widths or row heights in a flash-182271.mp4 8.33 MB
48. Manipulate chart placement with dragging techniques-182340.mp4 8.22 MB
49. Expand and collapse the Ribbon and full-screen views-182279.mp4 8.08 MB
50. Use Conditional Formatting to highlight formula cells only-182326.mp4 8.06 MB