00:04 - Subscribe for important Excel updates 02:05 - Introduction to Excel for Professional Scope 05:24 - Status bar provides information about selected cells and their time 06:30 - Understanding Excel shortcuts and controls 09:08 - This part discusses the process of selecting and controlling in Excel. 10:28 - Performing actions with control and swift selections 13:22 - Importance of subscribing to the channel 14:58 - Shift + Space selects the entire line in Excel 17:22 - Filtering by color in Excel for selecting specific data 18:28 - Increase limit, left side, select 'like', find negative 21:23 - Filtering data using Excel shortcuts 22:17 - Practical tips for using filters in Excel. 25:14 - Using Excel for practical insights in CA articleship 26:07 - Understanding the usage of filters in Excel 27:54 - Understanding cut, copy, and paste functions in Excel 28:41 - Using control plus C and control plus V for copy-paste 30:29 - Importance of Copy Paste in Excel 31:16 - Copying content and using special features in Excel 33:41 - Demonstration of Excel table formatting techniques 35:02 - Importance of Flexible Bill and Discounts in Excel 37:24 - Using the multiply operation and controlling cells in Excel 38:36 - Learn about excel shortcuts 40:27 - Understanding Excel borders and formatting 41:43 - Excel फोंट साइज और कलर चेंज करना 44:24 - Using Excel for practical insights in CA Articleship 45:37 - Optimizing cell size in Excel 48:22 - Practical demonstration of Excel shortcuts 49:24 - Understanding contract content and comment 51:43 - Discussion on Excel formatting issues 53:05 - Changing date format and cell selection 56:10 - Conditional formatting is important for practical use 57:52 - Understanding and ensuring accurate record keeping for companies 1:01:09 - Understanding top 10 items and conditional formatting in Excel 1:02:10 - Subscribe button control and finance 1:05:31 - Learning about portable field and serial control 1:06:59 - Understanding total value calculation in Excel 1:09:40 - Excel shortcuts for efficient data entry 1:11:20 - Learn how to update keyboard settings and use replace option in Excel. 1:13:19 - Excel Formatting Shortcuts 1:14:17 - Understanding the importance of data filtering in Excel 1:16:50 - Exploring Excel functions for data editing 1:18:12 - Removing duplicates is crucial for data accuracy. 1:20:48 - Automated generation of invoices and debit notes 1:22:24 - Excel password subscription and selection 1:26:00 - Entering and registering invoice number and date 1:27:11 - Understanding the logic of applying lock or not is essential 1:29:59 - Practical insights on Excel shortcuts 1:31:13 - Entering invoice number in register 1:33:47 - Learn to add GST numbers 1:35:18 - This is an incorrect subtitle 1:38:24 - Avoid considering the third number problem as one opinion only 1:40:18 - Opening a Review Committee Account for Play Store 1:43:12 - Tips for efficient Excel usage 1:44:51 - Control functions for Excel 1:48:00 - Copying content between different sheets and files in MS Excel 1:49:11 - Shortcut tips for Excel usage 1:51:20 - Paste data in filtered cells. 1:52:24 - Ling linking is important while working in Excel 1:54:27 - Practical Insights on MS Excel for CA Articleship 1:55:18 - Learn about inter-linking and control 1:57:54 - Learn to adjust cell size for better visibility 1:59:13 - Excel shortcuts and functions 2:01:33 - फिल्टर के उपयोग की प्रैक्टिकल जानकारी 2:02:24 - Importance of conditional formatting in Excel 2:03:58 - Explaining dropdown list and data validation. 2:04:44 - Mastering Excel border options for efficient formatting 2:07:15 - Tips for setting and using Excel functions effectively
Very beautifully explained everything sir ..Itne ache se to mujhe IT class m nhi sikhaya unhone 5000 lekar ...Apki jitni tarif kre utna km h ,you r Just awesome...Loved to be a part of tej articleship group.
Sir thankyou for dedicating precious 2 hours 08 mins of mins. Pehli baat kam toh nahi tha. Puraani cheezein like Vlookup,Wrap Text ,Subtotal,Pivot Table,Count if ,Conditional Formatting ka ek bauhat accha revision ho gya Nayi cheezein like Concatenate,Operation Repeat,Transpose,Combustion Activity,Paste Special ko bauhat acche se samjhaaya. Practice part par aur mehnat karni hai and regarding functions phir value 0 kyun ho jaata hai was also good. So overall kuch kam nahi hai. 128 mins jo seekhaya behtareen sikhaya. Thankyou Sir
I really liked the shortcuts you shared in this video. It made working on practical sheets so fast and easy. Some of my favourite were removing particular filter criteria, comma, open linking to a cell, paste special, pivot table, removing duplicates and also gridlines. Those tips and shortcuts inculcated over the period of time will be very helpful for me while I work at the firm. Thank you for enhancing my Excel skills through this video.
Best lecture for Excel Beginners. Best part in this video for me is "VLOOKUP Function". Maine youtube par bohot Videos dekhe par sab ne bas ye bata dia ki kaise use karte hai but reason nahi bataya tha. But Sir ne Reason + How to use dono bataae, thats the best thing 🧡
Thank you for this video sir •You have very well explained the filter concepts • I was unaware about alt; • How to check linking and go back is also great You have very well explained all the concepts Thank you sir 🤗🤗😄
All concepts are explained well and more focus on shortcut keys. I knew shortcut keys but preferred working with mouse as i thought it is more easy rather than remembering all those shortcut keys. But you proved me wrong will now focus on shortcut keys more as it will improve my efficiency and effectiveness of dealing with cumbersome data.
I know all the concepts you delivered but I don't know the shortcuts and how to use it with keyboard only which will increase efficiency. Thank you sir for providing such a great lecture.
Sir kya english jaruri hai big 4interview ke liye kyonki Mera subjects average hai , but english Nahi Bol pata gaav me Hindi medium se hi tha , aur CA inter english medium se hi clear kiya
Thank you so much sir for the video Got to learn many new things like Transpose, Wrap Text, Combination of Filter and Conditional Formatting, Dropdown List, Imp. Of Linking and many shortcut keys
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
00:04 - Subscribe for important Excel updates
02:05 - Introduction to Excel for Professional Scope
05:24 - Status bar provides information about selected cells and their time
06:30 - Understanding Excel shortcuts and controls
09:08 - This part discusses the process of selecting and controlling in Excel.
10:28 - Performing actions with control and swift selections
13:22 - Importance of subscribing to the channel
14:58 - Shift + Space selects the entire line in Excel
17:22 - Filtering by color in Excel for selecting specific data
18:28 - Increase limit, left side, select 'like', find negative
21:23 - Filtering data using Excel shortcuts
22:17 - Practical tips for using filters in Excel.
25:14 - Using Excel for practical insights in CA articleship
26:07 - Understanding the usage of filters in Excel
27:54 - Understanding cut, copy, and paste functions in Excel
28:41 - Using control plus C and control plus V for copy-paste
30:29 - Importance of Copy Paste in Excel
31:16 - Copying content and using special features in Excel
33:41 - Demonstration of Excel table formatting techniques
35:02 - Importance of Flexible Bill and Discounts in Excel
37:24 - Using the multiply operation and controlling cells in Excel
38:36 - Learn about excel shortcuts
40:27 - Understanding Excel borders and formatting
41:43 - Excel फोंट साइज और कलर चेंज करना
44:24 - Using Excel for practical insights in CA Articleship
45:37 - Optimizing cell size in Excel
48:22 - Practical demonstration of Excel shortcuts
49:24 - Understanding contract content and comment
51:43 - Discussion on Excel formatting issues
53:05 - Changing date format and cell selection
56:10 - Conditional formatting is important for practical use
57:52 - Understanding and ensuring accurate record keeping for companies
1:01:09 - Understanding top 10 items and conditional formatting in Excel
1:02:10 - Subscribe button control and finance
1:05:31 - Learning about portable field and serial control
1:06:59 - Understanding total value calculation in Excel
1:09:40 - Excel shortcuts for efficient data entry
1:11:20 - Learn how to update keyboard settings and use replace option in Excel.
1:13:19 - Excel Formatting Shortcuts
1:14:17 - Understanding the importance of data filtering in Excel
1:16:50 - Exploring Excel functions for data editing
1:18:12 - Removing duplicates is crucial for data accuracy.
1:20:48 - Automated generation of invoices and debit notes
1:22:24 - Excel password subscription and selection
1:26:00 - Entering and registering invoice number and date
1:27:11 - Understanding the logic of applying lock or not is essential
1:29:59 - Practical insights on Excel shortcuts
1:31:13 - Entering invoice number in register
1:33:47 - Learn to add GST numbers
1:35:18 - This is an incorrect subtitle
1:38:24 - Avoid considering the third number problem as one opinion only
1:40:18 - Opening a Review Committee Account for Play Store
1:43:12 - Tips for efficient Excel usage
1:44:51 - Control functions for Excel
1:48:00 - Copying content between different sheets and files in MS Excel
1:49:11 - Shortcut tips for Excel usage
1:51:20 - Paste data in filtered cells.
1:52:24 - Ling linking is important while working in Excel
1:54:27 - Practical Insights on MS Excel for CA Articleship
1:55:18 - Learn about inter-linking and control
1:57:54 - Learn to adjust cell size for better visibility
1:59:13 - Excel shortcuts and functions
2:01:33 - फिल्टर के उपयोग की प्रैक्टिकल जानकारी
2:02:24 - Importance of conditional formatting in Excel
2:03:58 - Explaining dropdown list and data validation.
2:04:44 - Mastering Excel border options for efficient formatting
2:07:15 - Tips for setting and using Excel functions effectively
Must watch (best video explain every required or important concept in best possible way)
For whole video summary ( 1:58:00 to 2:08:21 )
Very beautifully explained everything sir ..Itne ache se to mujhe IT class m nhi sikhaya unhone 5000 lekar ...Apki jitni tarif kre utna km h ,you r Just awesome...Loved to be a part of tej articleship group.
Hamse to 7000 liye
@@riyameena8540 that was for online class due to COVID ...now offline class is for 7k
It and oc are mainly to have fun😂
7000 liye the mere se toh
50 hrs ka course hota
Kuch toh btaya hoga na@@bubbly09876
Sir thankyou for dedicating precious 2 hours 08 mins of mins.
Pehli baat kam toh nahi tha.
Puraani cheezein like Vlookup,Wrap Text ,Subtotal,Pivot Table,Count if ,Conditional Formatting ka ek bauhat accha revision ho gya
Nayi cheezein like Concatenate,Operation Repeat,Transpose,Combustion Activity,Paste Special ko bauhat acche se samjhaaya.
Practice part par aur mehnat karni hai and regarding functions phir value 0 kyun ho jaata hai was also good.
So overall kuch kam nahi hai.
128 mins jo seekhaya behtareen sikhaya.
Thankyou Sir
I really liked the shortcuts you shared in this video. It made working on practical sheets so fast and easy. Some of my favourite were removing particular filter criteria, comma, open linking to a cell, paste special, pivot table, removing duplicates and also gridlines. Those tips and shortcuts inculcated over the period of time will be very helpful for me while I work at the firm.
Thank you for enhancing my Excel skills through this video.
Best lecture for Excel Beginners.
Best part in this video for me is "VLOOKUP Function". Maine youtube par bohot Videos dekhe par sab ne bas ye bata dia ki kaise use karte hai but reason nahi bataya tha. But Sir ne Reason + How to use dono bataae, thats the best thing 🧡
I am not bored even for a second while seeing this 2 hours vedio because all thing you tought us having worth.
Thank you so much
Comprehensive and productive excel tutorial. Thank you for this valuable resource.
Thank you for this video sir
•You have very well explained the filter concepts
• I was unaware about alt;
• How to check linking and go back is also great
You have very well explained all the concepts
Thank you sir 🤗🤗😄
Thank you so much sir for taking such a valuable session and teaching every function in a detailed manner.
A must watch video for every CA student💫💫
I'm watching your video last 2 days your videos are very helpfull
No personal advertisement
And most important content is very helpful.
Thank you sir
Very informative video sir💯💯all important concepts summarised with ease! Keep uploading such videos 🙌
THANKYOU SO MUCH SIR
REALLY VERT HELPFUL VIDEO , WANT MORE VIDEOS LIKE THIS
THANK YOU SO MUCH SIR, U Have given us lot of important free contents..
u helped me a lot for my interview.
Yrr... seriously ... I get assured after watching this that my excel is strong now... loved it ❤
A must watch video.🔥
Everything explained very well. Can relate everything.😅
Thanku so much sir for this video 😊
thank you so much sir, u have given us so much free contents.u helped a lot for my interview.
This video is very helpful sir & thank you so much for the video😊
The best part was alt shortcuts which will help us to operate quickly & easily.
Sir thanku so much for sharing this video I learnt all excel which needed in my office learnt from this video
Thank you Sir❤❤❤ wonderful session
Thank you Sir It is a great video and learn lot of things
I personally recommend must watch it.
one of the most useful video for ca students
All the shortcuts and conditional formatting, filter were really helpful
How to use filters or formatting options 13:54
1:25:10 Vlookup
Thnks sir
What a wonderful session it was
In only 2hours So Many Tricks you have teached us
Extensive piece of knowledge ❤️ Thank you sir for sharing 🎉✨
Subtotal I was not aware of but learnt through this video
This video is really very helpful.
Thank you sir for putting so much efforts for us.
Thank you sir. You explained all the important concepts quickly and very well.
Very useful in my initial days of articleship ❤
Very helpful video sir...thnk u so muchh❤
GREAT VIDEO..AWESOME..THANKYOU FROM A CA..
GOT REVISED QUICKLY
Sir,thank you so much for this video.
Very helpful for beginners
Currently I am using these on daily basis.
1:05:25 Pivot Table
All concepts are explained well and more focus on shortcut keys. I knew shortcut keys but preferred working with mouse as i thought it is more easy rather than remembering all those shortcut keys. But you proved me wrong will now focus on shortcut keys more as it will improve my efficiency and effectiveness of dealing with cumbersome data.
Thank you sir
Everything is explained very well. All basics clear now.
thankyou so much sir for giving us such valuable content.
Thanku so much sir for sharing this vedio it is very helpful for me becoz I don't have basic knowledge of excel and l learned a lots from it
Great content, worth than any other video
Thank you sir... This is much needed
where is closed inverted coma in the keyboard of laptop?
Thank you so much sir it is really informative and an important one
This video was really helpful for me. Thank You sir.
Thank you explaning MS Excel relevant for CA student
Great for CA students ❤
Sir,You have explained every concept very well and thank you for this video💖🌠
Great session, sir. Baut concepts revise ho gye, sir.
I am getting wrong answer in SUMIF..for example i have 3 KA but only 2 KA is counted
Committed towards students for best guidance to get article ship in best firm.😊😊
Amazing video and wonderful explanation, Love from Pakistan
I know all the concepts you delivered but I don't know the shortcuts and how to use it with keyboard only which will increase efficiency. Thank you sir for providing such a great lecture.
DATA VALIDATION 1:21:00
Thankyou for sharing Sir, really helpful video. Learned a lot 😃
Thank you very much sir for this amazing video ♥♥♥♥
thank you sir for such an amazing video ❤
please understand the difference between a row and a column
Great video Sir, Very helpful and informative for me 👍
Thank uhh so much sir❤
This will be very helpful during Articleship
Shift+down right select all column row
Thank You sir. This is very helpful. 🙏
Very helpful video sir. Thanks a lot
thank you so much for this video it help me alot sir
🙏🙏🙏❤️
Very Helpful for me thanku sir🥰
Sir the video is very insightful but the voice is low
Sir kya english jaruri hai big 4interview ke liye kyonki Mera subjects average hai , but english Nahi Bol pata gaav me Hindi medium se hi tha , aur CA inter english medium se hi clear kiya
Hi Nitin,
Message kre telegram pe. English acha kr lenge kuch time me.
>> Telegram me on 79911 22081
can i get the woorsheets for practice?
Thank you sir for this video.
sir please make a video on preparation for CA placements especially for audit profile.
Very helpful…thanks a lot sir!
Thank you so much sir 🙏🏻 ☺️
1:02:00 to be continue
thank you so much sir for your effort
God bless you 🙏
Thank You Sir
Video is very useful
Sum filter subtotal upto 27:54
Kindly provide Excel sheet
Thank u sir for the video!
Very well explained everything. Thank you sir . Got to revise all the important concepts quickly.
You're Welcome Pranali :)
From 27:54......home menu
Thank you so much sir for the video
Got to learn many new things like Transpose, Wrap Text, Combination of Filter and Conditional Formatting, Dropdown List, Imp. Of Linking and many shortcut keys
Must watch for CA students
Paste special 31:00
Filter from 15:00
13:43 - filter
Amazing explanation👌👌
29:00 paste special
sir f2 s cell edit nhi ho rha f2 upercase m h to shift k sth m use krri hu to bh nhi ho rha
Replied on Telegram 👍
Could you please share pdf file for practicing for us???
can anyone share notes prepared regarding this video..Thanks in Advance
Thank you sir, I learnt a lot from this excel learning video🙂
Well explained 👌
Sir gst reconciliation in excel 2a and 2b
Thankyou sir very helpful
1:41:29 sumif
1:04:52
I AM IN CLASS 12 BUT STILL WATCHING THIS FOR FUTURE NEEDS
Bhai sun ms office 2021 pe hora kya yeh
23:00
Thanks a lot .