👋 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! 🙌
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. :)
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
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.
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.
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. 🙏❤️🇮🇳
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..
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 😄😄
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👍
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. 💕 💕
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.
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.
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. 🙏🙏🙏🥳
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 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.
I'm watching this video at length, along with the exercises, then I'll do some interview questions and some project. Thank you sir for explaining everything so well and providing education for free. I am a fresher from Andhra Pradesh and looking for jobs to support my family. Your content is helping me a lot.
This is just an overview of the subject. If you wish to learn from top experts and get a certification, then kindly call our course advisors on IND: +91-7z022374614 US: 1-800-216-8930 (Toll-Free).
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. 👏👏👏
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 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 😀
Dear Sir, In relative reference chapter you have shown a wrong formula for profit. Hence the amount which is showing is negative. The right formula for Profit is (Total - tax - investment = Profit) e.g movie 1 - total sale ticket = 10500 therefore your profit is 10500-2000-8000=500
@@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 so much for your kind words! We're glad you found the video helpful. 😊 Do like and share the video & subscribe to our channel to be at the top of your career.
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 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.
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 👌🏽👌🏽👌🏽
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.
Sir it would have been great if you have provided the excel problems so that we could simulate that too...because listening to your lecture and building a new poblem worksheet is taking too much of time...also matching with your data would have been great to check the result when doing by own before your explanation
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.
Hi Akhil, sure the team is already working on Java course. Meanwhile you can watch our MS SQL full course, which is also quite important for college projects and subjects: th-cam.com/video/JTDK6r1GuUU/w-d-xo.html
Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.
Sir please upload all the sheets that you have used in a drive and upload the drive link in the description that will be really helpful for us and for you too because most of the time people skip the video as they don't see the material which hinders the reach of the video. Kindly look into it.
Hi Raghu, glad you liked our videos. Will forward the topic to the respective team and will upload that video soon. Meanwhile please subscribe to Intellipaat channel and press the bell icon so that you don't miss that video from us.
Sir You are doing very amazing work for giving education I have started the video in morning and after some time I took break like this way I completed video in evening sir thanks to teach excel to me and my brother 🙂🙂🙂🙂🙂🙂🙂🙂🙂👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻🥺👏🏻👏🏻👏🏻👏🏻😃😃bye sir
Thank you so much for this profound knowledge. You guys are doing a great job.. Keep it up But I do have a suggestion.. Could you please add English subtitles in this lecture? It will be very helpful.
👋 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
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 ???
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!
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
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 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
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!
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.
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
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.
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....
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 ?
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!
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! :)
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.
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.
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 😂😂😂😂
10 hrs without breaks and smooth explanation really very thankful to u sir.
You're Welcome @arnakonda serina Keep learning with us.
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.
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
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
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.
The Data Validation lecture was amazing. I used it to audit Pettycash in the company I worked for. Very educative and helpful
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
Thank you so much sir.... Today I've completed Excel full course and it made me confident about my career boostup ❤️❤️💓😊❤️🔥
All the best
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..
One of the best videos, I have ever come across. Kudos to your efforts.
Wow, thanks!
@@Intellipaat yes sir, we need experts like you
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.
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.
I'm watching this video at length, along with the exercises, then I'll do some interview questions and some project. Thank you sir for explaining everything so well and providing education for free. I am a fresher from Andhra Pradesh and looking for jobs to support my family. Your content is helping me a lot.
@Ryōiki Tenkai you are welcome and we soo glad that we are helping you.
Kindergarden to graduation! Thank you bro!🤩😍
🥳
@@Intellipaat please provide the dataset
It's 11.30 pm. Will start learning tomorrow morning.
Subscribed.
Thank you!
I don't know even basic ...but I really want to learn Microsoft Excel..so as a beginner can I learn completely and clearly from this video
This is just an overview of the subject. If you wish to learn from top experts and get a certification, then kindly call our course advisors on IND: +91-7z022374614 US: 1-800-216-8930 (Toll-Free).
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.
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.
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.
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.
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.
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
You are a lifesaver bro I sincerely like to thank you personally tq bro so much🙏🙏🙏🙏
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.
I appreciate your teaching so much.I'm all ways grateful to u 😊😊
Glad to hear that
Thank you for making a full coverage of this topic. This is really helpful for people like me who struggle in excel.
Welcome😊
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.😊
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.
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👍
Thank you Sir for bringing this Useful MSExcel Course for free, it's really helpfull 🙏🏽
@BASED CHHAVA Glad you liked it 😊 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.
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.
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.
The lecture was very helpful. I learnt a lot about excel. Thank you!!!
Join me for ... Computer course in Urdu ???
Superb course 💯😻👌👌Thank you for sharing knowledge. Really enjoyed 🎉
Glad you liked it! Keep Learning with Intellipaat😊
This course was very effective only those things were included which were important 👍
@GOPAL DUBEY (RA1911044010028) Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
probably the best excel tutorial on TH-cam
Glad you liked it. Keep learning with Intellipaat. :)
Dear Sir,
In relative reference chapter you have shown a wrong formula for profit. Hence the amount which is showing is negative. The right formula for Profit is (Total - tax - investment = Profit) e.g movie 1 - total sale ticket = 10500
therefore your profit is 10500-2000-8000=500
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 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 😂
As a Small channel that post about word and excel I am learning a lot from this video. Thank you
Thank you so much for your kind words! We're glad you found the video helpful. 😊 Do like and share the video & subscribe to our channel to be at the top of your career.
@@Intellipaat Definitely
Thank-you so much it will help me a lot....such a detail cls
Glad it was helpful. Keep learning with Intellipaat. :)
Simple, deep and informative. Watching for 2 days. Congratulations. If possible make a course on ms access 2013. Thank you.
You're a true educator man....🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thank you @Tushar raja 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
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.
I'm learning so much every single day. Thank you so much. Invaluable.
You are so welcome! @Dorjee Arieh 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.
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
Today i started this Excel course let's hope it will be a great journey
Best of Luck!
Wow so beautiful class 🥰👍🏻💥💥
@Jaya Prabha Thanks for watching😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
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
Great platform to learn new courses...And without ads, it's too good...Thanks to IntelliPaat...
This kind of learning lecture should be uploaded more and more
Thank you. Keep learning with Intellipaat😊
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
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.
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
Sir it would have been great if you have provided the excel problems so that we could simulate that too...because listening to your lecture and building a new poblem worksheet is taking too much of time...also matching with your data would have been great to check the result when doing by own before your explanation
Ya sure!! @Sandipan Paul Do like, share & subscribe to our channel to get updates on upcoming videos.
Wow, this is so detailed, I can't remember the last time I was this engaged. This is beautiful, thank you so much
You are so welcome @Choco_fleets Do like, share & subscribe to our channel to get updates on upcoming videos.
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
Sir please make a full Java course very important for campus placements really need your help...
Hi Akhil, sure the team is already working on Java course. Meanwhile you can watch our MS SQL full course, which is also quite important for college projects and subjects: th-cam.com/video/JTDK6r1GuUU/w-d-xo.html
Join me for ... Computer course in Urdu ???
Sir unbelievable hats of sir maina pura excel 3 days ma sikh liya hats off sir thanks
@Asmit song Glad that it helped you a lot and you are most welcome, Do like, share & subscribe to our channel to get updates on upcoming videos.
Sir I promise to watch all your video and I have share this this video with my 54 friend sir sorry for late subscribe thanks sir
Please provide course on M.S. word & power point this are very important for college students
Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.
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. :)
I learnt lot of computer knowledge from you thanks
Welcome, Keep learning with Intellipaat😊
Thank you so much for this tutorial... very easy to understand and I believe it covers all the aspects of excel...
Glad it was helpful Bushra. :)
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.!
This video really helped me to learn excel as I didn't have much idea about the functions of excel.. Thank you so much for your efforts✨
Glad it was helpful! Do like, share & subscribe to our channel to get updates on upcoming videos.
Excellent course...Thank You so much for creating such a interactive content...It helped a lot
Most welcome! 😃
Sir please upload all the sheets that you have used in a drive and upload the drive link in the description that will be really helpful for us and for you too because most of the time people skip the video as they don't see the material which hinders the reach of the video. Kindly look into it.
@Pankaj Ingale Sure! We'll do it soon. Meanwhile, Do like, share & subscribe to our channel to get updates on upcoming videos.
@@Intellipaat yes sir and also sql sheet 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
आपने बहुत मेहनत की है इसे बनाने मैं और वास्तव में बहुओं अच्छी वीडियो है एक्सेल की।👍👍
Thank you for the feedback. This motivates us to bring more quality content to you guys! :)
Sir it's helpful for ca Articleship's
Indeed it is. :) Watch the video till the end.
Thanks brother
Thanks for such a great work
Welcome Sahil. Keep learning with Intellipaat😊
You guys doing such a great work god bless you all thank you so much
Our pleasure! @AkAsh Deep. 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.
Hi intellipaat team, I really love your videos, for me please make a video on Complete JobPortal development using PHP and MYSQL.
Hi Raghu, glad you liked our videos. Will forward the topic to the respective team and will upload that video soon. Meanwhile please subscribe to Intellipaat channel and press the bell icon so that you don't miss that video from us.
@@Intellipaat okay
Join me for ... Computer course in Urdu ???
Sir You are doing very amazing work for giving education I have started the video in morning and after some time I took break like this way I completed video in evening sir thanks to teach excel to me and my brother 🙂🙂🙂🙂🙂🙂🙂🙂🙂👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻🥺👏🏻👏🏻👏🏻👏🏻😃😃bye sir
Your welcome🙂 @Asmit signing video Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you so much for this profound knowledge. You guys are doing a great job.. Keep it up
But I do have a suggestion.. Could you please add English subtitles in this lecture?
It will be very helpful.
Hi, thanks for the kind words. We will definitely add subtitle soon. :)
@@Intellipaat soon?
Join me for ... Computer course in Urdu ???
hello Shashak bhai is this course helping you in making money???????