Lynda - Excel Tips Updated Apr 2016

1. Two-way lookup using the MATCH and INDEX functions.mp451.06MB
2. Working with formulas in tables.mp448.15MB
3. Meeting unusual filtering needs via Advanced Filter.mp447.89MB
4. Discovering time-saving tools in the Go To Special feature.mp440.18MB
5. Using wildcards (asterisk, tilde, and question mark).mp438.23MB
6. Using check boxes and Conditional Formatting together for dynamic displays.mp437.43MB
7. Custom formats using asterisk, semicolon, and brackets.mp435.72MB
8. Using Excel's error-checking functions.mp433.85MB
9. Building a flexible monthly table using functions.mp432.81MB
10. Auditing.mp431.07MB
11. Calculating with hours, minutes, and times of day.mp429.73MB
12. Summarizing data from diverse ranges with Data _ Consolidate.mp429.68MB
13. Creating Variable Conditional Formatting Rules.mp429.23MB
14. Locating Data Validation rules and violations.mp428.54MB
15. Resizing, moving, copying, and manipulating charts and other objects.mp427.95MB
16. Transposing data and charts for a different perspective on your data.mp427.73MB
17. ADDRESS, ROW, and COLUMN functions.mp427.67MB
18. Restoring missing column titles.mp426.37MB
19. Adding illustrations to your workbook.mp425.94MB
20. Adding comments and shapes.mp425.75MB
21. Exploring what-if scenarios using Goal Seek.mp425.26MB
22. Setting up custom views for quick access to different worksheet displays.mp425.2MB
23. Controlling worksheet security by allowing selected users to edit specific cell ranges.mp424.26MB
24. Becoming more productive with these 10 tiny tips you'll use often.mp424.13MB
25. Custom formats, relative addressing, and conditional formatting.mp424.07MB
26. Using scroll bars and spin buttons to facilitate forms creation.mp423.54MB
27. Creating an Excel template.mp423.18MB
28. Creating colorful 3D buttons for worksheet annotation and macro buttons.mp422.08MB
29. Tracking down cell dependencies across multiple worksheets and workbooks.mp422.04MB
30. The top five unknown but useful keyboard shortcuts.mp421.87MB
31. Using list boxes and combo boxes to facilitate forms creation.mp421.59MB
32. Drawing borders and border grids.mp421.47MB
33. Using formulas to calculate values across worksheets and workbooks.mp421.4MB
34. Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp421.24MB
35. Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp420.96MB
36. Create an Organization Chart.mp420.67MB
37. Using source data from a table to make your PivotTable more dynamic.mp420.62MB
38. Applying conditional formatting across rows of data.mp420.52MB
39. Handling Dates with unusual formats.mp420.37MB
40. Adding pictures as worksheet backgrounds.mp420.05MB
41. Using the TREND and GROWTH functions for projecting future results.mp419.94MB
42. Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp419.9MB
43. Adding, managing, and printing comments for worksheet documentation.mp419.42MB
44. Reducing data entry time by expanding AutoCorrect options.mp418.92MB
45. Accelerating Cut, Copy, Paste, and Insert tasks.mp418.9MB
46. Quick formatting tips.mp418.57MB
47. Using date and time as metrics in a PivotTable.mp418.31MB
48. Creating text, numerical, date, and time lists in a flash.mp417.93MB
49. Join data with new CONCAT and TEXTJOIN functions.mp417.57MB
50. Increasing your productivity with custom lists.mp417.21MB
51. Using Pick list, VLOOKUP, Table, and Chart together.mp417.11MB
52. Enhancing table filtering with slicers.mp416.78MB
53. Customizing templates to fit your unique needs.mp416.4MB
54. Splitting and consolidating workbooks.mp416.17MB
55. Dynamically presenting data via chart slicers.mp415.67MB
56. Highlighting PivotTable results with conditional formatting.mp415.29MB
57. Using the FORMULATEXT and N functions for worksheet and formula documentation.mp413.93MB
58. Converting charts into pictures.mp413.18MB
59. Parsing your data to create unique lists.mp412.53MB
60. Exploring various layouts for your PivotTable.mp411MB
61. Custom grouping in PivotTables.mp410.12MB
62. Creating dynamic charts with in-cell conditional formatting.mp49.21MB
63. Using the REPT function to represent data visually.mp46.82MB