Lynda - Excel 2013 Power Shortcuts

1. Creating substitute data sets using scenarios-123796.mp49.86MB
2. Rounding values-123822.mp49.78MB
3. Using INDEX and MATCH to look up data without using the left-most column-123820.mp48.9MB
4. Customizing the Ribbon-123780.mp48.62MB
5. Welcome-123764.mp48.48MB
6. Basing conditional formats on a formula-123806.mp48.01MB
7. Creating a custom view-123791.mp47.29MB
8. Summarizing data using a sparkline-123835.mp47.14MB
9. Using a custom list with the fill handle-123809.mp46.99MB
10. Using a PivotTable value in a formula-123836.mp46.88MB
11. Entering a data series using the fill handle-123769.mp46.87MB
12. Controlling the user interface using your keyboard-123779.mp46.86MB
13. Creating separate sheets from a PivotTable-123838.mp46.82MB
14. Zooming in or out quickly-123789.mp46.71MB
15. Entering numbers with leading zeros-123768.mp46.46MB
16. Generating a list of unique random numbers-123819.mp46.45MB
17. Creating a linked picture of a range-123794.mp46.26MB
18. Customizing the Quick Access Toolbar-123781.mp46.13MB
19. Creating hyperlinks to other resources-123774.mp46.09MB
20. Creating a data entry form-123804.mp46.05MB
21. Creating and selecting named ranges quickly-123826.mp45.92MB
22. Printing a sheet on a set number of pages-123771.mp45.83MB
23. Super-hiding worksheets-123776.mp45.74MB
24. Extending a date series-123808.mp45.6MB
25. Creating a table using Ctrl+L-123792.mp45.46MB
26. Applying a table style and replacing existing formatting-123793.mp45.34MB
27. Removing duplicate values-123811.mp45.28MB
28. Entering data into every cell in a range-123800.mp45.21MB
29. Entering data using an AutoCorrect value-123803.mp45.2MB
30. Finding a target value-123795.mp45.18MB
31. Watching a cell's value-123831.mp45.16MB
32. Analyzing a formula for errors-123830.mp45MB
33. Using an Excel table column as a named range-123772.mp44.98MB
34. Analyzing data using the Quick Analysis Lens-123775.mp44.78MB
35. Drilling down into PivotTable data-123839.mp44.76MB
36. Setting a print area-123788.mp44.74MB
37. Hiding sheet tabs and scrollbars-123783.mp44.66MB
38. Calculating remainders and whole units-123823.mp44.44MB
39. Delaying PivotTable updates-123837.mp44.37MB
40. Displaying times that exceed twenty-four hours-123814.mp44.32MB
41. Numbering rows in a range or table-123773.mp44.32MB
42. Adding text to a number format-123770.mp44.26MB
43. Inserting the current date or time-123813.mp44.25MB
44. Limiting a worksheet's scroll area-123787.mp44.08MB
45. Wrapping and shrinking cell text-123799.mp43.98MB
46. Calculating time to reach an investment goal-123816.mp43.96MB
47. Displaying thousandths of a second-123817.mp43.89MB
48. Summarizing data on the status bar-123821.mp43.87MB
49. Moving among worksheets quickly-123784.mp43.81MB
50. Entering data into cells across multiple sheets-123802.mp43.79MB
51. Commenting within a formula-123827.mp43.77MB
52. Finding a specific color using RGB values-123805.mp43.77MB
53. Using Flash Fill to manage data-123810.mp43.64MB
54. Finding commands not on the Ribbon-123782.mp43.61MB
55. Creating recommended PivotTables-123777.mp43.55MB
56. Calculating days between dates-123815.mp43.55MB
57. Displaying a workbook's full path-123785.mp43.42MB
58. Setting the number of worksheets in a workbook-123786.mp43.19MB
59. Displaying a cell formula using FORMULATEXT-123828.mp43.07MB
60. Entering a line break in a cell-123798.mp43.01MB
61. Creating recommended charts-123834.mp42.95MB
62. Calculating running totals-123825.mp42.94MB
63. Creating a chart by pressing one key (or two)-123833.mp42.51MB
64. Picking data from a list-123801.mp42.46MB
65. Exiting a cell without saving changes-123829.mp42.32MB
66. Additional resources-123841.mp41.7MB
67. Using the exercise files-123766.mp4878.73KB
68. What you should know before watching this course-123765.mp4609.7KB