Date formatting is always a headache. Sometimes the date uses american format and sometimes UK format. Example : I entered 10/9/2020 in indian way as we normally use. But excel reads it as October 9. After entering date in hundreds of cells in date column some date remains in us format and some in UK format. When we filter we can see the names of months that we never entered. At last we select all the date cells, go to format cell and click general. Here some date becomes number instead of date. This is a headache for many people. If you can suggest a solution for this, it would be a big blessing.
Hey..its a very informative channel. I have been using Google sheets for past 1 year. So does this formulas work on google sheets also? Or could you please do video for google sheets as well. It would be very helpful for those who is using Google sheets. Thank you
Thank brother..sure, am planning to upload (very soon) separate playlists for Google spreadsheet itself👍😊 and regarding your question : Not all forumula, since google spreadsheet developed in different platform.
Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support: drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ
📌To Learn Microsoft Excel in English, Click on the Below Link:
ua-cam.com/video/Cn3-bLDkGMY/v-deo.html
Thank u anfal ബായി
Thanks...Well explained.
Very useful thank u sir
Tnx Anitha😊
Thanks for the video
Very informative..many are new to me 🙏🙏🙏
Happy Learning Bro😇
Keep going chetta porichutta.. Really helpfull..
Please do more videos on excel..
Well Explained....
Thank you :)
Bro very helpfull for easy learning..
Waiting for second part 🥰
😊Very Soon!
Really helpfull
Data validation and vlookup will access program kindly showing me as my suggestion
Good one
:)
Its excellent!!!!
😊
Google Sheet Shortcuts ...Idavo..
Date formatting is always a headache. Sometimes the date uses american format and sometimes UK format.
Example : I entered 10/9/2020 in indian way as we normally use. But excel reads it as October 9. After entering date in hundreds of cells in date column some date remains in us format and some in UK format. When we filter we can see the names of months that we never entered. At last we select all the date cells, go to format cell and click general. Here some date becomes number instead of date.
This is a headache for many people.
If you can suggest a solution for this, it would be a big blessing.
First of all thank for your wonderful suggestion.... will figure out it soon and same will explain in different vid :)
Super 👌
😊
How we can combine different sheets into one excel sheet
Helpful 👍👍
Bro❤️
Hi sir, any short cut key for find a sheet in a workbook while sheet name type
Bro excellent , incert commentil ninnum short cut ill koodi engine exit aavam
Tnx Mate😊 Select the appropriate cell and press Shift-F2 :)
Thks bro 👍
Hey..its a very informative channel. I have been using Google sheets for past 1 year. So does this formulas work on google sheets also? Or could you please do video for google sheets as well. It would be very helpful for those who is using Google sheets. Thank you
Thank brother..sure, am planning to upload (very soon) separate playlists for Google spreadsheet itself👍😊 and regarding your question : Not all forumula, since google spreadsheet developed in different platform.
@@rows_columns thank you so much.. eagerly waiting for the same🤩👍
Sure Bro♥️
🙏🙏🙏 appricated brother
😇
Hai bro. in copy the formula or value. how to copy a value to ,left or up with short cut key
Sorry bro.. didn't get your question.. you mean you want to paste the copied value to Left-Right-Down-Up alignment?
Sir excel data പ്രിന്റിംഗ് ന്റെ വീഡിയോ ണ്ടോ ...
On the way bro :)
Can u send ur datasheet
FLASH FILL option Excel 2007 il work cheyyille..., Ctrl+E yum work cheyyunnilla....😔😔
Unfortunately.. They introduced from 2013 version onwards😊
Merge cell short cut vallathum kandupidichitundoo🤔
Pinallah..... :) ALT>H>M>C
while pressing F2 volume adjust option coming.
Try pressing Fn key too…
Hi, first of all thanks for your effort, very informative. I have doubt Why F2 short cut key is not working for rename selected item in laptop.
Try Fn+F2
@@rowscolumnsbyalfan5936 Okay thanks
Sir you can give attendance example sheet
Sure
Can u send ur data sheet
Hi execl online class undo
Excel matram pora Word um koodi ittal nallatayirunu?
Sure🙂 Will Plan👍
Mobile Excel ൽ വർക്ക് ആവുന്ന shortcuts ഉണ്ടോ?
Sorry brother, Mobilil njaan idh vare try cheyd nokiyittilla
Insert comment shift f2 thakarthu👍
Oru rakshayumilla , subscribe chythu
Tnx Bro :)
Excel lile financial functions il top aayittulla korach formulas nte vedio idaamo.. Please..
Sure Sure👍 Good suggestion!
Eth version lanu flash fill ullath?
2013 onwards😊
@@rows_columns thank you sir
👌👍😃
Wowow👏👏🌹subscribe cheydhu..
🙏
Pls sent me data this sheet
Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support: drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ
Very useful tips. Thanks Sir
😊
Its very helpful. thankyou sir