Welcome to the ultimate guide for mastering Microsoft Excel! In this video, we'll be sharing the top 30 Excel tricks that will make your work faster, more efficient, and more productive than ever before.
From keyboard shortcuts to advanced formulas and functions, this tutorial covers everything you need to know to take your Excel skills to the next level. Whether you're a beginner or an experienced user, these tips and tricks will help you get the most out of Excel.
Here's what you'll learn:
1. How to create custom number formats (Format Cell Using shortcut key Ctrl+1)
2. How to remove duplicates from a list
3. select range on a certain criteria
4. Using the autofill feature to fill in data
5. Using conditional formatting to highlight important data
6. How to use the SUM function to add up values in a range
7. AutoSum for Quick Calculations
8. Copy paste using clipboard feature
9. Copy paste with drag and drop
10. Calculation with paste special
11. Multiplication of table using fill option
12. Print tiles option in excel
13. Show Formulas with evaluation
14. Sorting and filtering data
15. Advance filtering data
16. Consolidation option in excel
17. How to use the SUBTOTAL function to calculate subtotals in a table
18. Calculation of sum with trick
19. Yearfrac function in excel
20. How to use COUNTIF to count cells that meet a certain criteria
21. Financial function in excel FV Function
22. Calculate loan emi PMT function
23. Rate function in excel
24. Using the TRANSPOSE function to convert rows to columns and vice versa
25. Using Format Painter with shortcut key
26. Use Data Validation to Control Data Entry
27. Use the Text to Columns Tool to Split Data
28. How to quickly insert a new row or column
29. How we check total row and column in excel
30. How we calculate column and row using criteria
Bonus Trick – Insert date and time in excel with today function and now function also with shortcut key
Learn excel in 30 minutes
Excel learning
How to use excel
Excel tricks
Easy Excel
Excel for exam
Excel for interview
useful excel tricks
useful excel hacks
learn excel