Lynda - Excel Tips Updated Nov 10 2015

1. Accelerating Cut, Copy, Paste, and Insert tasks-378860.mp418.9MB
2. Adding illustrations to your workbook-386195.mp425.94MB
3. Adding, managing, and printing comments for worksheet documentation-430658.mp419.42MB
4. Applying conditional formatting across rows of data-408645.mp420.52MB
5. Becoming more productive with these 10 tiny tips you'll use often-411964.mp424.13MB
6. Calculating with hours, minutes, and times of day-429254.mp429.73MB
7. Controlling worksheet security by allowing selected users to edit specific cell ranges-430662.mp424.26MB
8. Converting charts into pictures-371409.mp413.18MB
9. Creating colorful 3D buttons for worksheet annotation and macro buttons-427854.mp422.08MB
10. Creating dynamic charts with in-cell conditional formatting-373128.mp49.21MB
11. Creating text, numerical, date, and time lists in a flash-447336.mp417.93MB
12. Creating Variable Conditional Formatting Rules-447337.mp429.23MB
13. Custom grouping in PivotTables-370424.mp410.12MB
14. Customizing templates to fit your unique needs-374002.mp416.4MB
15. Discovering time-saving tools in the Go To Special feature-430657.mp440.18MB
16. Dynamically presenting data via chart slicers-383664.mp415.67MB
17. Enhancing table filtering with slicers-372453.mp416.78MB
18. Exploring various layouts for your PivotTable-397767.mp411MB
19. Exploring what-if scenarios using Goal Seek-445784.mp425.26MB
20. Highlighting PivotTable results with conditional formatting-375504.mp415.29MB
21. Increasing your productivity with custom lists-377482.mp417.21MB
22. Parsing your data to create unique lists-383074.mp412.53MB
23. Quick formatting tips-369627.mp418.57MB
24. Reducing data entry time by expanding AutoCorrect options-430659.mp418.92MB
25. Resizing, moving, copying, and manipulating charts and other objects-422773.mp427.95MB
26. Setting up custom views for quick access to different worksheet displays-430660.mp425.2MB
27. Splitting and consolidating workbooks-388137.mp416.17MB
28. Summarizing data from diverse ranges with Data _ Consolidate-415624.mp429.68MB
29. The top five unknown but useful keyboard shortcuts-368816.mp421.87MB
30. Tracking down cell dependencies across multiple worksheets and workbooks-430656.mp422.04MB
31. Transposing data and charts for a different perspective on your data-410210.mp427.73MB
32. Using check boxes and Conditional Formatting together for dynamic displays-414067.mp437.43MB
33. Using date and time as metrics in a PivotTable-387157.mp418.31MB
34. Using formulas to calculate values across worksheets and workbooks-384434.mp421.4MB
35. Using hyperlinks for rapidly switching worksheet locations and jumping to websites-430661.mp421.24MB
36. Using list boxes and combo boxes to facilitate forms creation-420933.mp421.59MB
37. Using option buttons, group boxes, and checkboxes to facilitate forms creation-430663.mp419.9MB
38. Using Pick list, VLOOKUP, Table, and Chart together-385365.mp417.11MB
39. Using scroll bars and spin buttons to facilitate forms creation-425940.mp423.54MB
40. Using source data from a table to make your PivotTable more dynamic-379954.mp420.62MB
41. Using the FORMULATEXT and N functions for worksheet and formula documentation-419138.mp413.93MB
42. Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells-416917.mp420.96MB
43. Using the REPT function to represent data visually-380984.mp46.82MB
44. Using the TREND and GROWTH functions for projecting future results-424601.mp419.94MB