👋 Guys everyday we upload high quality in depth tutorial on your requested topic/technology so kindly SUBSCRIBE to our channel👉( bit.ly/Intellipaat ) & also share with your connections on social media to help them grow in their career.🙂
Is it indian or pakistani channel?nice channel.how to make software in ms access plz upload vedios related to software with zoom pictures.alot of thanks
Following topics are covered in this video: 1:08- Microsoft Excel Overview 4:52- Getting started with Microsoft Excel 5:33- Hands on with Microsoft excel 8:02 - Saving an Excel file 10:31- Excel Customization 13:21- Important areas of working 15:51- What is formula bar 19:18- ribbons 24:06- Formatting excel and shortcuts 33:04- Basic Formulas 50:00- Find and Replace 1:05:49- Text Functions-Formatting Data 1:39:25- count functions 1:40:45- Relative Reference 1:57:17- Absolute Reference 2:14:12- Mixed Reference 2:32:52- Data Validation 2:42:00- Different types of data validation 3:03:02- Conditional formatting 3:43:56- sorting data 4:06:15- filtering data 4:34:11- column chart 5:09:54- line chart 5:23:01- pie chart 5:36:51- protection 6:14:29- pivot tables 6:59:44- Vlookup 7:50:55- index function 7:51:51- Match function 8:30:39- lookup function 9:11:55- what is VBA 9:13:23- what is macro 9:14:37- Exploring Visual Basic Editor (VBE) 9:17:14- Using Macro Recorder 9:39:12- Recap 9:51:18- Variable, data types and constants 10:04:14- scope of a variable 10:15:09- Data Types 10:21:11- Constants
It took me 4 days to finish this video; practiced each and every exercise given. All I would want to say is a BIG Thank You for such an amazing video explaining the concepts of EXCEL; I am sure this is definitely gonna add to my skill set and help expand my career.
This is simply mind-blowing! The efforts that have been put in this lecture is commendable. 10 hours of MS-Excel in-depth tutorial video for FREE. Where do you get such deal nowadays? Make most of this video and truly excel! 🙌
Yes ur right, they are pathetic people, why can't they understand the efforts this guys have put to create such a marathon video which is very helpful....Hats off intellpat.
Hi Sir, I am Vinod, from Belgaum Karnataka. I am actually going through each and every step of the video course for last 3 Days and it is really helpful and in-depth. Thanks for sharing such a useful document. By this, you are not only sharing your knowledge but also encouraging students to learn and ready themself for employment opportunities. I personally would take this moment to thank you for sharing this session here. It's helping me a lot to upgrade my skills and now I feel confident. :)
Salute to you guys for uploading a 10hr detailed lecture on microsoft excel and that too without ads.. It took me 5days to complete it along with the practice.. small exercises on various topics were very useful.. A big thank you from my side.. Will surely recommend this video to others also..
This is the best excel video on TH-cam. I have tried another's excel courses on the same platform and eventually came across this one and must say this is the best one. Thanku for giving such a wonderful course in the best explanatory way.
Watched so many Excel courses online but to be very honest, Nothing compared to this 10 hour session. Well done !! watched it first time with normal speed and started it again at speed 1.5 😄😄
The video is of 10 hours but I am writing this comment after watching it for almost one hour. I like to congratulate the team for putting so much effort and making this topic meaningful, insightful, and helpful. The person has taught each basic requirement meticulously. For practice, if you can share your link, will be grateful....Congratulation
I have liked without watching only for the sheer effort of putting up a 10 hour full fledged tutorial for the help of others. I have good knowledge of excel hence I understand the effort. Brilliant👍
Thankyou for this video now I can learn a lot from it about excell and its usage I am a BBA 2nd year student and honestly speaking you saved my money and my time.
Just finished the video. It tooks 5 days to complete. Great video it was but you should teach macro portion more elaborately. No ads were there which was simply amazing. Teaching technique is also very good. THANK YOU VERY MUCH. 🙏❤️🇮🇳
The topics which you have covered in this video, by learning them any one can use Excel regarding anything. Infact i have solved questions related to statistics as one of my subjects in graduation. I really appreciate the efforts which you have put in this video for us, thankyou so much sir. 💕 💕
Today, I successfully completed this 10 hr long lecture and i really want to thankyou Intellipaat for such great long session. Hats off for ur efforts. 🙏🙏🙏🥳
This is absolutely the best video on youtube for learning excel that I have come across. I've been using excel for several years. However, I learned SO much more from watching this video.
Hi Aravind, thanks for your feedback. Also, share videos among your connections so that they get benefitted too. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss any videos from us.
Finally completed. Thank you so much for your efforts. It was so much detailed and informative. Can't believe i have got to finish these amazing course for free.
Hope you learned something new from this Excel tutorial. Please be kind enough to like the video and subscribe the channel. Make sure to perform hands-on side by side and feel free to ask your doubt in the comment section below.
Thank you so much sir I have completed 2 hrs of the video and learned so much from it.. and I will complete the entire video.. You have solved such a big problem so easily for all of us.. Who are looking for a better video on whole excel course.. Hats off to you sir. 👏👏👏
@@Intellipaat Sure I have subscribed your channel and now me and my mates have decided to spend few hours of our weekend improving our computer skills. Thanks a ton :) Lots of blessings and good luck from the UK.
Thank you sir! This is great. I've been trying to learn Excel, but the online courses are bit costly and here you've provided all that knowledge without any charge. Literally thank you 😀
This can be even more helpful if you add subtitles to your videos. Because, I think, a lot of people don’t fully understand English by listening. I know it will be very difficult to add subtitles to such a big video. But this is just my opinion to make the video more qualitative. BTW, this video is such a great video for me😊
@@Intellipaat well I want to lear excel but this tutorial is explained using excel 2016 but I have 2019 version can I still proceed with this tutorial? Please reply
This is obviously the best course for Excel. I am really glad you have offered us such amazing content :) Thanks a lot. Also, do you have a PPT or study material for the same? Can we download the PPT that is used in the video for explanation from somewhere please?
I will also cover power point If you wants all the tabs explaination in detail then welcome on my you tube channel named code enlight with shruti and like, share and subscribe my vedios.
Love your work Sir, perfect pace, clear voice, excellent and practical examples that drive the concepts home. I will take my time with this tutorial. Thank you for your beautiful efforts and such selfless information sharing yet comprehensive coaching. Be blessed.
I found this incredible MS Excel course that’s a 10.5-hour deep dive packed with great explanations and tons of useful info. I’ve tried a few courses on Udemy, but this one blew them all out of the water. No shade to Udemy, but this is a must-see for anyone looking to up their Excel game. Big thanks to the team who put this together!
Thank you so much for making such a wonderful course. You have got really great skill using which you explains everything in a very simple and lucid manner. Kudos 👌🏽👌🏽👌🏽
Hi Jon, thanks for your comment. sure, we will make videos on PowerPoint. It is used in a variety of ways by business organizations to provide a computerized "slide-show" for enhancing a presentation. PowerPoint might be employed to direct attention to an outline of the presentation, or to display graphs and pictures, or to focus the audience on key points.
More credit for the patience for the 10 hour long session apart from simple and easy presentation. Should have included the example file in the description so that interested viewers can practise on the same file while watching the video. Should be a practice for all educational youtubers to include sample file.
👋 Guys everyday we upload high quality in depth tutorial on your requested topic/technology so kindly SUBSCRIBE to our channel👉( bit.ly/Intellipaat ) & also share with your connections on social media to help them grow in their career.🙂
Is it indian or pakistani channel?nice channel.how to make software in ms access plz upload vedios related to software with zoom pictures.alot of thanks
Can you please send the ms PPT tutorial link?
Intellipaat Hi could u please share the excercise file?
Sir plzz upload SAP fico and MS. Excel advance video plzz sir...
You forgot to talk about Xlookup which is better alternative to Hlookup and Vlookup. anyway, I appreciate your effort for having uploaded so much.
Following topics are covered in this video:
1:08- Microsoft Excel Overview
4:52- Getting started with Microsoft Excel
5:33- Hands on with Microsoft excel
8:02 - Saving an Excel file
10:31- Excel Customization
13:21- Important areas of working
15:51- What is formula bar
19:18- ribbons
24:06- Formatting excel and shortcuts
33:04- Basic Formulas
50:00- Find and Replace
1:05:49- Text Functions-Formatting Data
1:39:25- count functions
1:40:45- Relative Reference
1:57:17- Absolute Reference
2:14:12- Mixed Reference
2:32:52- Data Validation
2:42:00- Different types of data validation
3:03:02- Conditional formatting
3:43:56- sorting data
4:06:15- filtering data
4:34:11- column chart
5:09:54- line chart
5:23:01- pie chart
5:36:51- protection
6:14:29- pivot tables
6:59:44- Vlookup
7:50:55- index function
7:51:51- Match function
8:30:39- lookup function
9:11:55- what is VBA
9:13:23- what is macro
9:14:37- Exploring Visual Basic Editor (VBE)
9:17:14- Using Macro Recorder
9:39:12- Recap
9:51:18- Variable, data types and constants
10:04:14- scope of a variable
10:15:09- Data Types
10:21:11- Constants
Is certification also important for excel ?
Thank you
salary sheet with tax ....please sir put some information about this .. tomorrow is my exam
Thank you so much bhai
Thank you
Wow, 10hours long video without a single ads, salute you man🙏🙏🙏
Hope you enjoyed it! Keep learning with Intellipaat😊
*one can not monitize a video which is advertised*
Ad kaha se aayega bro ..?
Ye video khud ad pe chal rha hai ...
@@net___________11 kya MATLAB bhai
Bqs we hv lot's mni
Learned more in 10 hours than my whole school life. A very big thank for providing every topic form basics.
You're Welcome @D luffy Keep learning with us.
You should have focused in your school
@@bharat8875 😂😂😂😂 understand his feelings bro
Yes, if we use youtube for learning, is it the best platform to learn free.
It took me 4 days to finish this video; practiced each and every exercise given. All I would want to say is a BIG Thank You for such an amazing video explaining the concepts of EXCEL; I am sure this is definitely gonna add to my skill set and help expand my career.
Great job! Kindly Subscribe to Intellipaat for more such videos. 😊
@Aditya Negi Yes, Kindly Subscribe to Intellipaat for more such videos. 😊
bare zhal ..
Is there data set given ?
How can we practice ?
@@Intellipaat thanks
This is simply mind-blowing! The efforts that have been put in this lecture is commendable. 10 hours of MS-Excel in-depth tutorial video for FREE. Where do you get such deal nowadays? Make most of this video and truly excel! 🙌
Thank you :) We appreciate your compliment.
@@Intellipaat Certificate?
You tube
Idk why this channel is sooooo underrated.They deserve 100m subscribers for educating people better than any educational institutes.
@Simran Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Because all people don't need Excel...Chapris have more subscribers.
The people those who are disliking this video ,they r fool . Because this video is really in too depth. I liked it. Thankyou sir.
Thank you for watching. :)
Yes ur right, they are pathetic people, why can't they understand the efforts this guys have put to create such a marathon video which is very helpful....Hats off intellpat.
@@somanpillai687 can you please email me the project how can I apply this video??
jawadmustafa91@gmail.com
@@Intellipaat No,..thank you for posting something so valuable as this instructional video,...for free to us. Your are most generous!!
I think the dislikes are not fools...
They may be the bloody scholars in the same field... To degrade this great work..
Started today. Have never found a better tutorial on Excel than this. The instructor is very good.
Did you get the exercise file
Glad it was helpful!
I have started my Excel learning journey from this single video😊. Thank you sir you are easy to understand.
All the best! Do like, share & subscribe to our channel to get updates on upcoming videos.
Is This helps to beginners also ???
Hi Sir, I am Vinod, from Belgaum Karnataka. I am actually going through each and every step of the video course for last 3 Days and it is really helpful and in-depth. Thanks for sharing such a useful document. By this, you are not only sharing your knowledge but also encouraging students to learn and ready themself for employment opportunities. I personally would take this moment to thank you for sharing this session here. It's helping me a lot to upgrade my skills and now I feel confident. :)
Maga Nanu Belgaum davane
Belgaum ujwal nagar, gandi nagar
Salute to you guys for uploading a 10hr detailed lecture on microsoft excel and that too without ads.. It took me 5days to complete it along with the practice.. small exercises on various topics were very useful.. A big thank you from my side.. Will surely recommend this video to others also..
Our pleasure! @Athulya Udayan This motivates us in bringing more content. Thanks a ton...!
How many hours you gave to practice each day?
@@arther6341 2hours max per day.
@@athulyaudayan4014 notes bhi banaye? Or certificate bhi mila?
i have seen yur comments on this video....now i am watching this vdo....and thanks for your valueble suggestion....
This is the best excel video on TH-cam. I have tried another's excel courses on the same platform and eventually came across this one and must say this is the best one. Thanku for giving such a wonderful course in the best explanatory way.
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Watched so many Excel courses online but to be very honest, Nothing compared to this 10 hour session. Well done !! watched it first time with normal speed and started it again at speed 1.5 😄😄
Glad it was helpful! @Mohamed Oualkadi Do like, share & subscribe to our channel to get updates on upcoming videos.
@@Intellipaat the only negative side is, not having access to the spreadsheet for practice.
Is that something that can be shared ?
The video is of 10 hours but I am writing this comment after watching it for almost one hour. I like to congratulate the team for putting so much effort and making this topic meaningful, insightful, and helpful. The person has taught each basic requirement meticulously. For practice, if you can share your link, will be grateful....Congratulation
@Niharika Roy Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Can i pls get a link to the excel file being used for this video
Best video for Excel without any advertisement and each and every topic covered property ... highly recommend
Thanks for watching😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Kindergarden to graduation! Thank you bro!🤩😍
🥳
@@Intellipaat please provide the dataset
Your efforts are highly appreciated, its life saver.
Those who dislike the video- stand in front of mirror and answer yourself;
Its really needed.
Thanks a lot!
Hii Bhai aapse thoda jankari chahiye kya aap btayege
What a course man!! It's 1 hour and 36 minutes i watched so far in this video. I already learned 9 formula and so much shortcuts😮
Love this course 😍
Glad you liked it. Keep learning with Intellipaat😊
you won't be able to learn without practice filee
@@kamalmalik3048 i use mokaroo or data generator's free dummy file to practice.
@@sarker. please share too me at kamalrocks2590@gmail.com
@@kamalmalik3048 watch this video and it'll crystal clear for you
th-cam.com/video/jsq-4E-tFF4/w-d-xo.html
I have liked without watching only for the sheer effort of putting up a 10 hour full fledged tutorial for the help of others. I have good knowledge of excel hence I understand the effort. Brilliant👍
You're very welcome! :)
Thankyou for this video now I can learn a lot from it about excell and its usage I am a BBA 2nd year student and honestly speaking you saved my money and my time.
Thank you for the feedback. This motivates us to bring more quality content to you guys!
I have only seen one minute of this video and I believe it will be everything I want to learn. Than you for taking your time to teach this program.
Glad to know that. Happy Learning!
Indians are continuing to save the world with their videos, bless you! Greetings from Turkey
Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
One of the best videos, I have ever come across. Kudos to your efforts.
Wow, thanks!
@@Intellipaat yes sir, we need experts like you
10 hrs without breaks and smooth explanation really very thankful to u sir.
You're Welcome @arnakonda serina Keep learning with us.
Just finished the video. It tooks 5 days to complete. Great video it was but you should teach macro portion more elaborately.
No ads were there which was simply amazing. Teaching technique is also very good.
THANK YOU VERY MUCH.
🙏❤️🇮🇳
Welcome and we are glad it was helpful. @Anik Dandapath Do like, share & subscribe to our channel to get updates on upcoming videos.
The topics which you have covered in this video, by learning them any one can use Excel regarding anything. Infact i have solved questions related to statistics as one of my subjects in graduation. I really appreciate the efforts which you have put in this video for us, thankyou so much sir. 💕 💕
@Partha Pratim Ojha Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
It's 11.30 pm. Will start learning tomorrow morning.
Subscribed.
Thank you!
Today, I successfully completed this 10 hr long lecture and i really want to thankyou Intellipaat for such great long session. Hats off for ur efforts. 🙏🙏🙏🥳
Wonderful! you are always Welcome @Shravi Pujari Do like, share & subscribe to our channel to get updates on upcoming videos
Rare thing which we can't find in u tube 10hrs that to for free.. salute sir..
Thank you Madhu, Keep learning with Intellipaat😊
@@Intellipaat please provide the dataset zip file used in course
Rare thing you will not find the dataset to learn this course 😂😂😂😂
This is absolutely the best video on youtube for learning excel that I have come across. I've been using excel for several years. However, I learned SO much more from watching this video.
Keep learning @Jp-cv800
I got into fight with my teacher today because she was not teaching properly thank god I got your video 😂🙏🙏
Hahaha, Keep learning with Intellipaat😊
So how you practiced it without the dataset 😂😂😂😂
@@Intellipaat how can we learn when we don't have the source files
You should change 😂
First of all thank you for making this video in english 🙏
@Arjun Ca Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you so much sir.... Today I've completed Excel full course and it made me confident about my career boostup ❤️❤️💓😊❤️🔥
All the best
Thanks you IntelliPaat...for providing the so many courses at free cost..hats off to your team
Hi Aravind, thanks for your feedback. Also, share videos among your connections so that they get benefitted too. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss any videos from us.
Thank you so much. Excellent tutorial. I am 60 years old and a retired banker. 😀👍
@Ramaprasad Chintapalli Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
This is what I need 👏👏👏👏👏👏
I will try to complete this by practising every day
You got this! @Be happy Do like, share & subscribe to our channel to get updates on upcoming videos.
The Data Validation lecture was amazing. I used it to audit Pettycash in the company I worked for. Very educative and helpful
Superb course 💯😻👌👌Thank you for sharing knowledge. Really enjoyed 🎉
Glad you liked it! Keep Learning with Intellipaat😊
This tutorial is BEST for learning MICROSOFT EXCEL .....PERFECT..
Glad you liked it @Faraz Siddiqui Do like, share & subscribe to our channel to get updates on upcoming videos.
I am pretty sure that I would not find any better video other than this for Excel..👍
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
I appreciate your teaching so much.I'm all ways grateful to u 😊😊
Glad to hear that
You're a true educator man....🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thank you @Tushar raja Do like, share & subscribe to our channel to get updates on upcoming videos.
i will just say. ...don't go anywhere because everything is here❤️❤️❤️
Thank you. Kindly Subscribe to Intellipaat for more such videos. :)
@@Intellipaat did it already sir👍
Superb superb superb...teaching ..mind blowing sir....keep it up 🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳
Thank you so much 😀 @Nirmal Upadhyay Do like, share & subscribe to our channel to get updates on upcoming videos
@@Intellipaat always and forever welcome sir...and also i had already subscribed from 3 accounts 🙏🙏🙏🙏🙏
Wow so beautiful class 🥰👍🏻💥💥
@Jaya Prabha Thanks for watching😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
You are a lifesaver bro I sincerely like to thank you personally tq bro so much🙏🙏🙏🙏
Great platform to learn new courses...And without ads, it's too good...Thanks to IntelliPaat...
No words to explain your effort sir! Thank you so much 🙏🥰
Most welcome 😊 @Vaibhav Wantamutte Do like, share & subscribe to our channel to get updates on upcoming videos.
It is very helpful.... No words to appreciate... Thank you So much
Most welcome 😊 @anvinis world Do like, share & subscribe to our channel to get updates on upcoming videos.
Finally completed. Thank you so much for your efforts. It was so much detailed and informative. Can't believe i have got to finish these amazing course for free.
@Shinido Welcome .Do like, share & subscribe to our channel to get updates on upcoming videos.
This is very impressive. I salute you for offering a briliant course.
@Logical Network Thank you very much! Do like, share & subscribe to our channel to get updates on upcoming videos.
The lecture was very helpful. I learnt a lot about excel. Thank you!!!
Join me for ... Computer course in Urdu ???
Amazing and great informative vedio........My daughter had no more doubts about excel.......
That's great. @Binayak Academy Do like, share & subscribe to our channel to get updates on upcoming videos.😊
Wow...10 hours... Lots of efforts
Thank you. Do SUBSCRIBE to our channel to get more such interesting live sessions.
probably the best excel tutorial on TH-cam
Glad you liked it. Keep learning with Intellipaat. :)
Best video on Excel.. super easy 🎉thank you 💯
Appreciate your kind words. Please subscribe to our TH-cam channel to come across more videos like this one.
Thank-you so much it will help me a lot....such a detail cls
Glad it was helpful. Keep learning with Intellipaat. :)
Hope you learned something new from this Excel tutorial. Please be kind enough to like the video and subscribe the channel. Make sure to perform hands-on side by side and feel free to ask your doubt in the comment section below.
Sir... please make VBA Full course
Helpful for beginner
Please I have problem with protection sectionc
@@barakahobileye5643 श्रौं दक्ष
आपने बहुत मेहनत की है इसे बनाने मैं और वास्तव में बहुओं अच्छी वीडियो है एक्सेल की।👍👍
Thank you for the feedback. This motivates us to bring more quality content to you guys! :)
Sir please upload lecture of Ms word with useful shortcuts to improve work efficiency
Sure . Noted. Will upload soon. :)
Join me for ... Computer course in Urdu ???
Shortcut Keys System!!
CTRL+A. . . . . . . . . . . . . . . . . Select All
CTRL+C. . . . . . . . . . . . . . . . . Copy
CTRL+X. . . . . . . . . . . . . . . . . Cut
CTRL+V. . . . . . . . . . . . . . . . . Paste
CTRL+Z. . . . . . . . . . . . . . . . . Undo
CTRL+B. . . . . . . . . . . . . . . . . Bold
CTRL+U. . . . . . . . . . . . . . . . . Underline
CTRL+I . . . . . . . . . . . . . . . . . Italic
F1 . . . . . . . . . . . . . . . . . . . . . . Help
F2 . . . . . . . . . . . . . . . . . . . . . Rename selected object
F3 . . . . . . . . . . . . . . . . . . . . . Find all files
F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs
F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window
F6 . . . . . . . . . . . . . . . . . . . . . Shifts focus in Windows Explorer
F10 . . . . . . . . . . . . . . . . . . . . Activates menu bar options
ALT+TAB . . . . . . . . . . . . . . . . Cycles between open applications
ALT+F4 . . . . . . . . . . . . . . . . . Quit program, close current window
ALT+F6 . . . . . . . . . . . . . . . . . Switch between current program windows
ALT+ENTER. . . . . . . . . . . . . . Opens properties dialog
ALT+SPACE . . . . . . . . . . . . . . System menu for current window
ALT+¢ . . . . . . . . . . . . . . . . . . opens drop-down lists in dialog boxes
BACKSPACE . . . . . . . . . . . . . Switch to parent folder
CTRL+ESC . . . . . . . . . . . . . . Opens Start menu
CTRL+ALT+DEL . . . . . . . . . . Opens task manager, reboots the computer
CTRL+TAB . . . . . . . . . . . . . . Move through property tabs
CTRL+SHIFT+DRAG . . . . . . . Create shortcut (also right-click, drag)
CTRL+DRAG . . . . . . . . . . . . . Copy File
ESC . . . . . . . . . . . . . . . . . . . Cancel last function
SHIFT . . . . . . . . . . . . . . . . . . Press/hold SHIFT, insert CD-ROM to bypass auto-play
SHIFT+DRAG . . . . . . . . . . . . Move file
SHIFT+F10. . . . . . . . . . . . . . . Opens context menu (same as right-click)
SHIFT+DELETE . . . . . . . . . . . Full wipe delete (bypasses Recycle Bin)
ALT+underlined letter . . . . Opens the corresponding menu
PC Keyboard Shortcuts
Document Cursor Controls
HOME . . . . . . . . . . . . . . to beginning of line or far left of field or screen
END . . . . . . . . . . . . . . . . to end of line, or far right of field or screen
CTRL+HOME . . . . . . . . to the top
CTRL+END . . . . . . . . . . to the bottom
PAGE UP . . . . . . . . . . . . moves document or dialog box up one page
PAGE DOWN . . . . . . . . moves document or dialog down one page
ARROW KEYS . . . . . . . move focus in documents, dialogs, etc.
CTRL+ > . . . . . . . . . . . . next word
CTRL+SHIFT+ > . . . . . . selects word
Windows Explorer Tree Control
Numeric Keypad * . . . Expand all under current selection
Numeric Keypad + . . . Expands current selection
Numeric Keypad - . . . Collapses current selection
¦ . . . . . . . . . . . . . . . . . . Expand current selection or go to first child
‰ . . . . . . . . . . . . . . . . . . Collapse current selection or go to parent
Special Characters
‘ Opening single quote . . . alt 0145
’ Closing single quote . . . . alt 0146
“ Opening double quote . . . alt 0147
“ Closing double quote. . . . alt 0148
- En dash. . . . . . . . . . . . . . . alt 0150
- Em dash . . . . . . . . . . . . . . alt 0151
… Ellipsis. . . . . . . . . . . . . . . . alt 0133
• Bullet . . . . . . . . . . . . . . . . alt 0149
® Registration Mark . . . . . . . alt 0174
© Copyright . . . . . . . . . . . . . alt 0169
™ Trademark . . . . . . . . . . . . alt 0153
° Degree symbol. . . . . . . . . alt 0176
¢ Cent sign . . . . . . . . . . . . . alt 0162
1⁄4 . . . . . . . . . . . . . . . . . . . . . alt 0188
1⁄2 . . . . . . . . . . . . . . . . . . . . . alt 0189
3⁄4 . . . . . . . . . . . . . . . . . . . . . alt 0190
PC Keyboard Shortcuts
Creating unique images in a uniform world! Creating unique images in a uniform world!
é . . . . . . . . . . . . . . . alt 0233
É . . . . . . . . . . . . . . . alt 0201
ñ . . . . . . . . . . . . . . . alt 0241
÷ . . . . . . . . . . . . . . . alt 0247
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
MICROSOFT® WINDOWS® SHORTCUT KEYS
Alt + Tab Switch between open applications
Alt +
Shift + Tab
Switch backwards between open
applications
Alt + Print
Screen
Create screen shot for current program
Ctrl + Alt + Del Reboot/Windows® task manager
Ctrl + Esc Bring up start menu
Alt + Esc Switch between applications on taskbar
F2 Rename selected icon
F3 Start find from desktop
F4 Open the drive selection when browsing
F5 Refresh contents
Alt + F4 Close current open program
Ctrl + F4 Close window in program
Ctrl + Plus
Key
Automatically adjust widths of all columns
in Windows Explorer
Alt + Enter Open properties window of selected icon
or program
Shift + F10 Simulate right-click on selected item
Shift + Del Delete programs/files permanently
Holding Shift
During Bootup
Boot safe mode or bypass system files
Holding Shift
During Bootup
When putting in an audio CD, will prevent
CD Player from playing
WINKEY SHORTCUTS
WINKEY + D Bring desktop to the top of other windows
WINKEY + M Minimize all windows
WINKEY +
SHIFT + M
Undo the minimize done by WINKEY + M
and WINKEY + D
WINKEY + E Open Microsoft Explorer
WINKEY + Tab Cycle through open programs on taskbar
WINKEY + F Display the Windows® Search/Find feature
WINKEY +
CTRL + F
Display the search for computers window
WINKEY + F1 Display the Microsoft® Windows® help
WINKEY + R Open the run window
WINKEY +
Pause /Break
Open the system properties window
WINKEY + U Open utility manager
WINKEY + L Lock the computer (Windows XP® & later)
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
WORD® SHORTCUT KEYS
Ctrl + A Select all contents of the page
Ctrl + B Bold highlighted selection
Ctrl + C Copy selected text
Ctrl + X Cut selected text
Ctrl + N Open new/blank document
Ctrl + O Open options
Ctrl + P Open the print window
Ctrl + F Open find box
Ctrl + I Italicize highlighted selection
Ctrl + K Insert link
Ctrl + U Underline highlighted selection
Ctrl + V Paste
Ctrl + Y Redo the last action performed
Ctrl + Z Undo last action
Ctrl + G Find and replace options
Ctrl + H Find and replace options
Ctrl + J Justify paragraph alignment
Ctrl + L Align selected text or line to the left
Ctrl + Q Align selected paragraph to the left
Ctrl + E Align selected
@@Intellipaat from last 1 year you haven't uploaded. hOw much more soon you are thinking to thinking. 1 year is soon enough
@@Intellipaat please share practice file used in course
Absolutely loved it. Took my time and practiced everything. Thanks a lot.
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you so much sir I have completed 2 hrs of the video and learned so much from it.. and I will complete the entire video.. You have solved such a big problem so easily for all of us.. Who are looking for a better video on whole excel course.. Hats off to you sir. 👏👏👏
So nice of you @Jagriti Shaw Do like, share & subscribe to our channel to get updates on upcoming videos.😊
Glad you liked it!! @Jagriti Shaw Do like, share & subscribe to our channel to get updates on upcoming videos.
This is the best and the most informative video I have seen for Excel. Thank you Intellipaat :)
Glad it was helpful. Keep learning with Intellipaat. :)
Thank you so much, may your life full of happiness
I have learnt alot from this video. It's the best ❤️❤️❤️. For the first time I have felt I have used my in data the right way.
Glad it was helpful! @Extrovert Do like, share & subscribe to our channel to get updates on upcoming videos.😊
Watch at playback speed 1.5x and save a good amount of time.
The time will be lost in a different way as we are not assimilating it.!
Awesome bro! May be u should provide certificate for those of us watching the video entirety 😂
😅
😂
Free mein itna accha sikhaya meri job lag gayi is video ke help se thank u so much brother..
we're glad that our video helped you in getting job. keep learning :- )
Excellent course...Thank You so much for creating such a interactive content...It helped a lot
Most welcome! 😃
Thank you for making a full coverage of this topic. This is really helpful for people like me who struggle in excel.
Welcome😊
Very nice complete, simple language... Must share. ❤❤❤
@Navnath Jagtap Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
This kind of learning lecture should be uploaded more and more
Thank you. Keep learning with Intellipaat😊
I had weekend learning session of this video with my friends, and it was very helpful for all of us in terms of learning Excel. Thanks a million.
Glad it was helpful. Keep learning with Intellipaat. :)
@@Intellipaat Sure I have subscribed your channel and now me and my mates have decided to spend few hours of our weekend improving our computer skills. Thanks a ton :) Lots of blessings and good luck from the UK.
Join me for ... Computer course in Urdu ???
I had gone through the complete video. It is very useful and I have learned lot of things. Thanks for the video.
Glad it was helpful! @Linesh ak Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you sir! This is great.
I've been trying to learn Excel, but the online courses are bit costly and here you've provided all that knowledge without any charge.
Literally thank you 😀
You're Welcome @Nikita Rora Do like, share & subscribe to our channel to get updates on upcoming videos.
Excellent work , Very good to share the knowledge to everyone for free.
Long live your channel🙏🙏🙌🙌
Thank you @Nitish Rawat Do like, share & subscribe to our channel to get updates on upcoming videos.
This can be even more helpful if you add subtitles to your videos. Because, I think, a lot of people don’t fully understand English by listening.
I know it will be very difficult to add subtitles to such a big video. But this is just my opinion to make the video more qualitative.
BTW, this video is such a great video for me😊
Hi @Abdullah Junaid Sajeed Our Content team is working on it, we will try to upload them soon. Keep learning with Intellipaat:- )
Very nice
Thank You very much for your great effort in doing this great training excel video. God Bless You 🙏🙏🙏
Welcome. Please stay tuned to Intellipaat😊
Super duper 💓💓 💗💗 guru ji...
Thank You @Tyro Channel. Do like, share & subscribe to our channel to get updates on upcoming videos.
Thanks for such a great work
Welcome Sahil. Keep learning with Intellipaat😊
THIS WILL HELP ME TO DEVELOP MY SKILL THANK YOU
how it will improve when you don't have spreadsheet to practice of this course
Very useful video 👍
Good information 👌
Thanks for full video ❤️💯
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thanks A Ton Man !! Keep Doing Great work !!!
Welcome. :) Keep learning with Intellipaat. :)
Very nicely explained. In-detailed. Thank you for this helpful tutorial complete brush-up of the knowledge. Keep it up!
Thank you for watching. :)
Join me for ... Computer course in Urdu ???
@@Intellipaat well I want to lear excel but this tutorial is explained using excel 2016 but I have 2019 version can I still proceed with this tutorial? Please reply
It's a great video that gives complete knowledge about excell .... 🔥
Glad you think so! @Priyaranjan .Vk18 Do like, share & subscribe to our channel to get updates on upcoming videos.
Commendable efforts to bind up important topics of excel in a free module. Thanks and keep going.
Thank you for watching.
if not available then how can we learn and practice. Also what was of use to upload on TH-cam then if we cannot practice
This is obviously the best course for Excel. I am really glad you have offered us such amazing content :) Thanks a lot.
Also, do you have a PPT or study material for the same? Can we download the PPT that is used in the video for explanation from somewhere please?
I will also cover power point If you wants all the tabs explaination in detail then welcome on my you tube channel named code enlight with shruti and like, share and subscribe my vedios.
I have
@@varunmalhotra666can uh share me those...??
hey can you share @@varunmalhotra666
It is an amazing video to learning Excell properly.... Thank you so much🙏..
@soma santra Glad you liked it, Do like, share & subscribe to our channel to get updates on upcoming videos.
Love your work Sir, perfect pace, clear voice, excellent and practical examples that drive the concepts home. I will take my time with this tutorial.
Thank you for your beautiful efforts and such selfless information sharing yet comprehensive coaching. Be blessed.
Glad it was helpful! @Theko Ntuli Do like, share & subscribe to our channel to get updates on upcoming videos.😊
Sir, you are doing great job , keep it up. God bless you
Thank you for watching. :)
Join me for ... Computer course in Urdu ???
I found this incredible MS Excel course that’s a 10.5-hour deep dive packed with great explanations and tons of useful info. I’ve tried a few courses on Udemy, but this one blew them all out of the water. No shade to Udemy, but this is a must-see for anyone looking to up their Excel game. Big thanks to the team who put this together!
Thank you so much for your kind appreciation! Do subscribe to our channel, as we continuously come up with technical contents like this.
Thank you so much for making such a wonderful course. You have got really great skill using which you explains everything in a very simple and lucid manner. Kudos 👌🏽👌🏽👌🏽
Join me for ... Computer course in Urdu ???
U
Un o
Sir i just love this chanel, but for students i think the most important ms application is powerpoint... Plz make a tutorial on it
Hi Jon, thanks for your comment. sure, we will make videos on PowerPoint. It is used in a variety of ways by business organizations to provide a computerized "slide-show" for enhancing a presentation. PowerPoint might be employed to direct attention to an outline of the presentation, or to display graphs and pictures, or to focus the audience on key points.
To learn more about Excel use this one..th-cam.com/video/hW1jArb7wVU/w-d-xo.html
Technologies
very nice and good 😊
@@Intellipaat sir, please give the video link of PowerPoint learning.
@@Intellipaat can you please send me the project so that I can practice
My email address is as follows
jawadmustafa91@gmail.com
Great content just finished it after taking 5 days. Thanks so much. 😊
@Swanky Bustle Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you sir for sharing ur knowledge :)
@Sriram Pavan kumar Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Simple, deep and informative. Watching for 2 days. Congratulations. If possible make a course on ms access 2013. Thank you.
Salute sir... 10 hrs video... 🙏🙏
Thank you.
More credit for the patience for the 10 hour long session apart from simple and easy presentation. Should have included the example file in the description so that interested viewers can practise on the same file while watching the video. Should be a practice for all educational youtubers to include sample file.
sure, we will do that
@@Intellipaat still waiting