👋 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
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.
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
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 😄😄
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..
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.
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👍
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.
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.
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.
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.
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).
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!
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 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. 👏👏👏
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😊
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
Heyyy...I would just like to say don't remove this video from here!❤️🙏. The efforts you have put in this video is commendable . Learning MS Excel from this video . Its life saviour video fr me now !! 🌼🙏💙
@@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.
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
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.
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 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.
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 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
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.
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
@@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
👋 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
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 श्रौं दक्ष
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
Guys, what else do you want to learn from Intellipaat? Comment down below and let us know so we can create more such tutorials for you.
Intellipaat ALL Linux Commands
ML using Python
More on Data science and data analytics.
Intellipaat please post videos regarding Openshift
Tally
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
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.
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
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
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 ???
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
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 ?
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....
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
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
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.
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! :)
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
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.
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..
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.
Thank you so much sir.... Today I've completed Excel full course and it made me confident about my career boostup ❤️❤️💓😊❤️🔥
All the best
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!
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'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.
It's 11.30 pm. Will start learning tomorrow morning.
Subscribed.
Thank you!
The Data Validation lecture was amazing. I used it to audit Pettycash in the company I worked for. Very educative and helpful
10 hrs without breaks and smooth explanation really very thankful to u sir.
You're Welcome @arnakonda serina Keep learning with 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.
@Shinido Welcome .Do like, share & subscribe to our channel to get updates on upcoming videos.
Kindergarden to graduation! Thank you bro!🤩😍
🥳
@@Intellipaat please provide the dataset
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 😂😂😂😂
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).
One of the best videos, I have ever come across. Kudos to your efforts.
Wow, thanks!
@@Intellipaat yes sir, we need experts like you
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.
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.
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.
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.
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.
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
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.
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.
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 😂
I appreciate your teaching so much.I'm all ways grateful to u 😊😊
Glad to hear that
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.
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 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
Today i started this Excel course let's hope it will be a great journey
Best of Luck!
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👍
You are a lifesaver bro I sincerely like to thank you personally tq bro so much🙏🙏🙏🙏
आपने बहुत मेहनत की है इसे बनाने मैं और वास्तव में बहुओं अच्छी वीडियो है एक्सेल की।👍👍
Thank you for the feedback. This motivates us to bring more quality content to you guys! :)
Superb course 💯😻👌👌Thank you for sharing knowledge. Really enjoyed 🎉
Glad you liked it! Keep Learning with Intellipaat😊
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.
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 for making a full coverage of this topic. This is really helpful for people like me who struggle in excel.
Welcome😊
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
Heyyy...I would just like to say don't remove this video from here!❤️🙏.
The efforts you have put in this video is commendable . Learning MS Excel from this video . Its life saviour video fr me now !! 🌼🙏💙
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.
probably the best excel tutorial on TH-cam
Glad you liked it. 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 ???
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.
You're a true educator man....🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thank you @Tushar raja 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 ???
This kind of learning lecture should be uploaded more and more
Thank you. Keep learning with Intellipaat😊
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.😊
Wow...10 hours... Lots of efforts
Thank you. Do SUBSCRIBE to our channel to get more such interesting live sessions.
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. :)
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.
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.
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
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.
Wow so beautiful class 🥰👍🏻💥💥
@Jaya Prabha Thanks for watching😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
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.
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.
Thank-you so much it will help me a lot....such a detail cls
Glad it was helpful. Keep learning with Intellipaat. :)
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.
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
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
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 platform to learn new courses...And without ads, it's too good...Thanks to IntelliPaat...
Simple, deep and informative. Watching for 2 days. Congratulations. If possible make a course on ms access 2013. Thank you.
Excellent course...Thank You so much for creating such a interactive content...It helped a lot
Most welcome! 😃
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
Excellent work , Very good to share the knowledge to everyone for free.
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 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
I have just started the training program. It seems to be a good one to follow. Let's see!
@Chamantha Wickramarathne 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
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 ???
Must watch for anyone who aspire to master the basic excel skills. Explained very well with supporting examples.
Glad it was helpful! 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
Thanks for such a great work
Welcome Sahil. Keep learning with Intellipaat😊
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.
Sir it's helpful for ca Articleship's
Indeed it is. :) Watch the video till the end.
Thanks brother
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
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.😊
Thanks A Ton Man !! Keep Doing Great work !!!
Welcome. :) Keep learning with Intellipaat. :)