اسلام و علیکم ستیش بھیا بہت خوب ، بہت زمانے سے Excel sheet میں کافی مشکلات ھو رھی تھیں. آپکی اس وڈیو میں میری بڑی مدد ملی ھے. آپکا بہت بہت شکریہ. اللہ پاک آپکو جزائے خیر عطا فرمائے شکریہ - محمد اکمل
OUTLOOK® SHORTCUT KEYS Alt + S Send the email Ctrl + C Copy selected text Ctrl + X Cut selected text Ctrl + P Open print dialog box Ctrl + K Complete name/email typed in address bar Ctrl + B Bold highlighted selection Ctrl + I Italicize highlighted selection Ctrl + U Underline highlighted selection Ctrl + R Reply to an email Ctrl + F Forward an email Ctrl + N Create a new email Ctrl + Shift + A Create a new appointment to your calendar Ctrl + Shift + O Open the outbox Ctrl + Shift + I Open the inbox Ctrl + Shift + K Add a new task Ctrl + Shift + C Create a new contact Ctrl + Shift+ J Create a new journal entry
Sir, this video is very useful for excel learner. i starred to watch your video very recently. it will take time but i promise you to watch all video and become Excel expert. i am really thankful to you for making very essential video .thankyou very much and God bless you..
I am from Pakistan. Great work sir , your students are very lucky if they have passion of learning excel. Please also upload uses of macros in different fields.
BASIC SHORTCUT KEYS Alt + F File menu options in current program Alt + E Edit options in current program F1 Universal help (for all programs) Ctrl + A Select all text Ctrl + X Cut selected item Shift + Del Cut selected item Ctrl + C Copy selected item Ctrl + Ins Copy selected item Ctrl + V Paste Shift + Ins Paste Home Go to beginning of current line Ctrl + Home Go to beginning of document End Go to end of current line Ctrl + End Go to end of document Shift + Home Highlight from current position to beginning of line Shift + End Highlight from current position to end of line Ctrl + f Move one word to the left at a time Ctrl + g Move one word to the right at a time
its really useful video. I learnt lots of new formulas. I would like to tell you one more formula about "Filter". We can use formula Ctrl+Shift+L with this formula we can add or remove Filter from excel sheet.
Thankyou sir your explanation is very good i watch all your video and now am felling good that i know to use computer all thing thank you sir may your channel be one of the biggest channel on youtube one day💯💯
Dear Sir, Complete shortcut keys in 1 video, very nice Sir 👍 All in one Excel shortcut video. Colum unhide krne ka shortcut hai, Select two cell only for unhide colum- Alt+H+O+U+L very easy. Please add this shortcut key in next shortcut video. Kindly revert.
@@Learn_More_Pro I'm your lover, Aapki video se mujhe bahut help hui hai. Apne office me Excel me faster ki trah kaam krta hun, Ye sab Aap se hi sikha hai. 🙏🙏 Thank you Guru ji.
In excel older version, If we use Alt+Space Bar & C to close file then all open excel files get close so instead of that we should use ctl + W will close one by one. Sorry for bad english...🙏🙂
Hi sir, Thanks & appreciate that u have provided all the shortcuts in single video. unfortunately I know every single shortcut u mentioned in this video...I'm looking short cut for 1.working inside pivot table like selection of fileds 2. Selection of objects (for example we have 30 object in a sheet. I need to select 15 or or 20 objects not necessarily in order)
In shortcut no 14(repeat last action), when I press F4, a pop up menu appears with the following options-PC screen only, duplicate, extend, second screen only etc.
Sir for me all shortcurt keys are new but i am hare for your shortcurt no.49&50 its really very help full for me thank you so much for your hard work and most important time as well as thank you 😊
Wonderful sir initially i was complete blank of computet knowledge but on seeing your lecture through youtube i became smart in office computer work I am realy very greatful to you
Hiii sir, I have to make a VBA for in/out stock inventory In which (in stock) date item qty Mfd Exp. Out stock date item qty given to and remains qty Plzz help me
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
mo no daya
OkI ii j JJ j ji ji JJ JJ JJ JJ JJ JJ JJ jjj ji ji JJ jjj ji jjjijjjji
👌👌🙏
Ctrl +e not wroking
💶
Mujhe nend aa rahi h fir bhi apki vdo dekh rhi hu bcz ap cmdy krte huye smjhate ho or bahut acche se samjhate ho thnk u so much bro...
Hi
Are you are feeling take a siesta then you can sleep
😂😂😂😂
اسلام و علیکم
ستیش بھیا
بہت خوب ، بہت زمانے سے Excel sheet میں کافی مشکلات ھو رھی تھیں.
آپکی اس وڈیو میں میری بڑی مدد ملی ھے.
آپکا بہت بہت شکریہ.
اللہ پاک آپکو جزائے خیر عطا فرمائے
شکریہ -
محمد اکمل
OUTLOOK® SHORTCUT KEYS
Alt + S Send the email
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + P Open print dialog box
Ctrl + K Complete name/email typed in address bar
Ctrl + B Bold highlighted selection
Ctrl + I Italicize highlighted selection
Ctrl + U Underline highlighted selection
Ctrl + R Reply to an email
Ctrl + F Forward an email
Ctrl + N Create a new email
Ctrl + Shift + A Create a new appointment to your calendar
Ctrl + Shift + O Open the outbox
Ctrl + Shift + I Open the inbox
Ctrl + Shift + K Add a new task
Ctrl + Shift + C Create a new contact
Ctrl + Shift+ J Create a new journal entry
Thanks ji
Thank you sir, it will be very helpful for us. 🤗
For filter apply and remove also use CTRL+SHIFT+L
Sir, this video is very useful for excel learner. i starred to watch your video very recently. it will take time but i promise you to watch all video and become Excel expert. i am really thankful to you for making very essential video .thankyou very much and God bless you..
Sir Aapke Videos Bahot Aache Hai Sir Big Fan
1:- ctrl+E flash fill
2:- ctrl+pageup/ pagedown :- to jump on sheet
Shift+arrow keys :- you can select
4: - shift+space :- to select entire row
मैंने आप का वीडियो देखा और इसे देखते हुए मेरा एक शानदार अनुभव रहा सर मैंने बहुत कुछ नया सीखे आपका बहुत-बहुत आभार
3.Shift - right / down for selection for cells
5. Ctrl + space for colum space
7. Ctrl end last selection
Sir.....muje apki videos bahut pasand ayi maine in videos se 8din me poora excal with short key ke poora kiya h so bahut bahut danyabad sir apka
This Video deserves millions of views 🤗🤗
Yes
Sir you are the best teacher in the RUclips apke jaisa koi nahi padhata
I am from Pakistan.
Great work sir , your students are very lucky if they have passion of learning excel.
Please also upload uses of macros in different fields.
Nice to ask about macros
U r doing good job sir.aapke jaisa koi tutor nhi Dekha aajtak Jo itni bariki se padata ho.thnku so much and Aapka Chanel world ke har jagah No1 ho
Learned many shortcut keys from it, thank you very much for sharing such a knowledgeable video.
Thanks you sir main ne aapse bohat kuchh sikha hai our ummid hain ki aage bhi skhta rahunga thank you so much
Ap ka har video achha hai
Dekha to sab kuch hain sir but bahut confused ho gaya hu .....but vapas ek ek vedio dekhenge to yad ana chalu ho jayega so thanks you sir
BASIC SHORTCUT KEYS
Alt + F File menu options in current program
Alt + E Edit options in current program
F1 Universal help (for all programs)
Ctrl + A Select all text
Ctrl + X Cut selected item
Shift + Del Cut selected item
Ctrl + C Copy selected item
Ctrl + Ins Copy selected item
Ctrl + V Paste
Shift + Ins Paste
Home Go to beginning of current line
Ctrl + Home Go to beginning of document
End Go to end of current line
Ctrl + End Go to end of document
Shift + Home Highlight from current position to beginning of line
Shift + End Highlight from current position to end of line
Ctrl + f Move one word to the left at a time
Ctrl + g Move one word to the right at a time
शानदार जानदार जबरदस्त 👍👍 thank u so much sir for all excel tricks
its really useful video. I learnt lots of new formulas. I would like to tell you one more formula about "Filter". We can use formula Ctrl+Shift+L with this formula we can add or remove Filter from excel sheet.
Thankyou sir your explanation is very good i watch all your video and now am felling good that i know to use computer all thing thank you sir may your channel be one of the biggest channel on youtube one day💯💯
I must appreciate your efforts to make ourself updated with technology.
कम समय में काम की चीज अच्छी तरह से समझा रहे हैं गुरुदेव आपका धन्यवाद में आपका सब्सक्राइबर हूं
Dear Sir,
Complete shortcut keys in 1 video, very nice Sir 👍
All in one Excel shortcut video.
Colum unhide krne ka shortcut hai, Select two cell only for unhide colum- Alt+H+O+U+L very easy.
Please add this shortcut key in next shortcut video.
Kindly revert.
yes yes jitender ji you are right thanks for sharing will definitely add it.
@@Learn_More_Pro
I'm your lover,
Aapki video se mujhe bahut help hui hai.
Apne office me Excel me faster ki trah kaam krta hun, Ye sab Aap se hi sikha hai.
🙏🙏 Thank you Guru ji.
I AM LEARNIG VERIOUS SHORTCUT KEYS ,YOU ARE A GOOD TEACHER
Nice video sir
Sir amazing 👍 aapki teaching best he mere brain me kaafi sara utar gaya and itne sare shortcut first time dekh ra hu sir
To Apply filter we can also use
Carl+Shift +L
F4 ki nahi Pata thi pr ab chal gaya pata😊most use ful all shortcut keys amazing video🥰
In excel older version, If we use Alt+Space Bar & C to close file then all open excel files get close so instead of that we should use ctl + W will close one by one. Sorry for bad english...🙏🙂
Your English is not bad.it is alright
There are lots of shortcut keys which were unknown for me. Thank you so much for giving most informatic knowledge. Hatsoff
GREAT SIR FOR TEACHING PROCESS VERY INTERESTING
Yr muje is sir se pyar hogaya he 😅I love u ap itna acha samjhaty he ❤
1 No. Sir...
I watched full video without any skip and i got too much knowledge from this video
Thank you so much sir and make more videos for the same.
excellent work & highly appreciated , Thanks Sir
u can also use control+shift+L to apply & remove filter
Lajawaab hai aap ki collections. I amazed. Thank u so much. Aur. Bhi bahut kuch sikhna hai aapse.
kon kon 2024 m dekh rha h
Tujhe kya karna hai bhai koi bhi dekhe 🤦🏻♂️🤦🏻♂️🤦🏻♂️
i am from india
sir, your excel work is a great ......
sir your student is very lucky .....
Thank you sir
Appreciate your hard work and dedication. Superb content. 1 million sub soon😀
एकदम मस्त आणि माहितीपूर्ण चित्रफीत धन्यवाद भाऊ
Hi sir,
Thanks & appreciate that u have provided all the shortcuts in single video. unfortunately I know every single shortcut u mentioned in this video...I'm looking short cut for
1.working inside pivot table like selection of fileds
2. Selection of objects (for example we have 30 object in a sheet. I need to select 15 or or 20 objects not necessarily in order)
I am a beginer in excel try to learn from your videos now thanks sir
In shortcut no 14(repeat last action), when I press F4, a pop up menu appears with the following options-PC screen only, duplicate, extend, second screen only etc.
Bhout badiya description sir
For filter
Ctrl+shift+L
Shandaar Jandaar
Jabardast
jindabad
Wah Satish Sir
Kamal Kar Diye
It's Very Useful For All Of Us
For Filter addition and deletion you can use. Cyrl+shift+L
I didn't know how to find in complete workbook. Your method to explain the things is so good.
Ctrl + Shift + L for using filter key but make sure they are no merge columns/rows.
I had also learnt more about computer only by the help of you, because of ur explanation very nicely. Thank you.
Thank you so much to give me a wonderful short cut in excel
I see your full video
Best of luck for your channel
Thanks karan
to apply filter we can also use alt+ctrl+L
Wowwww Master ji. Very interesting. Especially your way of expression in the smiling method, no one would forget the shortcut keys.
Dear Sir, Row or column ko automatic adjust karna ka shortcut key bataye. Ya fir bina mouse ka row or column ka size kaisa adjust kare.
Plz comment
First select the data
alt+o+c+a
This will adjust automatically..
zenda baad Satish sir,
aap hamare leye rahmat ka fareshta ho......
M. Zahir Khan Safy , Kabul Afghanistan
Excellent explanation ,I can learn a lot from your channel, thank you so much for your time and effort.
Sir for me all shortcurt keys are new but i am hare for your shortcurt no.49&50 its really very help full for me thank you so much for your hard work and most important time as well as thank you 😊
FOR APPLY FILTER WE CAN USE CTRL+SHIFT+L
Thankyou so much. Some of the features i didn't know even after working in excel for a long time.
Please sometime teach how to do vertical selection in a split Excel column.
All is best video 👍❤️😎
Thank you for excel shortcut key 🙏
For Filter we can use Ctrl+Shift+L
Wonderful sir initially i was complete blank of computet knowledge but on seeing your lecture through youtube i became smart in office computer work
I am realy very greatful to you
Alt+O+C+A also adjust column size
Dobara same format me lane ke liye pls bataye
Its all the game of Alt
i m form Pakistan....You are so brilliant sir, may you succeed..
Thank you so much Habib!
Good job done 👍 GJD.
Thanks for 101 shortcuts dear brother
Starting Sir learning Excel 🙏🙏🙏
Thanks sir itna achcha video banane ke leye
Short cut key for protect sheet
1st Alt+R+P+S
2ND ALT+H+O+P
Good
Nice
Thank you aapke video se mein company mein job kar rahi hoon Mujhe Kafi Kuchh madad mil rahi hai thanks sir
Short cut key for filter apply
Ctrl + shift +L
Aap k teaching ka tarika bahut hi lazawab hai sir
CTRL+ SHIFT+ L for filter
Thank you sir for this amazing video. 🙏❤❤
shandar sir.....😊
Thank you sir😄 shortcut key aapne bahat achchha se samjha rahe hai koi koi shortcut pata tha aur aapne bata diya thank you so mach sir
Hiii sir, I have to make a VBA for in/out stock inventory
In which (in stock) date item qty Mfd Exp. Out stock date item qty given to and remains qty
Plzz help me
Good morning sir achcha shortcut hay
Alt+D+F+F simple filter shortcut key
Ctrl+shift+L
Shift +3
Alt+A+T
I am beginner, learning from your videos well
Work book doesn't gets closed by CTRL +F4. IT GETS BY PRESSING Alt +f4
Bhai ctrl+F4 sy b huta hy
Thanks you sir I has learnt many tricks from these video
Jisko bhi video achha laga like karo
Sir आप की जानकारी बहुत सुंदर है 🙏👍
एक एमआईएस रिपोर्ट कैसे बनाते हैं क्या क्या होता है please sir bata दीजिए 🙏🙏
Press "Alt+=" to auto sum..
I lost my Heart to subscribe to your channel after watching this video, SIR. #respect from my HEART. what a great learning point #learnmore
Nice jokes
Sir bolte bahut accha ho aur samjhte bhi bahut accha ho 🙏🙏❤️❤️
I have noticed no matter how much I learn, I am extremely slow at analysing data of any kind :(
Hello sir you are a great person & teacher ❤. Thank you so much sir.
God bless you 🤲❤
Where are u coching/ institute. I Learn advance excel for you.
U need grammer classes 😂
What r u talking like that ha ha ha
U nhi your
NRIT Ghatkopar West near railway station
Not "for you". It will "from you".
3-4 shortcut keys are known to me. Rest are new. Thanks for making this Video
Alt+O+C+A Column auto fit
Aap teaching mai jo jock krte hai vo bahut badia i like it
karachi pakistan
I love you ❤ Pakistan Karachi
Nice sir continue to your video I seen so many times to learn more about excel.
Sir mujhe apki intin gyan se bohot help ho raha hay