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
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
Brother...merged cell la Ulla data va epdi copy panni single cell la paste panrathu and single cell data va epdi merge cell la paste panrathu video podunga bro Ilana shorts avathu podunga please 🙏
excel la pages print ydukum pothu athu china tha eruku na atha kojam big size la print yduka nu aatha pathi video poduga next overl a,b,c colam over all a to z varikum na yana ku aaatha mari yapade print yadukanum
hi bro ,one column contains of 50 ta which is 5 digits numbers ,na ipo first ah erukra antha 5 digit number ku end la hifen(-) kudutha athu enaku rest of the 49 cells layum reflect aaganum athuku ena pananum
Anna naa bio student. But Excel learn pannanum nu romba interest and youtube la learn pannitu vara.....enaku PG dissertation ku konjam datas collect panni work pannanum na
And, oru doubt Anna.....ippo 3 columns la different different datas mixed aagi Iruku...enaku antha 3 columns la yum Iruka common data separate ah Venum na....Athuku solution sollunga na plz.....
Ctrl + F11 - Only new sheet are opening in Excel Ctrl + Page down - Working page is going on downwards when click (No farward direction on next sheet which is near right side ) Ctrl + Page up - Working page is going on upwards when click (No backward direction on sheet ) Pls once check it & do revert back
Stay Connected:
instagram.com/end_less_knowledge
facebook.com/enlessknowledge
whatsapp.com/channel/0029Va5iya9Lo4hbtSeVie3Z
twitter.com/EndlessKnowled1
www.threads.net/@end_less_knowledge
very use full
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
Thanks for this video sir
Please sir puting a lot of videos 🙏🙏🙏 Basic lesson to Advance level sir
Very useful... Really awesome... keep it up
Super Bro 👌
Electoral bond detail "Data analysis" video tutorial upload pannunga bro!❤❤❤❤❤❤
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 thank you
very useful for ur video sir
Lovely bro❤❤
Thank you sir 🙏
Very useful video
Glad you liked it... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Brother...merged cell la Ulla data va epdi copy panni single cell la paste panrathu and single cell data va epdi merge cell la paste panrathu video podunga bro Ilana shorts avathu podunga please 🙏
excel la pages print ydukum pothu athu china tha eruku na atha kojam big size la print yduka nu aatha pathi video poduga next overl a,b,c colam over all a to z varikum na yana ku aaatha mari yapade print yadukanum
good sir, learned lot
Glad to hear that... Keep learning more shortcut keys th-cam.com/play/PLLHRrAfRqTbOmHw5BaBvcEeIHLgV-nm92.html
thank you, i wasn't used the last one yet..ctrl+shift+space..what is the shortcut key to rename the excel sheet...other than alt+h+o+r
Thanks 👍🏻😊
நன்றி❤
Hi... What is the alternative for google sheets query function in MS excel?
Pivot table video deatails explanation ❤❤❤
Useful bro
Very useful nanba
Thanks very usefull
Hi sir excel jobs interview la ena mathiri test vaipaga like ena mathiri functions kepaga please make a video for MIS interview
Super sir
barcode based on inward and outward stock maintenance video bro
Thanks bro
hi bro ,one column contains of 50 ta which is 5 digits numbers ,na ipo first ah erukra antha 5 digit number ku end la hifen(-) kudutha athu enaku rest of the 49 cells layum reflect aaganum athuku ena pananum
@@karthikkarthik2153 use formula =A1&"-"
Ctrl + shift + v ( short key function not working)
Is there any other app like Excel other than google sheets
What is the version of you have using excel because my excel ribbon Power point option is not there
pls make a video about tally
Sir thanks
Thala,add-ins pathi video poddungaa
Bro ctr+page up (sheet change panurathu varala bro ) any other tips, i tried in laptop
sir, two cell entire figure input formula enable otherwise formula hide
Bro vlookup formula la oru letter work agadhu adhu endha key nu sollunga bro?
) ellana value varathu
Bro plz explain about microsoft dynamic 365
will try brother...
Sir, Excella numbers ratiola mention epdi painnarathuga sir. Like 1:60
நன்றி
Mouse use pannama excel la oru option na select pannamudiumma
Anna naa bio student. But Excel learn pannanum nu romba interest and youtube la learn pannitu vara.....enaku PG dissertation ku konjam datas collect panni work pannanum na
And, oru doubt Anna.....ippo 3 columns la different different datas mixed aagi Iruku...enaku antha 3 columns la yum Iruka common data separate ah Venum na....Athuku solution sollunga na plz.....
How can diaplay in file name footeer in word documents
POS bill Excel panga bro...🥰
Bro data va current sheet la irnthu other sheet ku kondu pora formula Enna bro
Apdi ethachum iruka
Ctrl + F11 - Only new sheet are opening in Excel
Ctrl + Page down - Working page is going on downwards when click (No farward direction on next sheet which is near right side )
Ctrl + Page up - Working page is going on upwards when click (No backward direction on sheet )
Pls once check it & do revert back
Bro ethalam our pdf va kuduthala nalla erukum
Ms- word patthium ethu maathiri solluga sago
Can we contact you for further support?
home shortcut work aagala anna
Create pivot table shortkut solunga
Alt+d+p enter
❤️❤️❤️
Ninga tally video poduramathiri enaku teri la , iam very sad for you. Sorry inime na kekamate ninga poduramatiri terila. Iam done with you. Tq bey.
Just find another video about tally
Neenga enna degree mudichirukeenga
@@birdscrazy1393 na (DCA, TALLY) mudikapore.
@@Lostinpeace3 bro I go to other video but, inta channel la puriyira mathiri vera enda channelyum ennaku puriila. Bro.
Excel dashboard video post bro
Learn how to create a Excel Dashboard with this step by step tutorial th-cam.com/video/YkLNJTNPgwA/w-d-xo.html
💓
I miss your voice bro
Neenga Yenna Job pandringa ?
Need a Video about Fuzzy Looku`p
will try to upload it soon... Keep Learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Super bro ❤❤❤
Thanks 🤗 brother... Keep learning more shortcut keys th-cam.com/play/PLLHRrAfRqTbOmHw5BaBvcEeIHLgV-nm92.html
Super sir