How to use Excel for work? We brought about 6 case studies in this basic Excel course to answer this question. These include basic and advanced formulas and some mindset tricks that will increase your understanding of the software in Hindi.
Understand how to use Microsoft Excel for your job in data entry, data analysis, or for normal everyday use.
More videos for you:
Excel basics: https://youtu.be/Y1NNQV8MdnA
Excel functions and formulas: https://youtu.be/QaeDIW2QeGg
Excel for data entry: https://youtu.be/SEY4aU5neDQ
Aditya Sir’s YouTube channel: https://www.youtube.com/@aditya_shelar
Excel training file: https://bit.ly/ExcelPracticeFileFL
Join this channel to get access to perks:
https://www.youtube.com/channel/UCJ0FT6Ijeyf6Mr-GdOBsVAQ/join
Talk to me on Instagram: https://www.instagram.com/focusankur/ (@focusankur)
Join my WhatsApp Group: https://bit.ly/focuswat
Chapters:
00:00 Introduction
01:34 Fast fill
03:33 Removing duplication
04:20 COUNTIF
06:30 Tax calculations
10:48 What if analysis
14:00 Loan/EMI calculation
16:53 Reverse calculation/ Goal seek function
18:25 Cleaning data
20:00 Cleaning phone numbers
23:00 Currency conversion
24:53 Stock market data/history
28:57 Bonus feature
#focuslocus #excel #msexcel
source