51 Best Excel Tips and Tricks to skyrocket your productivity
Focused View
35:52
21 View
1. Introduction.mp4
01:14
1. 1. Save workbooks in Excel Binary format.mp4
00:38
2. 2. Hassle free formatting with Ctl+1.mp4
00:28
3. 3. Improve your speed by using Autosum.mp4
00:24
4. 4. Customize your Quick Access Toolbar [QAT].mp4
00:41
5. 5. Format Painter.mp4
00:41
6. 6. Use wildcards to find & replace data.mp4
00:40
7. 7. Everything is special with Paste Special.mp4
00:30
8. 8. Arithmetic operations with Paste Special.mp4
00:21
9. 9. Advanced excel tip Breakdown lengthy formulas.mp4
00:44
10. 10. Quick filter technique.mp4
00:28
11. 11. Sort data before working on large files.mp4
00:31
12. 12. Named ranges can add a lot of value.mp4
00:27
13. 13. Differentiate Input cells & Formula cells with a colour coding.mp4
00:30
14. 14 Control+Enter can solve formula fill problem.mp4
00:29
15. 15 Never ever hard code your formulas.mp4
00:32
16. 16 Hide cell contents in Conditional Formatting.mp4
00:40
17. 17 Use Transpose to transform your data.mp4
00:27
18. 18 Learn CVZY shortcuts to save 90% of your time.mp4
00:22
19. 19 Avoid using Merge & Center.mp4
00:22
20. 20 Beautify your reports with structured formatting.mp4
00:23
21. 21 Use built-in styles for quick formatting.mp4
00:27
22. 22 Use Transpose formula for live updates.mp4
00:32
23. 23 Find & Select (or GoTo special) to identify all the formulas in a worksheet.mp4
00:31
24. 24 Be careful with volatile formulas.mp4
00:25
25. 25 Calculation Options can help as well as ruin your work.mp4
00:34
26. 26 best excel tip GET RID OF GRIDLINES.mp4
00:25
27. 27 Use TRIM formula to remove unwanted spaces.mp4
00:28
28. 28 Extract Day, Month & Year from a date.mp4
00:26
29. 29 Measure length of a string with LEN formula.mp4
00:31
30. 30 Use IFERROR formula for error management.mp4
00:27
31. 31 Right formula can extract text from right side.mp4
00:30
32. 32 Left formula to extract text from Left side.mp4
00:23
33. 33 MID formula extract middle name.mp4
00:22
34. 34 Dynamic Right & Left formulas.mp4
00:27
35. 35 Use SUBSTITUTE formula to replace text.mp4
00:33
36. 36 Make use of Upper, Lower & Proper functions to play with the text.mp4
00:32
37. 37 Be careful with circular reference errors.mp4
00:19
38. 38 Trace precedents.mp4
00:30
39. 39 Trace Dependents.mp4
00:21
40. 40 BEST EXCEL TIPS Take full advantage of Sumif & Sumifs.mp4
00:29
41. 41 Boost your analytical skills with SUMPRODUCT formula.mp4
00:38
42. 42 Dont scroll Up & Down, use Freeze Panes.mp4
00:15
43. 43 Generate Random numbers using Randbetween formula (Caution).mp4
00:38
44. 44 Use Group feature to organize your workbook.mp4
00:23
45. 45 Excel tip for spead Be a keyboard user.mp4
00:17
46. 46 Commenting is essential yet we ignore.mp4
00:34
47. 47 Prepare for Tsunami Always backup your workbooks.mp4
00:31
48. 48 Quick filter check.mp4
00:22
49. 49 Use custom sort cool excel tip.mp4
00:20
50. 50 Spell check works in Excel too.mp4
00:17
51. 51 Dont let someone ruin your hard work Protect your formulas.mp4
00:45
1. Introduction.mp4
01:19
2. Rule 1 Adopt a Standard And Stick To It.mp4
01:58
3. Rule 2 Know Your Audience.mp4
01:29
4. Rule 3 Include a Welcome Sheet.mp4
00:38
5. Rule 4 Separate Your Data.mp4
00:34
6. Rule 5 Design For Longevity.mp4
00:56
7. Rule 6 Use Consistent, Clear Structure.mp4
00:38
8. Rule 7 Control Data Input.mp4
02:11
1. Conclusion.mp4
00:25
More details
User Reviews
Rating
average 0
Focused display
Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 61
- duration 35:52
- Release Date 2024/03/13
