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