Thank you so much for such a video. I just gone through your channel all the videos are very useful and well explained. Expecting a video for advanced level pivot table..... Once again thank you......
Glad to hear that. Click on the small Triangle in the Top left corner of the worksheet to select the Entire sheet > Right-click on any Column header (A, B, C etc.) and select Unhide. Every hidden column will become visible. To unhide Rows, Select the entire sheet, Right-click on any Row header (1, 2, 3 etc.) and select Unhide.
Sir, Could you explain to calculate Over time from Monday to Sunday. Because Monday to Friday after 8 hrs only over time. But week days if any time is over time. How we can calculate over time from Monday to Sunday in single XL sheet
Sir, As you said last in the video for 200 Short cuts explanation video, could I have please that link? Or still pending? Your videos are quite appreciable!! Regards
I am still working on that video and it will take time for the final cut. But you can check these videos on my another RUclips channel ruclips.net/video/ynk01mkeK7Y/видео.html ruclips.net/video/mRpKwsnydM4/видео.html ruclips.net/video/kOmPcBY6ap8/видео.html
I have done a video on the technique to highlight the Active Cell in a worksheet. Please go through the videos section of this channel to find it. Highlighting cursor is related to settings of the Operating System.
For Filter Alt+D+F+F and Paste special alt+ctrl+v also can use
25 th can be done using control+alt+v
To copy the content frome the above cell to the down cell control+d also can be used
Thank you for sharing the Tip!😀
@@XLnCADMalayalam The content from left sell to right sell/ CTRL+r
Thank you so much for such a video. I just gone through your channel all the videos are very useful and well explained. Expecting a video for advanced level pivot table..... Once again thank you......
You are most welcome
Daily use cheyyan ullath correct kitty Thanks sir 🙏
You are Dr Ajay Anand or Prof Ajay Anand. I feel knowing nothing about Excel the more I listen to you. Thanks a lot.
My pleasure 😀
Extremely useful video.
Looking forward to more such educational videos.
Thank you and best wishes.
Very good method
Thank u very much
Please add a contents page showing time to navigate to particular topic
Excel class very useful and interesting, please give more functions, formula based and text base class
Please xheck the Playlists section for more videos. Playlist of 50+ functions are given below.
ruclips.net/video/sh4IKt5Wi5U/видео.html
you reveal a magic world in XL. Very useful..
Glad you think so! :)
Start learning Microsoft Excel in Malayalam
ruclips.net/video/TvefCbe9s30/видео.html
Very useful very nice we hope more videos frm your side
Glad to hear that.
Very simple n excellent
Thank you! Cheers!😀👍
Useful video..thnku.. thnku so much sir🙏
Most welcome
Thanks .It is very good presentation .
You are most welcome
Very useful video🌹simple presentation...
Thank you :)
Very useful tips tips, can I get this short cuts in excel as you show in video 0:19 please
All these shortcuts are listed in my website
xlncad.com
Thank you you're great
😀🙏
Thanks for another good information 👍🏻👍🏻👍🏻
Very informative..
Glad you think so!
Very useful video 👌 thank you sir
It's my pleasure and thank you for your kind words.
Alt+ Enter key ( long time finding this options)👍👍
Very useful and informative. Thanks
Glad it was helpful!
As always great lessons in a very professional manner.keep it up sir
ഒരുപാട് ഒരുപാട് ഒരുപാട് ഉപകാരം ചേട്ടാ..... താങ്ക്യൂ സോ മച്ച്...... 🥰👍🏻
😀
Hai its very use full thank u so much,, and to create new chart alt+f1 its not working,
I must say. Realy nice. One doubt how visible again hidden rows or hidden column
Glad to hear that.
Click on the small Triangle in the Top left corner of the worksheet to select the Entire sheet > Right-click on any Column header (A, B, C etc.) and select Unhide. Every hidden column will become visible.
To unhide Rows, Select the entire sheet, Right-click on any Row header (1, 2, 3 etc.) and select Unhide.
@@XLnCADMalayalam thank u so much for ur concern
How to change case as Capitalise Each Word (First letter of all words in a sentence) ?
Very good presentation.
Glad you liked it!
Super very helpful appreciate your effort
Glad to hear that
Sir, very usefull video, thnq💓
Most welcome
Super video very helpful✌️
Thank you 👍
വളരെ നല്ല അവതരണം, very very informative
Thank you :)
Please let me know that,Is ther anyway to directly copy a file description(eg.Title,Date) and paste it to excel. Thank you.
Please refer my video on 'How to create list of files in a folder'
very good presentation
Thanks a lot
Sir, organisation chart ഉണ്ടാക്കുന്ന വിധം വീഡിയോ ചെയ്യാമോ
Finally found the perfect video 😭❤..Thank you sir 🙌🏻
Nice way of presentation 🤝
Thank you 🤝
XL n CAD ന്റെ WORD Help videos ഉണ്ടോ
Very useful sir.
Thank you :)
Very helpful short cuts... 👍👍👍 thanks bro....
Thangalude video kandanu njan padikunnath,thnk u
Excel SHORTCUTS explained excellently
Thank you :)
Sir , well presentation. Its very easy to understand. And we can use alt+ctrl+v shortcut key for paste as value instead of Alt+E+S+V.
Thank you for sharing the Tip.
Thanku sir valare help aayi
😀✌️
🌟🤩 Ithilum nannayi vere aar paranj tharum... 🌟
Excellent instruction, thanks.
Glad it was helpful!
Splendid Presentation👍
Thank you! Cheers!
Concise & clear ...
Thank you :)
Helpful video... Thanks...
My pleasure :)
Good class... Thanks
Glad you liked it
Adipoli Video !! Really useful
Really useful.... Thank you..
My pleasure. I have one more video on Excel shortcuts for beginners. Check that too.
Useful episode, thank you 😊 Appreciate
So nice of you
Useful video…Thanks
Sir njn examinte Annu morning aanu ee video kande Enikku upakaarapettu Thak you sir😍😍😍😍😍
Glad to hear that :)
Than you so much
Powli vedio class🥰🤟🤟
Glad to hear that :)
Appreciate and thank you so much Sir 👍🙏 for the valuable information 👌
Glad to hear that. There is one more video on Excel shortcuts. I recommend to refer that too.
@@XLnCADMalayalam thanks and noted Sir 👍🙏
Very help ful👍
Well explained 👍🏻
Thank you :)
Thank you sir, good class
Always welcome
Good information good luck
So nice of you
Very useful.
Glad it was helpful!
Thank u,,super
Welcome 😊
very useful shortcuts thanks
You are welcome
ഒരു excel ഷീറ്റിലേക്ക് ഉള്ള ലിങ്ക് track ചെയ്യാൻ ഏത് കീ കോമ്പോ ആണ് ഉപയോഗിക്കേണ്ടത്
Ctrl + [
Excellent work
Thank you
Thank you...
You're welcome!
It’s nice 👍🏻
To Insert a Row we can use Alt+I+R
To insert a Column we can use Alt+I+C
Good presentation ❤👍
Thank you 😀
Thank u sir you're my teacher
It's my pleasure
thank a lot for this video
You are welcome
You are really stupendous!!! Appreciate for your great efforts Sir👏👏👏👏👌👌👌👌👌👍👍👍👍🙏🙏🙏🙏🙏✌
So nice of you
Sir, Could you explain to calculate Over time from Monday to Sunday. Because Monday to Friday after 8 hrs only over time. But week days if any time is over time. How we can calculate over time from Monday to Sunday in single XL sheet
Very Useful 👍
Good One 🥇
Thank you.
I have more video on Excel Shortcuts. Please check that too.
Great work
Thank you so much 😀
Excellent
Thank you :)
Very interesting..
Glad you think so!
Thanks🙏🏼
You’re welcome 😊
very helpfull videos
Glad you think so!
Visit xlncad.com/ to read my articles on Excel
21,22 ഒന്നു കൂടി വിശദീകരിക്കാമോ ഒന്നും മാനിസിലായില്ല 😑
excellent
Thank you
Sir, As you said last in the video for 200 Short cuts explanation video, could I have please that link? Or still pending?
Your videos are quite appreciable!!
Regards
I am still working on that video and it will take time for the final cut. But you can check these videos on my another RUclips channel
ruclips.net/video/ynk01mkeK7Y/видео.html
ruclips.net/video/mRpKwsnydM4/видео.html
ruclips.net/video/kOmPcBY6ap8/видео.html
XL n CAD Malayalam 👍🏻
I have added these shortcuts to my website. Pls check.
xlncad.com/excel-shortcuts/
Thank you 😌 sir
My pleasure
Tq u 💛💛💛
My pleasure :)
Well explained
Thank you :)
V look up onnu paranju tharumo??
I have few videos on VLOOKUP, XLOOKUP and INDEX+MATCH. Please go through the videos section of this channel to find that videos.
Ma kayinja oralk Dca, ms office ' data entry ivayil yethaanu bettr.pls reply
Purchase and sale stock video undoo
You can join the patreon page of XL n CAD Malayalam, if you need help in customizing spreadsheets.
Usefull👍🏻👍🏻
Glad you think so!
Cursor move aakunna sthalathu highlight cheyyan ulla reethi onnu parayaamo ?
I have done a video on the technique to highlight the Active Cell in a worksheet. Please go through the videos section of this channel to find it.
Highlighting cursor is related to settings of the Operating System.
What is the shortcut to unhide columns and rows ?....
Unhide row
Ctrl + shift + 9
Unhide column
Alt O C U
very very helpful
Glad to hear that
Thanks sir
My pleasure 😀
Very useful ❤️
Thank you. I have one more video on Excel Shortcuts. Pls check that too.
From where I can get this sample data ?
Total value cumulative ayi add cheythu pokanulla formula ?
What is the shortcut key for removing the excel table function?
Nice explanation! Word help please
Please check my playlist called MS Word Tutorial