Lynda - Excel Tips Updated Jan 06 2016

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. Create an Organization Chart-447342.mp420.67MB
10. Creating colorful 3D buttons for worksheet annotation and macro buttons-427854.mp422.08MB
11. Creating dynamic charts with in-cell conditional formatting-373128.mp49.21MB
12. Creating text, numerical, date, and time lists in a flash-447336.mp417.93MB
13. Creating Variable Conditional Formatting Rules-447337.mp429.23MB
14. Custom formats using asterisk, semicolon, and brackets-447340.mp435.72MB
15. Custom grouping in PivotTables-370424.mp410.12MB
16. Customizing templates to fit your unique needs-374002.mp416.4MB
17. Discovering time-saving tools in the Go To Special feature-430657.mp440.18MB
18. Dynamically presenting data via chart slicers-383664.mp415.67MB
19. Enhancing table filtering with slicers-372453.mp416.78MB
20. Exploring various layouts for your PivotTable-397767.mp411MB
21. Exploring what-if scenarios using Goal Seek-445784.mp425.26MB
22. Handling Dates with unusual formats-447338.mp420.37MB
23. Highlighting PivotTable results with conditional formatting-375504.mp415.29MB
24. Increasing your productivity with custom lists-377482.mp417.21MB
25. Meeting unusual filtering needs via Advanced Filter-447341.mp447.89MB
26. Parsing your data to create unique lists-383074.mp412.53MB
27. Quick formatting tips-369627.mp418.57MB
28. Reducing data entry time by expanding AutoCorrect options-430659.mp418.92MB
29. Resizing, moving, copying, and manipulating charts and other objects-422773.mp427.95MB
30. Setting up custom views for quick access to different worksheet displays-430660.mp425.2MB
31. Splitting and consolidating workbooks-388137.mp416.17MB
32. Summarizing data from diverse ranges with Data _ Consolidate-415624.mp429.68MB
33. The top five unknown but useful keyboard shortcuts-368816.mp421.87MB
34. Tracking down cell dependencies across multiple worksheets and workbooks-430656.mp422.04MB
35. Transposing data and charts for a different perspective on your data-410210.mp427.73MB
36. Two-way lookup using the MATCH and INDEX functions-460711.mp451.06MB
37. Using check boxes and Conditional Formatting together for dynamic displays-414067.mp437.43MB
38. Using date and time as metrics in a PivotTable-387157.mp418.31MB
39. Using formulas to calculate values across worksheets and workbooks-384434.mp421.4MB
40. Using hyperlinks for rapidly switching worksheet locations and jumping to websites-430661.mp421.24MB
41. Using list boxes and combo boxes to facilitate forms creation-420933.mp421.59MB
42. Using option buttons, group boxes, and checkboxes to facilitate forms creation-430663.mp419.9MB
43. Using Pick list, VLOOKUP, Table, and Chart together-385365.mp417.11MB
44. Using scroll bars and spin buttons to facilitate forms creation-425940.mp423.54MB
45. Using source data from a table to make your PivotTable more dynamic-379954.mp420.62MB
46. Using the FORMULATEXT and N functions for worksheet and formula documentation-419138.mp413.93MB
47. Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells-416917.mp420.96MB
48. Using the REPT function to represent data visually-380984.mp46.82MB
49. Using the TREND and GROWTH functions for projecting future results-424601.mp419.94MB
50. Using wildcards (asterisk, tilde, and question mark)-447339.mp438.23MB