If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.
@nasma.e7440 Жыл бұрын
12:22 Cool trick 👍👍👍
@jadhavnamdev14 жыл бұрын
I always wonder how do speak this well without any gaps and errors. And your excel videos are unique on KZbin. I have improved a lot, thank you sir.
@user-wt8pg4iy4d3 жыл бұрын
Thank you! I finally find an excel tutorial Channel that I am excited to come and learn new things from. Very well explained and informative. I really enjoy the presentation 😊
@keithau81594 жыл бұрын
Yes,genius,genius and genius at all@@@@@
@RollinShultz3 жыл бұрын
Good video. I am a keyboard heavy user and I remember way back when I started using excel searching for the less obvious shortcuts like ctrl + page up/down for changing sheets, as I knew there must be a keyboard shortcut for it. Although I knew most of the ones here already, there were a couple new ones for me. I found the presentation very clear and concise. I would add that the shortcut ctrl + tab works in all MS Office programs to switch between instances. For example : if you are in Word and use it you switch to the next open word document.
@munishmittal96343 жыл бұрын
Excellent
@wayneedmondson10653 жыл бұрын
Hi Sumit. Thanks for sharing this great list of tips and shortcuts. Thumbs up!!
@akanshagarg17074 жыл бұрын
Really this video has proved to be very useful with completely apt content and excellent presentation Thankyou
@StretchFletcher5 жыл бұрын
Awesome Sumit. You are a gem. Thanks.
@trumpexcel5 жыл бұрын
Thanks for commenting Stretch.. Glad you found it useful!
@devendrabain77485 жыл бұрын
Very useful video. I believe these shortcuts will tremendously save my time.
@yyz74364 жыл бұрын
Thumbs up given saved and subscribed as well . Thank you excellent lessons 🇨🇦
@mohamedhussein40654 жыл бұрын
Awesome!, its very very very useful hints and thanks a lot for the good brief informative presentation.
@sujeettimex2 жыл бұрын
Very Useful for me...! Thanks.
@venukrishna84532 жыл бұрын
Ultimate video.. Thank you so much
@JohnFranciskanjirathingal4 жыл бұрын
Easy explanation and wonderful sound
@vishalsheth5064 жыл бұрын
Nice short-cuts ....Few of them are new for me..Thanks...
@sagarpullam49673 жыл бұрын
Who ever is watching these videos want to learn shortcut for excel keyboard shortcuts.. here is the simple trick.. open excel and press Alt key it will highlight the shortkey with underline for each option.. for example F for "File"..likewise remaining.. check it..
@trumpexcel3 жыл бұрын
Great tip Sagar. Most of the shortcuts can be learned with this technique
@nagaraju25443 жыл бұрын
Thank you. These are very useful tips in day to day work activities in a job
@dlsgl4073 жыл бұрын
Thank you - so many tips I'm going to use tomorrow!
@karthikvisvennbala77763 жыл бұрын
Brother, you are excellent.
@kirandeepchoudhry92325 жыл бұрын
Awesome Puneet specially moving row with shift key
@TVSCDN3 жыл бұрын
Thanks❤🌹🙏
@shahabuddinshareefsyed90533 жыл бұрын
Most excellent video I have came across related to Excel tips
@ashishgosai114 жыл бұрын
Thanks it's too much useful
@VikasSingh-em3ol5 жыл бұрын
Nice and very helpful video for excel learner.
@denkydoo64565 жыл бұрын
Thanks for this.👍👍👍
@anitamalhiot32043 жыл бұрын
Liked & subscribed - I learned a lot - thank you!!!
@jilaygandhi29964 жыл бұрын
Really useful in day to day life Thank you
@Chenna_Reddy112 жыл бұрын
Thank you so much worthful videos
@DineshPal-nw1ss2 жыл бұрын
very nice and use ful
@mathewsebastin1773 жыл бұрын
unbelievable formula ,.. thank q sir,..
@dayakarreddy1433 жыл бұрын
Really very nice Video, saving lot of time with his tips. Thank you so much 👍🙏
@meetkcs4 жыл бұрын
Ctrl + Awesome Super collection and the way u r demonstration is excellent sir
@meetkcs4 жыл бұрын
Doubt: Is there any shortcut key combination to: Drag formula to entire column... Ex: if we write formula in cell A1, normmaly we drag to below all cells.... So any shortcut key combination for such...??
@anjalirathore90314 жыл бұрын
Amazing superb👌
@maheshvenkatesan6175 жыл бұрын
Superb.... Kudos...
@heshamfouad88865 жыл бұрын
Thanks Summit, you really helped me countless times in excel I just suggest you also make a note about the Quick Access toolbar, for the shortcuts that are not easy as an example I currently have Paste As Value in ALT + 1 & Format Painter in Alt + 4 and so on Again thanks for the video
@trumpexcel5 жыл бұрын
Thanks for commenting Hesham.. And a great suggestion. Definitely something I should consider for another video.
@rabdu20024 жыл бұрын
Dear Hesham, How you past as a value by using ALT+1 as well as format painter in ALT+4 please clarify
@trumpexcel4 жыл бұрын
When you add icons to QAT, you can access these using the ALT key. Press the ALT key and you will see number appear in the QAT. That becomes their keyboard shortcut
@master_jk65093 жыл бұрын
Thanks a lot. your video is most useful
@jayaprakashnkl4 жыл бұрын
REALLY GOOD AND VERY USEFUL. THANKS
@AmitKumar-gy9np3 жыл бұрын
Good job brother
@khalidmohamed25694 жыл бұрын
I LOVE YOUR VIDEOS DUE TO THAT I SUBSCRIBED TO YOUR CHANNEL
@erpdept45193 жыл бұрын
Superb!!
@rayeesahmadbhat27233 жыл бұрын
Perfect speaking ....💖
@kadirjattani64914 жыл бұрын
All perfectly working thanks summit
@heliosfoods28642 жыл бұрын
Great video out there
@tajumir48 Жыл бұрын
Best one ever❤❤
@JumpRopeVeteran4 жыл бұрын
Thank you man. This is great.
@vikas23773 жыл бұрын
Fantastic!!
@triptypes3 жыл бұрын
very good!!
@Nimmavmurthy5 жыл бұрын
Thank you so much bro I thought some shortcuts in this video...
@huzaifamukhtar69192 жыл бұрын
Kamaal Excel Teacher
@briandennehy63805 жыл бұрын
Awesome. It would be next level if you could make your own keyboard shortcuts.
@trumpexcel5 жыл бұрын
Glad you found it useful... Excel allows creating your own shortcuts using VBA. So you can have a VBA macro that will run with a keyboard shortcut
@cishqichannel35394 жыл бұрын
Good lesson
@madelynemily81954 жыл бұрын
good informations
@madelynemily81954 жыл бұрын
Love you
@ramuthadaka2 жыл бұрын
Can you please explain paste special works in when applied filter
@nasimhasan23514 жыл бұрын
Perfect! Thanks
@prakashsathyapriya4 жыл бұрын
Lot of thanks for this video. It's an eye opener. I have a doubt and hope you would clarify. I have a numerical dataset with decimals. Unfortunately in one cell i have two dots, so the values are not counted. How to find out these errors.
@brijeshshah5743 жыл бұрын
At 4:36 To select the whole data you have to select Ctrl + Shift + *. (PS: Cursor must in anywhere in the data set)
@richardnaylor9102 жыл бұрын
Good video
@sunpasirithxssunpasiri47593 жыл бұрын
Very useful please, I have questions: 1)If i wanna remove the row as filter, and no need the otherline as not fillers removed out, what sholu i do pls? 2) How to do zoom in-out, druing present pls?
@rushikeshkadam83503 жыл бұрын
This is Great..!!
@simuislam57522 жыл бұрын
Good ❤
@swapna_learner2 жыл бұрын
Thank you for the shortcuts video. Just one observation, below generally work on US or UK keyboard. Change of keyboard settings might not work and one has to depend on mouse
@mohamedadjal85023 жыл бұрын
Hi, Professor, you have provide in a lot of effort for these videos, thank you, I have a question if we have for example in cell "a1" the number 10.00 m, how to have this number with the same format in cell "b1 "using the text function or some other function, thank you very much.😃👍
@sirjay33003 жыл бұрын
Hello Sir Summit Bansal.. i am really fun of your youtube channel esp. the excel video tutorials for with you I was able to create some excel formatting or can i called it excel program that realy makes my job and even my colleagues to save most of our time in doing such, like tallying of data. Before it would take almost a day to do it but because of what ive learned it would only take a single copy and paste then boom. With this, i would like to ask for your help. Will there be a chance in the excel where if you copy a data in merged cells it could be pasted in a single unmerged cell? Thank you so much Sir!! God bless you😍😍😍
@manaragforms4 жыл бұрын
thank you so much, If I want to get average of formatted cells it gives error what can i do ?
@surajbhangupta90994 жыл бұрын
Thanks sir
@maheshsanghani63803 жыл бұрын
do you agree , if all short cuts are tabulaed in excel , it will help all a lot .
@sakawathossainshohag1114 жыл бұрын
What is the shortcut to hidden row and column bhaia?
@Jegan_Kanthasamy5 жыл бұрын
Instead of using Alt E S for paste special we can use Alt Ctrl V to open the paste special dialogue box.
@trumpexcel5 жыл бұрын
Both of these shortcuts would work. I used to use Control Shift V earlier, but I Find ALT E S easier to use
@Vincent-cg9qr4 жыл бұрын
Thank you, Alt E S does not work in French Excel ! I need this shortcut sooooo often !!
@joelsimbran16944 жыл бұрын
hi.. how to use format painter in different rows at one go? is there a shortcut? thanks in advance!
@thenegizone2215 жыл бұрын
Hi summit this video is so useful. Could you help me how can i do right click on sheets without using mouse in excel workbook. And when rows are blank in excel data then ctrl+shift+L is helpful for using filter in whole data or not.
@trumpexcel5 жыл бұрын
For right-click without mouse, there is a key in the keyboard, just right to the Control Key. If you don't have that, try Shift + F10. And for filter, if you want to apply it to the entire data set (that may have blank rows), first select the entire data set and then apply the Filters.
@sumitjaiswal43913 жыл бұрын
Kuch naya keyboard shortcuts batayein sir
@triptypes3 жыл бұрын
Additional I can say Ctrl+Alt+V "Paste Special" Shortcut
@Gohan_dk3 жыл бұрын
Absolutely correct which I daily use ...
@hhamilton63914 жыл бұрын
my version of excel looks nothing like yours. mine is 2016 what version are you using?
@hareesh23573 жыл бұрын
👌🏻👌🏻👌🏻
@VikasSingh-em3ol5 жыл бұрын
I am a student of BA and want to work in Excel. Is there any future job in Excel? Please sir guide me and give me suggestion. How to improve your skill in Excel to advanced level?
@sathyanarayana1475 жыл бұрын
how to copy the data from bottom cell to upper cell
@trumpexcel5 жыл бұрын
I don't know of any shortcut for this. May be use the longer route of copying, going to the upper cell and then pasting.
@rajendramehra46514 жыл бұрын
@ mai 1k company mai working hyun mere under mai 72 empoly hai,and we 2015 se kaam kar rahe hai ,mere pass unka pura sale data hai 5 saal kaa with empoly id to mujhe unko ye data each candidate ko dena hai har 5 din ke baad jaise hi unka data khatam ho jata hai fir jab mai unko data send karu to mujhe kaise pata chalega ki maine unko kaha tak data aur jab tak kaa data diya hai... please shoot video on this and please please please revert sir..
@mbahkopi2 жыл бұрын
Not work on mac version. Im
@swamivivekanandgovtmodelsc67805 жыл бұрын
CTRL+E NOT WORK IN MY EXCEL
@trumpexcel5 жыл бұрын
Flash fill is only available in Excel 2013 and later versions. Any chance you're using Excel 2010 or prior versions?