Microsoft Excel Tips

In this video, you'll learn maximum number of tips and tricks available anywhere on YouTube in the shortest time. In other words, I made this video as concise as it possibly could be without missing any information out. Let's get started.

I'll cover various topics that can be very useful to engineers, accountants, administrators, or anyone else who uses Excel. I'll unravel, some secret parts of Excel that are not activated by default.

f you have any questions, please let me know in the comments below ?
I have put a lot of efforts in making this video! I appreciate if you could subscribe to support my channel! It really does help. Thanks! ?
If you want to learn Excel without wasting time, then watch my really short video tutorials playlist below:
? Microsoft Excel Short Tutorials (playlist) - https://www.youtube.com/playlist?list=PL6oDA8S3RmtGgzDX8zwFlWi4bZH8WmUYN
? Excel VBA Tutorials (playlist) - https://www.youtube.com/playlist?list=PL6oDA8S3RmtFlO7tSvUkUjVQaPjxg5yLN
? Intermediate Excel Skills, Tips, and Tricks Tutorial - https://youtu.be/OsxyP3T6AQ0
? The Beginner's Guide to Excel | Excel Basics Tutorial - https://youtu.be/6-LB1ZLpYdw
? How to link cells in different Excel Spreadsheets - https://youtu.be/JHrVa4av9_Q
? how to draw sine wave graph in excel - https://youtu.be/g7QUUrDmvx4
? Increase or decrease cell value automatically using Excel - https://youtu.be/noT7Uz5WyYs

Introduction 0:00
1. Transpose - 00:16
2. Quick Analysis Tool - 00:39
3. AutoFit Columns Or Rows - 1:37
4. Show Formulas - 2:16
5. Filter - 3:04
6. Drop-Down List - 3:54
7. Goal Seek - 4:56
8. Remove Duplicates - 6:14
9. IF Function - 7:11
10. Flash & Auto Fill - 8:05
11. VLOOKUP - 9:36
12. Text to Columns - 11:29
13. Paste Special Values Only - 12:45
14. People Graph - 13:24
15. Pictures in Charts - 14:05
16. Conditional Formatting - 14:44
17. Absolute Cell Reference Vs Relative Cell Reference - 15:42
18. Insert Screenshot - 17:11
19. Using Clear - 17:45
20. PowerPivot - 18:13
21. Comment - 19:12
22. Freeze Panes - 19:37
23. Fast Navigation Using Ctrl + Arrow - 20:28
24. Status Bar Info - 21:05
25. 3D Referencing - 21:39
26. Forecast Sheet - 22:42
27. SUMIFS Function - 23:22
28. Define Names For Ranges - 24:42
29. IFERROR Function - 25:13
30. Insert or Remove Columns Or Rows - 26:08
31. Filled Map - 27:03
32. Toggling Between Workbooks - 27:50
33. Move Columns Or Rows - 28:03
34. F4 For Toggling Between References - 28:34
35. Identifying Duplicates - 29:00
36. Links - 29:46
37. Data Restriction - 30:24
38. Quick Access Toolbar - 31:16
39. Trend Lines - 32:29
40. Joining Cell Values - 33:09
41. Using PROPER() Function - 33:54
42. Mean, Median & Mode - 34:35
43. Right Click Options - 35:20
44. Monthly Loan Payment Calculations - 36:19
45. To Duplicate Sheets - 37:27
46. Advanced Filter - 37:45
47. Number Of Blank Cells - 38:47
48. Insert Date & Time Using Shortcut - 39:14
49. Live Transpose - 39:32
50. Analysis Tools - 40:19
51. Slicers - 40:57
52. Scenario Manager - 41:54
53. Page Break Review - 43:54
54. Removing Gridlines - 45:01
55. Protect Workbook - 45:41
56. Unit Conversion - 46:34
57. Live Currency Conversion - 47:48
58. Hide Cells - 49:47
59. Remove Blank Rows - 50:11
60. Inserting Text - 50:36
61. Number Of Working Days - 51:13
62. Linking Excel To Word - 51:51
63. Advanced Select & Replace - 52:43
64. Wrap Text - 53:27
65. Recording Macros - 53:44
66. Inserting Symbols - 54:33
67. Format Painter - 54:54
68. Inserting Emoji - 55:32
Please, Subscribe - 56:37

#BhupinderTube #Excel #tutorial