(2015-2021) Excel Tips Weekly (Updated 09.02.2021)

1. 087 - Adjust banded-row formatting.mp4 59.17 MB
2. 072 - Keystroke shortcuts from A to Z Using the Ctrl key.mp4 56.35 MB
3. 051 - Two-way lookup using the MATCH and INDEX functions.mp4 51.90 MB
4. 061 - Working with formulas in tables.mp4 49.30 MB
5. 049 - Meeting unusual filtering needs via Advanced Filter.mp4 48.83 MB
6. 137 - Freezing column and row titles.mp4 42.85 MB
7. 107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.mp4 42.34 MB
8. 112 - Working with hidden data when copying cells and creating charts.mp4 41.91 MB
9. 007 - Using check boxes and conditional formatting together for dynamic displays.mp4 41.42 MB
10. 036 - Discovering time-saving tools in the Go To Special feature.mp4 41.00 MB
11. 048 - Custom formats using asterisk, semicolon, and brackets.mp4 40.12 MB
12. 105 - Formula nesting - Using multiple functions in the same formula.mp4 39.93 MB
13. 047 - Using wildcards (asterisk, tilde, and question mark).mp4 39.04 MB
14. 085 - Alter numeric data without formulas.mp4 38.31 MB
15. 098 - Create an expanded list from a summary using PivotTable techniques.mp4 37.62 MB
16. 101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.mp4 36.79 MB
17. 159 - Create numeric formats - Display in thousands or millions.mp4 36.66 MB
18. 099 - Solve matching issues with matching phone numbers and SS numbers.mp4 36.51 MB
19. 089 - How and when to use the 10 rounding functions in Excel.mp4 36.20 MB
20. 123 - Use custom formulas in data validation to keep out bad data.mp4 35.84 MB
21. 126 - Creating heat maps using conditional formatting.mp4 35.74 MB
22. 086 - Use Flash Fill to rapidly combine or separate columnar data.mp4 35.13 MB
23. 052 - Using Excel error-checking functions.mp4 34.44 MB
24. 014 - Adding illustrations to your workbook.mp4 34.43 MB
25. 073 - Use special tricks for working with dates in charts.mp4 33.99 MB
26. 057 - Building a flexible monthly table using functions.mp4 33.59 MB
27. 139 - Avoiding common chart distortions.mp4 33.51 MB
28. 147 - Sorting tips and shortcuts.mp4 33.21 MB
29. 116 - Displaying multiple worksheets and workbooks together.mp4 33.18 MB
30. 096 - How to create time interval entrie.mp4 33.16 MB
31. 117 - Tips for creating and updating sample data.mp4 32.38 MB
32. 093 - Accelerate data entry with five special techniques.mp4 32.28 MB
33. 084 - Use the OFFSET function for tabulating moving data.mp4 31.56 MB
34. 045 - Creating variable conditional formatting rules.mp4 31.54 MB
35. 054 - Auditing.mp4 31.39 MB
36. 129 - The Wrap Text, Merge and Center, and Indent options.mp4 31.08 MB
37. 009 - Transposing data and charts for a different perspective on your data.mp4 31.03 MB
38. 162 - Freeze Panes and Split.mp4 30.98 MB
39. 136 - New Excel 2016 chart types Tree map and sunburst.mp4 30.85 MB
40. 102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.mp4 30.79 MB
41. 071 - Work with formulas in tables.mp4 30.76 MB
42. 119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.mp4 30.60 MB
43. 104 - Create linkage formulas that refer to other worksheets and workbooks.mp4 30.58 MB
44. 110 - Use the FIND, MID, LEFT, and RIGHT functions.mp4 30.54 MB
45. 103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.mp4 30.50 MB
46. 095 - Use Watch Window and other techniques to track changing cells.mp4 30.41 MB
47. 034 - Calculating with hours, minutes, and times of day.mp4 30.37 MB
48. 128 - Displaying tips when using Excel in presentations.mp4 30.36 MB
49. 016 - Using formulas to calculate values across worksheets and workbooks.mp4 30.22 MB
50. 006 - Summarizing data from diverse ranges with Data - Consolidate.mp4 30.11 MB