Thank you very very much, Chandeep bhayya!!🤗 Time Stamps: 01:21 Autofilter 03:21 Fast Sorting 05:01 Creating Charts 05:30 Update an existing chart with new data 06:54 Copy-Paste Formatting of one chart to another 08:15 Getting back to the formula (not to the formula bar, but within the sheet) 09:51 Converting numbers to dates 11:36 Sum data (of same locations) from multiple sheets 13:37 Multiple Vlookup values (i.e. when a primary key has multiple values) (MOST USEFUL) 17:42 VERY HIDE SHEETS option 19:45 Create and Add customs lists (eg. FY months) and use for custom sorting
The Power BI course is definitely a lot more than just a bundle of TH-cam videos. Here’s why - 1. The course is structured, layered with practice exercises to help you graduate step by step whereas a TH-cam video is mostly done for views and building an audience. 2. You can ask questions in the comments and also learn from fellow students.
@15:01 when i am using the =IF(E3=$B$3:$B$14,$C$3:$C$14,"") formula , i am only getting single value 5 in cell f3 instead of multiple values . any reason for this..? i am using ms office 2016 professional
Sir, I really enjoy watching your videos. However, when I visit your website, I notice that all the courses are in English. I kindly request you to consider providing courses in Hindi as well. Thank you
Brother, sorry to say, but I could only watch for 12 minutes, and from what I understood, you’re teaching shortcut keywords that help in finishing tasks quickly. So, what’s the need to purchase a course for this? If you feel that your teaching style has that unique impact or effects which others don’t have or you don’t want to showcase it openly, then upload it on TH-cam itself. Those who are genuinely interested will follow up and watch your videos. It’s even possible that one student might watch your video multiple times until they fully understand it, and that will benefit you as well 😅. Now, please don’t say, ‘I can’t give it for free’ 😅. TH-cam pays, but the condition is that your content should be strong enough 😅. That’s it. Anyway, there’s a lot more that can be said, but this isn’t the right time.
Aur aisa bhi nahi hai ki starting me chahe jitna achcha skill show off kar do company ke HR ko but company starting me degi salary 13 to 15k hi 😂 aur jyda over smartness dikhaya to phir most of people's ko aapki tarah cap 🧢 pehna padega kam age me. Don't feel heart related otherwise u irritate for me 😅 and I request 4uu plz just u read casual & positive mindset so u understand my point.
Brother sry to say but maine sirf 12 minutes hi tak dekha aur mujhe itna samjh me aaya hai ki aap isme short cut keywords padha reh hai jisko Sikh ke kaam ko jaldi kaise khatam kya jaa sake to isme course purchase karne ki kya jarurat hai aapke baki ?? Agar aapko lagta hai ki aapke teaching style me wo impact or effects hai jo kisi me nahi hai yaa wo dikhana nahi chahte hai to aap youtube me hi upload karo jisko interest hoga wo aapko follow up kar ke video watch karenga aur ho sakta ho ek student aapki ek video ko multiple time dekhe jab tak usko samjh me naa aaye isse aapko bhi benefits hoga 😅. Ab ye mat kehna mai free me nahi de sakta hu 😅 TH-cam paisa deta hai but uske condition hai ki aapke contect me dum hona chahiye 😅 bas. Waise isme aur bhi bahut kuch kha jaa sakta hai but this is not right time. Bro
@@ThanosBhai-o5kare baba dusari I'd bana ke aisa q bolna 😅😅 chalo man liya ki aapne isko negative mindset se padha h sry baba aur agar ap owner nhi ho to ye msg public ke liye nhi h so u ignore it baba 🤫🤣🤣🤣
Thanks for sharing video
Thank you very very much, Chandeep bhayya!!🤗
Time Stamps:
01:21 Autofilter
03:21 Fast Sorting
05:01 Creating Charts
05:30 Update an existing chart with new data
06:54 Copy-Paste Formatting of one chart to another
08:15 Getting back to the formula (not to the formula bar, but within the sheet)
09:51 Converting numbers to dates
11:36 Sum data (of same locations) from multiple sheets
13:37 Multiple Vlookup values (i.e. when a primary key has multiple values) (MOST USEFUL)
17:42 VERY HIDE SHEETS option
19:45 Create and Add customs lists (eg. FY months) and use for custom sorting
❤🎉
thanks bro....
Jabardast info. Thanks a ton.
ZABARDAST SIR
Awesome Bro...
Excellent
Really Good Tricks 👋👋
Great 👍
Awesome, start advanced Excel series
for me personally, the best tricks were copy pasting new data to update the chart and using format feature in graphs like format painter.
Very useful for me .. pls share more videos
Feel pleasant after viewed ❤
A good revision for me I learnt all these shortcuts when I initially started learning Excel in back in 2019.
Please continue more excel video in hindi.......Waise aapka बहुत धन्यवाद🙌
Outstanding hacks❤❤❤
Awesome tricks..Mind blowing
Excellent video, Thank you Chandeep😊
Thank you for the informative video.
loved your content
Excellent. Thanks for sharing 🎉
Really awesome.
You are my favourite buddy. Before I used to follow CHANDOO.
Great!
Thank you so much for aur phele baar aapne hindi me kiya hai. Grt, i am inspired by your way of teaching.
Respect Button 🔘 From My Side
Awesome 👍🏻
Zabardast 😊
Thanks a lot👍
FANTASTIC
Valueable video 🤝👍
very useful tricks
Subscribed and liked it too ❤
Haha! Chandeep I have learned from your video a lot. Apko urdu main bolty dekh kr acha laga
Superb ⭐⭐⭐⭐⭐ 👍
Soooperb..
You have an amazing way to teach difficult topics. Just one question regarding your course on Power BI :
Is it a bundle of yours TH-cam videos
The Power BI course is definitely a lot more than just a bundle of TH-cam videos. Here’s why -
1. The course is structured, layered with practice exercises to help you graduate step by step whereas a TH-cam video is mostly done for views and building an audience.
2. You can ask questions in the comments and also learn from fellow students.
Awesome, thanks for your reply. I'll be your official student very soon. Any year end discount 😂
Congrats Another subscriber
welcome
❤❤❤❤
Auto Filter is awesome
11th are awesome trick
Sir .I have subscribed you . Your teaching style is excellent. I want learn how make a excrl sheet for data entry. Regards.
v.nice
Nice
Nice
Bro kindly
Stationery Shop k liy POS with Sales Purchase Inventory etc banaiy please
Stationery Shop
Daily Sales
Inventory
Purchase
Profit and Loss
Bro please make more videos on this channel. I also follow your English channel but l like more hindi Content
@15:01 when i am using the =IF(E3=$B$3:$B$14,$C$3:$C$14,"") formula , i am only getting single value 5 in cell f3 instead of multiple values . any reason for this..?
i am using ms office 2016 professional
Thank you for sharing these tricks in a consolidation. I am using almost all these tricks / shortcut keys on daily basis.
Sir, I really enjoy watching your videos. However, when I visit your website, I notice that all the courses are in English. I kindly request you to consider providing courses in Hindi as well. Thank you
I'm working on making some of the courses available in Hindi. Stay tuned.
Need Hindi content
The shortcut is not working in Office 365, please advise how the shortcut can be activated in this version as well.
Sir row ko bhi very hide Kar saktay h
Aur jo apka auto filter sare name ek kar deta h sath me rgt lft columns details ko change kar deta h , uska kya ?? Bro
which software are you using for marking in red while recording screen?
camtasia
14:22
Good morning sir all sheets selected data only want to print in a single paper,excel
❤
Hiii I am new subscriber
Welcome aboard!
The mutiple vlookup or duplicate lookup is not happening its only a single value?
Bhai how come in hindi but it is wonderfull, very much like it
alt + f1 for charts is not woring on w-11
Row A is hidden in Excel Sheet, how to unhide.
Which Version Us
Excel 365
Or
Excel 2019 and 2023
Ok filter 3 person ka karna ho to
zabardast Omani Guy from Oman saying well done Chandeep
I need a power BI course in hindi
It is in English but very very good - goodly.co.in/power-bi-beginner/
KONSE VERSION MAY YE FORMULA HAI =TEXTJOIN/SPLIT/UNIQUE
Excel 365 and Excel 2021
Brother, sorry to say, but I could only watch for 12 minutes, and from what I understood, you’re teaching shortcut keywords that help in finishing tasks quickly. So, what’s the need to purchase a course for this? If you feel that your teaching style has that unique impact or effects which others don’t have or you don’t want to showcase it openly, then upload it on TH-cam itself. Those who are genuinely interested will follow up and watch your videos. It’s even possible that one student might watch your video multiple times until they fully understand it, and that will benefit you as well 😅. Now, please don’t say, ‘I can’t give it for free’ 😅. TH-cam pays, but the condition is that your content should be strong enough 😅. That’s it. Anyway, there’s a lot more that can be said, but this isn’t the right time.
**Career Development Tips**
for me it is only get on and off no filtration happing what could be the problem
Make sure that you are working with a data and not a table.
I am like😮
Sir ye normal excel me nahi hota hai ap khud microsoft 365 me kar raha Usha me hi jyege par normal excel me nahi hoga
Kya normal excel bhai 😂😂 toh wo kya special excel use kr raha hai kya?
Auto filter not working
Ye apka English wala video me apne Hindi dubbed bad me kiya hai. Maine ye video pahle dekha hai
WHILE APPLYING IF FORMULA, I GET ONLY ONE ANSWER.
Please edit video slow man
Aur aisa bhi nahi hai ki starting me chahe jitna achcha skill show off kar do company ke HR ko but company starting me degi salary 13 to 15k hi 😂 aur jyda over smartness dikhaya to phir most of people's ko aapki tarah cap 🧢 pehna padega kam age me. Don't feel heart related otherwise u irritate for me 😅 and I request 4uu plz just u read casual & positive mindset so u understand my point.
Brother sry to say but maine sirf 12 minutes hi tak dekha aur mujhe itna samjh me aaya hai ki aap isme short cut keywords padha reh hai jisko Sikh ke kaam ko jaldi kaise khatam kya jaa sake to isme course purchase karne ki kya jarurat hai aapke baki ?? Agar aapko lagta hai ki aapke teaching style me wo impact or effects hai jo kisi me nahi hai yaa wo dikhana nahi chahte hai to aap youtube me hi upload karo jisko interest hoga wo aapko follow up kar ke video watch karenga aur ho sakta ho ek student aapki ek video ko multiple time dekhe jab tak usko samjh me naa aaye isse aapko bhi benefits hoga 😅. Ab ye mat kehna mai free me nahi de sakta hu 😅 TH-cam paisa deta hai but uske condition hai ki aapke contect me dum hona chahiye 😅 bas. Waise isme aur bhi bahut kuch kha jaa sakta hai but this is not right time. Bro
Bhai tuje kuch kaam vaam he ki ni😂itna bada msg kon likhta he o bhi itna useless msg..
@@ThanosBhai-o5kare baba dusari I'd bana ke aisa q bolna 😅😅 chalo man liya ki aapne isko negative mindset se padha h sry baba aur agar ap owner nhi ho to ye msg public ke liye nhi h so u ignore it baba 🤫🤣🤣🤣
@@John-p9g9z me nahi padne vala Bhai Tera msg😂
@John-p9g9z auntie jaav aap apna kaam karo kya baba baba kare ki
@@John-p9g9z auntie aap apna kam karo kya baba baba kare ki
Auto filter does not work in 2021. It toggles filter button in the headings.
Maybe you are applying it on a Table. Try applying it on normal data.
Sir, kindly share your contact details, I would like to join your class.
please drop an email - pratik@goodly.co.in
Firstly complete bi dax in hindi
Awesome ❤