Lynda - Excel 2013 Tips and Tricks

1. Create split screens and frozen titles in a flash-182283.mp426.66MB
2. Create linked dynamic and static images-182343.mp426.55MB
3. Select noncontiguous ranges and visible cells only-182292.mp424.58MB
4. Select the current region of cells and move around region corners-182293.mp422.31MB
5. Use Custom Lists for rapid data entry and list-based sorting-182298.mp420.98MB
6. Navigate within worksheets-182289.mp420.67MB
7. Restore missing labels and hide repeating labels-182284.mp420.51MB
8. Insert, delete, hide, and unhide columns and rows rapidly-182316.mp419.91MB
9. Add a color background to every fifth row in a range-182324.mp419.74MB
10. Select an entire row, column, or worksheet-182291.mp419.4MB
11. Become more proficient with these short tips-182345.mp417.96MB
12. Clean up spaces quickly-182332.mp417.31MB
13. Collapse and expand detail quickly with outlining shortcuts-182319.mp417.21MB
14. Accelerate data entry-182295.mp416.14MB
15. Enter dates and date series efficiently-182296.mp415.91MB
16. Use keystroke shortcuts for frequently needed numeric formats-182322.mp414.82MB
17. Select and manipulate blank cells-182318.mp413.93MB
18. Create custom formats - Dot leaders and more-182327.mp413.89MB
19. Add and remove a strikethrough or a border with keystroke shortcuts-182329.mp413.6MB
20. Count the number of unique entries-182313.mp413.48MB
21. Create formulas rapidly-182307.mp413.41MB
22. Accelerate Copy, Move, and Paste actions with the right mouse button-182305.mp412.82MB
23. Select all cells that can affect the active cell-182309.mp412.42MB
24. Split column data into multiple columns with Flash Fill-182334.mp412.32MB
25. Accentuate date with alignment tools-182323.mp412.21MB
26. Navigate between worksheets efficiently-182288.mp411.84MB
27. Generate random numbers-182312.mp411.63MB
28. Accelerate worksheet copying and moving-182302.mp411.34MB
29. Identify and eliminate duplicates-182333.mp411.26MB
30. Accelerate copy-and-move tasks-182301.mp410.98MB
31. Create and manipulate shapes and use Shift and Ctrl keys-182342.mp410.87MB
32. Display Paste Special options instantly-182304.mp410.85MB
33. Sort data with single buttons-182331.mp410.76MB
34. Select all cells that depend on the active cell-182308.mp410.48MB
35. Undo, Redo, and Repeat with keystrokes-182276.mp410.37MB
36. Use rounding shortcuts-182311.mp410.31MB
37. Display unique items from large lists-182338.mp49.95MB
38. Adjust the Quick Access Toolbar-182281.mp49.25MB
39. Customize the display of Status bar totals-182285.mp49.15MB
40. Use special formats for times over 24 hours-182328.mp49.04MB
41. Access Ribbon commands with Alt key sequences-182280.mp48.83MB
42. Perform calculations without formulas-182314.mp48.82MB
43. Realign imported text-182317.mp48.78MB
44. Enhanced editing tools-182299.mp48.48MB
45. Convert formulas to values with a simple drag-182269.mp48.47MB
46. Navigate between workbooks efficiently-182287.mp48.18MB
47. Adjust all or selected column widths or row heights in a flash-182271.mp48.14MB
48. Manipulate chart placement with dragging techniques-182340.mp48.03MB
49. Expand and collapse the Ribbon and full-screen views-182279.mp47.89MB
50. Use Conditional Formatting to highlight formula cells only-182326.mp47.87MB
51. Create double-spaced or triple-spaced printouts quickly-182320.mp47.84MB
52. Use Conditional Formatting based on comparison criteria-182325.mp47.6MB
53. Use AutoSum shortcuts-182310.mp47.39MB
54. Force typed dates to be only weekdays with data validation rules-182337.mp47.26MB
55. Zoom in and out quickly-182277.mp46.64MB
56. Ensure unique entries with data validation rules-182336.mp46.41MB
57. Welcome-182265.mp46.22MB
58. Enter times and time series efficiently-182297.mp45.82MB
59. Drag and insert with the Shift key-182303.mp45.71MB
60. Join data from multiple columns into one column with Flash Fill-182335.mp45.37MB
61. Instantly display all worksheet formulas-182272.mp44.84MB
62. Enter data or formulas in non-adjacent cells simultaneously-182268.mp44.69MB
63. Copy data or formulas down a column instantly-182270.mp44.63MB
64. Display a print preview instantly-182274.mp44.39MB
65. Create chart titles from cell content-182341.mp44.22MB
66. Create charts instantly with either of these keystroke shortcuts-182273.mp43.07MB
67. Instantly enter today's date or time-182275.mp42.3MB
68. Next steps-182347.mp41.31MB
69. Using the exercise files-182266.mp41.29MB