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 🙏
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
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
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
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
Very useful... Really awesome... keep it up
Hi... What is the alternative for google sheets query function in MS excel?
very useful for ur video sir
Very useful thank you
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
Please sir puting a lot of videos 🙏🙏🙏 Basic lesson to Advance level sir
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
good sir, learned lot
Glad to hear that... Keep learning more shortcut keys ruclips.net/p/PLLHRrAfRqTbOmHw5BaBvcEeIHLgV-nm92
Thank you sir 🙏
Super Bro 👌
Ctrl + shift + v ( short key function not working)
Lovely bro❤❤
Very useful video
Glad you liked it... Keep learning more about excel important functions ruclips.net/p/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa
Very useful nanba
Is there any other app like Excel other than google sheets
Useful bro
Electoral bond detail "Data analysis" video tutorial upload pannunga bro!❤❤❤❤❤❤
Pivot table video deatails explanation ❤❤❤
barcode based on inward and outward stock maintenance video bro
Thanks 👍🏻😊
sir, two cell entire figure input formula enable otherwise formula hide
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 🙏
pls make a video about tally
நன்றி❤
Hi sir excel jobs interview la ena mathiri test vaipaga like ena mathiri functions kepaga please make a video for MIS interview
Thanks very usefull
Thala,add-ins pathi video poddungaa
Sir, Excella numbers ratiola mention epdi painnarathuga sir. Like 1:60
Super sir
Thanks bro
Bro plz explain about microsoft dynamic 365
will try brother...
POS bill Excel panga bro...🥰
Bro ctr+page up (sheet change panurathu varala bro ) any other tips, i tried in laptop
What is the version of you have using excel because my excel ribbon Power point option is not there
Sir thanks
How can diaplay in file name footeer in word documents
Can we contact you for further support?
Bro vlookup formula la oru letter work agadhu adhu endha key nu sollunga bro?
) ellana value varathu
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&"-"
Bro data va current sheet la irnthu other sheet ku kondu pora formula Enna bro
Apdi ethachum iruka
Bro ethalam our pdf va kuduthala nalla erukum
Mouse use pannama excel la oru option na select pannamudiumma
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
Create pivot table shortkut solunga
Alt+d+p enter
Ms- word patthium ethu maathiri solluga sago
home shortcut work aagala anna
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 ruclips.net/video/YkLNJTNPgwA/видео.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 ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
Super bro ❤❤❤
Thanks 🤗 brother... Keep learning more shortcut keys ruclips.net/p/PLLHRrAfRqTbOmHw5BaBvcEeIHLgV-nm92
Super sir