I really love your way of teaching skills .....thankuou so much for your videos and thankyou so much for guiding us by excel tips ...i really appreciate your work
Awesome video! as always. (feedback: bringing in dates would have made the video much more challenging, like monthly data flowing into the dashboard with some slicers etc)
Hello Chandoo Sir I have been a big fan of your videos for sometime now. Could I please request a clarification or a question related to my work process which you could help explain in one of your sessions? My management sends me the Employee details every 20th of each month in a particular format. I am keeping the same in a folder for filing purposes. There could be new employee additions, removals etc. Usually I filter the data, do lookups between the sheets and understand the difference. Is there a way, to compare the sheets via Power Query and identify the difference between the sheets and highlight those changes (who got added/removed)? Awaiting your response, thanks much for all your contributions
I made a VIDEO on this exact topic a while ago as I was doing the EXACTLY SAME THING!!! See this please - ruclips.net/video/aFIb3oFsGO4/видео.html Also read - chandoo.org/wp/figuring-out-employee-churn-with-power-query-hr-analytics/
Helooo!! You create well informed videos with beautiful presentation. Thamks a lot. Can u plz help on how to include that section of top 5 revenues or top 5 costs??
Hello I'm interested to watch your videos every day.. it's more informative thing makes us thanks for this,, you are also doing more productive vedios than your past vedios we love the way how passionate about your doing this chandoo have a great time 🥂🥂.. keep going and achieve Big 💐💐
Thanks for your great videos. what if the budget we want to create has a different periodic method. for example one cost we enter is monthly bases the other on bi-weekly or weekly. how to enter data with different periodic and get the sum in monthly base. Thanks
How can I add paid invoice and update the budget. Scenario: receiving invoice for software/computer costs, HR services, Legal services, etc. Is invoice tracking separate from budget? I am studying for a job test
Sir m trying to multiply price and number but the answer is coming "value" because of the currency sign. I don't know how to fix it. If I manually remove dollar sign and then multiply price and number, the answer is correct. How to fix it.
i wanna calculate amt * hrs but calculations is not coming exact how to fix it please help??as if I multiply inr 108800*755:00 hrs result should be 82144000 but it's showing 3422667...plz help sr
Hi Chandoo, Your recent subscriber . Need your help. If you could reply on an urgent basis, I want to know that how to create hyperlinks for a range of validation list.
Welcome aboard Mukul. I don't reply on urgent (or really any) basis. I suggest posting questions in a forum or checking with a colleague / friend for help in situations like this. Reg. hyperlink, have a read on this page - chandoo.org/wp/excel-hyperlinks/
Thank you!
You're welcome!
Your video always helps Mann, got a job and cleared the interview with your videos ! I'm now working as a BA
Whoa!!! Congrats Vijay. That is awesome news. 😀
PS: If you want to share your story with our viewers, email me so we can talk.
Great Chandoo! Thanks for demonstrating this nice looking budget worksheet. Thumbs up!!
My pleasure!
You are my Guru Always
I am following all your videos.
Thanks for your support to share the knowledge. 👍👍👍👍
Informative upload as always. Thanks Chandoo.
My pleasure!
I really love your way of teaching skills .....thankuou so much for your videos and thankyou so much for guiding us by excel tips ...i really appreciate your work
You are so welcome Sakshi.
Looks like I am 1st one to watch the video. Yay...
Sir you always come up with really simple but effective methods to apply in real world scenrio..
My pleasure ... 😀
Thank you so much, Chandoo! :)
You're welcome 😊
Than you Sir for this nice video!
Amazing sir, keep teaching us
Awesome video! as always. (feedback: bringing in dates would have made the video much more challenging, like monthly data flowing into the dashboard with some slicers etc)
Thank you. Good suggestion reg. Dates. May be I will make a v2.0 of this in a few months.
@@chandoo_ and please set revenue over cost :D
That turns me crazy 😂
More than Great Chandoo ♥
As always sir at his best....
😀😀😀
Great explanation. Thank you! 🙂
Hello Chandoo Sir
I have been a big fan of your videos for sometime now. Could I please request a clarification or a question related to my work process which you could help explain in one of your sessions?
My management sends me the Employee details every 20th of each month in a particular format. I am keeping the same in a folder for filing purposes. There could be new employee additions, removals etc. Usually I filter the data, do lookups between the sheets and understand the difference. Is there a way, to compare the sheets via Power Query and identify the difference between the sheets and highlight those changes (who got added/removed)?
Awaiting your response, thanks much for all your contributions
I made a VIDEO on this exact topic a while ago as I was doing the EXACTLY SAME THING!!!
See this please - ruclips.net/video/aFIb3oFsGO4/видео.html
Also read - chandoo.org/wp/figuring-out-employee-churn-with-power-query-hr-analytics/
@@chandoo_ Thank you so much Sir. I will watch it and give it a try
Thank you so much!!
Elegant dashboard
Yes and very easy to make and maintain too..
Helooo!! You create well informed videos with beautiful presentation. Thamks a lot. Can u plz help on how to include that section of top 5 revenues or top 5 costs??
inspiring, thank you so much
Thank u sir. Keep doing this kind videos sir
Always welcome
Wonderful Chandoo
You are welcome Aj.
Hello I'm interested to watch your videos every day.. it's more informative thing makes us thanks for this,, you are also doing more productive vedios than your past vedios we love the way how passionate about your doing this chandoo have a great time 🥂🥂.. keep going and achieve Big 💐💐
Thanks Sai. I am glad you are enjoying and learning more everyday :)
@@chandoo_ Yes hope to be getting more information regarding this
Good 👍💖👍
cute one buddy.. may your supreme bless you
Kindly help me with how you formatted the last part. the revenue, costs and profit part
Very good
Thanks
Thanks for your great videos. what if the budget we want to create has a different periodic method. for example one cost we enter is monthly bases the other on bi-weekly or weekly. how to enter data with different periodic and get the sum in monthly base. Thanks
Top 5 Costs, Revenues formula did not show here. Need to learn that formula, pls help me.
Nice sir.
😍
Thanks ✌️
How can I add paid invoice and update the budget. Scenario: receiving invoice for software/computer costs, HR services, Legal services, etc. Is invoice tracking separate from budget? I am studying for a job test
Always appreciate your content Chandoo ,keep going.
But how did you prepare the top 5 cost ? you made me curious .
Thank you Hamza. I used SORT and FILTER functions for that. See the download file for the formula.
@@chandoo_ i learned so much from you, can you make a video how did you do the profit sections and for the top 5 cost and revenue PLSSSS🙏
Dear Sir,
Please explain the formula used to calculate top 5 costs and revenues. Please help.
Woo-hoo!💪😁🌴🤙
😎😎😎
hello sir can u tell me the future of power bi. should i take the power bi tool as carrier
Sir m trying to multiply price and number but the answer is coming "value" because of the currency sign. I don't know how to fix it. If I manually remove dollar sign and then multiply price and number, the answer is correct. How to fix it.
hi! may I know how did you calculate the variance% in the profit section
Variance % = (Actual - Budget) / Budget and formatted in %
Refer to the sample workbook (link in video description) if you need more help.
i wanna calculate amt * hrs but calculations is not coming exact how to fix it please help??as if I multiply inr 108800*755:00 hrs result should be 82144000 but it's showing 3422667...plz help sr
Each day in 1 number in Excel. So, each hour is 1/24 of a day. If you do =108800*755:00*24 then you get the correct result.
@@chandoo_ thank you soo much srr
Sir, Can I do same thing on Google sheets as per my requirements...
You can. Give it a try.
Hi Chandoo,
Your recent subscriber .
Need your help.
If you could reply on an urgent basis,
I want to know that how to create hyperlinks for a range of validation list.
Welcome aboard Mukul. I don't reply on urgent (or really any) basis. I suggest posting questions in a forum or checking with a colleague / friend for help in situations like this.
Reg. hyperlink, have a read on this page - chandoo.org/wp/excel-hyperlinks/
@@chandoo_ Am so amazed,Chandoo atleast you replied and tried to resolve whatever best you could do for your subscriber.
Thanks in tons.
First👀👿
AWESOME!!!