589689.xyz

Lynda - Excel 2013 Tips and Tricks

  • 收录时间:2018-03-17 18:21:57
  • 文件大小:780MB
  • 下载次数:98
  • 最近下载:2021-01-19 23:56:21
  • 磁力链接:
立即下载 复制链接

文件列表

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