Ctrl + N - New workbook Ctrl + W - Close current workbook Ctrl + O - Launch Open page Ctrl + S - Save workbook F12 - Save as option launch Ctrl + C - Copy items Ctrl + X - Cut items Ctrl + Z - Undo Ctrl + P - Launch print setup page Ctrl + 1 - Format cells launch Ctrl + T - Dataset convert to table Tab - Quick formula entry F4 - Locking cell value Ctrl + ` - To view formulas in working sheet Ctrl + ' - Copy down formula in very next cell Ctrl + F1 - Hide/unhide menu ribbon Ctrl + Tab - Switching between workbooks Ctrl + Pageup or Page down - Navigate between sheets in a workbook Ctrl + G - Launch Go To Ctrl + F - Launch Find and Replace Ctrl + Home - Back to A1 cell Ctrl + End - selecting Cell end value F2 - Turning cell into edit mode Alt + Enter - Moving to new row in a single cell Ctrl + : - Current date Ctrl + Shift + ; - Current time Ctrl + Enter - Select range and copy same value Ctrl + D - Preceeding cell value and format to copy down Ctrl + Shift +V - Paste only values Ctrl + Y - Redo Ctrl + A - Select all dataset Ctrl + Home - Ctrl + Shift End - Cell A1 to end value selection Ctrl + Space - Select entire column Shift + Space - Select entire row Shift + Space & Ctrl + Space - Selecting entire worksheet
You can watch tutor Joe’s tally videos . Even though no one is like him (Endless knowledge) to teach. Really your teaching style is awesome sir
Bro. Enoda office la 5 different bank accounts maintain pantren. account maintain panna excel use panalam nu iruken. 'payment in' nu oru bank name click pannuna Bank balance add agura mathirium 'payment out' nu oru bank name click pannuna Bank balance reduce agura mathirium excel sheet ready panna mudiyuma
Very useful... Really awesome... keep it up
Please sir puting a lot of videos 🙏🙏🙏 Basic lesson to Advance level sir
Thanks for this video sir
Hi... What is the alternative for google sheets query function in MS excel?
Is there any other app like Excel other than google sheets
Hi sir excel jobs interview la ena mathiri test vaipaga like ena mathiri functions kepaga please make a video for MIS interview
Bro iam begginer in excel..i want to learn from 0 to advance level.iam learning by seeing your videos but i don't know from where I need to start the class.. can you please send me the format or order of the Excel course video... thank you bro
Useful bro
Super Bro 👌
Very useful thank you
Electoral bond detail "Data analysis" video tutorial upload pannunga bro!❤❤❤❤❤❤
Thanks na ❤
Very useful nanba
very useful for ur video sir:hand-pink-waving::hand-pink-waving:
sir, two cell entire figure input formula enable otherwise formula hide
Thanks very usefull
@EndlessKnowledge