I am working in a reputed MNC. We are looking for a Business Analyst who is really skilled in Excel, and also well versed in applications such as Power BI and Power Apps. Relevant experience of 3 - 4 years in data analytics is a prerequisite.
@@XLnCADMalayalam :thank you sir ,I have one doubt about appointment scheduling , appointment schedule cheyyumbol last visit ,next appointment date mathrame cheyyan pattunnullu, epo oru patient varunnu a patient inte ethuvare visit cheytha datum ,eni visit cheyyanulla datukalum ,cheyyan pattunna excel formula cheyyan pattumo.sorry ethrayum neetti message cheyyunnathu u ,doubt chodikkan vere arum ella. I expect a reply ..sir appointment scheduline kurichu oru video consider cheyyanam Thanks and regards Rejani
Thank you so much.... Your work here is so precious for those who needs it. Thank you sir. This has saved me a lot of time. Keep doing more. Your way of presentation is just perfect. Thank you big time.
Chetta, njan description il kanunna linkil ninnum aanu data download cheythath but date wise sales report pivot table il cheythappol avide month alla varunnath oru date um thazhe thazhe varunnu, can you please help me.
If you are using an Excel Table as the source data for PivotTable, go to the PivotTable Analyze tab on the Excel Ribbon and click on Refresh. Otherwise go the PivotTable Analyze tab on the Excel Ribbon > click on Change Data Source > redefine the data range of the source using the Change PivotTable Data Source dialog. Check my video on introduction to PivotTable for more details.
When I drag date field to row. It shows date wise results, not month wise result as seen in the video. How can I convert the date wise information to month wise.
@@XLnCADMalayalam Thanx. Now it's working.. One doubt Sir Dash Board complete ചെയ്തതിനു ശേഷം Datas update cheyyan പറ്റുമോ?. I mean sales Datas. അങ്ങിനെ datas update ചെയ്താൽ അതിൻ്റെ updation dashbord lum ഉണ്ടാകുമോ
Work ടൈമിൽ എക്സലിൽ എന്തു ഡൌട്ട് വന്നാലും ആദ്യം വന്നു നോക്കുന്ന ചാനൽ ഇതാണ്. Thanking you sir..
Glad to hear that :)
Njanum
Me too
Njanum
Me too and I am doing it now
I am working in a reputed MNC. We are looking for a Business Analyst who is really skilled in Excel, and also well versed in applications such as Power BI and Power Apps. Relevant experience of 3 - 4 years in data analytics is a prerequisite.
താങ്കളുടെ ശബ്ദം പൊളി യാണ്.......
ഓരോന്നും മികച്ച പഠനങ്ങളാകുന്നുണ്ട്. Very useful .
Glad to hear that. Thank you :)
This is really great! I have created a dashboard. Thank you for sharing the knowledge.
You're very welcome!
Thank You . I practiced it using the data you have provided.Your teaching style is very easy to understand.
Glad to hear that
Sirnte videos ellam kananrundu . bhayankara helpful anu .
😀Glad to hear that
@@XLnCADMalayalam :thank you sir ,I have one doubt about appointment scheduling , appointment schedule cheyyumbol last visit ,next appointment date mathrame cheyyan pattunnullu, epo oru patient varunnu a patient inte ethuvare visit cheytha datum ,eni visit cheyyanulla datukalum ,cheyyan pattunna excel formula cheyyan pattumo.sorry ethrayum neetti message cheyyunnathu u ,doubt chodikkan vere arum ella. I expect a reply ..sir appointment scheduline kurichu oru video consider cheyyanam
Thanks and regards
Rejani
i learned excel from Ur videos , big thank you
Glad to hear that 😀
Interesting and very much useful for submitting yearly reports. Thanks a lot for your each classes. 👍👍
Thank you for your kind words :)
Pwoliii pwolliii😍 excel padikan ipol nalle easy annu sir ullond thankyou verymuch sir 🖤
താങ്കളുടെ ശബ്ദം 🔥ഹെഡ്ഫോൺ വെച്ച് കേൾക്കണം. Very Useful Video Thanks
Glad to hear that 😀
Really amazing. Normallympeoe are reluctant to share knowledge ,only great people can .
Nice crisp and clear sound!👍
Excellent , this is really helpful for me. Definitely I will be using this method for my data analysis
Glad it was helpful!
Awesome presentation. Thank you so much for such an informative session.
My pleasure 😀
I was Zero in Excel. Now I can say that I know Excel.
Your content creation and explanation are too good
Thanks from Qatar
Thank u for this info. Clearly explained 👍🏽
Glad to hear that :)
Very informative video, thanks for sharing.
Thank you so much for your valuable session , very much informative.👍
Most welcome 😀
Thank you so much. very useful video
😀👍
Thanks , Amazed to see the presentation and approach details , Thanks again
Glad you liked it! :)
Thank you so much.... Your work here is so precious for those who needs it. Thank you sir. This has saved me a lot of time. Keep doing more. Your way of presentation is just perfect. Thank you big time.
You are most welcome
Thanks. Very useful video.
Thank You very much for this class. It will really help me to make my presentations in better look. 🥰
My pleasure :)
Good sound and great presentation skills.👍
Very well explained. Thank you. Waiting for advanced dashboard.
Great tutorial. Thanks a lot 🙏 💓
You are talented in the teaching profession, way of presentation is really excellent and easy for the viewers to follow. Thanks and God bless you .
Thanks so much sir it’s very helpful for me
Glad to hear that 😀
Thank you sir you video very helpful for learning easily !
You can double click on format painter to copy paste format to multiple charts instead of clicking on it each time
😀
Your really talented and gifted for flowing knowledge. 👍🏻👍🏻👍🏻
Thank you for your kind words :)
Great tutorial sir
Excellent...👍✌👌
mind blowing tutorial Thank you
You are most welcome
If you double click or triple click on format painter you can keep using format painter for multiple times
Thank you for that tip :)
Really helpful chetaa..💥💥 Waiting for more advanced dashboards.
Thanks Chetta ❤
Good Afternoon, you are really Rock. (Sadik- Calicut- Vatakara)
Thank you very much for sharing . Useful in our monthly report presentation
Glad it was helpful! :)
The contents in your videos are very useful. I love your style of presentation too. Keep going. All the best👍👍👍
Thank you 😀
Please do a video on creating stock and issue register including price of articles for MDM at school
Brilliant teaching🙏
Thank you! 🙂
Superb , thanks for the effort and waiting for the next.
Most welcome 😊
excellent description and teaching. thanks for your effort. please produce more
Thank you :)
Very useful .thankyouu 👌
Sir Course fee ente subscription and Views🙏
Really helpful,, Thank you
very useful,thanks a lot. waiting for more vdos.
Great work simplified
Glad it helped :)
Super....thanks a lot
Very nice classess. Thankss
You are welcome :)
Superb performance ❤
😀
Super Very helpful
You are a priceless gem.
Góod teaching...useful..
Interesting and very useful.
Waiting for advanced dashboard, please do it ASAP
😀👍
Hi, Well presented. Very useful ✨, thank you for putting this together ✨🙏👍🏻
Glad it was helpful!
Excellent Teaching !!!!
Thanks Ajay chetta
Superbbbb....thank u for ur time
My pleasure :)
Warehouse customer stock report with in and out dimensions,cbm date days in excel formula
Voice👌
Can you believe..? This helped me to get an award!!! Thanks a lot!!
You know how to update it on weekly basis?
@@sreeraj54 update data in tabel, then, Go to data, Click refresh all. I think all data will update
Thank you so much Sir for the preparation of Dashboard. Could you please show how to create an HSES dashboard?
I recommend creating the Dashboard of your own and let me know if you are facing any problem.
Very useful... great job
Could you please do a video on combine dashboard using data from different sheet with different information
hii could you pls make a video of how to work power query in power BI. thank you
I have done a video on Power BI. Please go through the Videos section of this channel to find it.
Do u have aging report format for customer and vendor?
Thank you for the suggestion.
Good presentation
Glad you think so!
You are genius
😀
Actually nhan dashboard create chythu varumayayirunu , ith kandapo orupad easy aayi felt , thanks for it
Glad to hear that😀
If we add rows to the excel data sheet,will it be updated in the dashboard report?
Great❤️
😀👍
Very nice .....super 👌
Thank you :)
Very helpful ….👍
😀👍
Very well explained. I have one doubt. While preparing monthwise pivot table, in stead of month , dates are reflecting. Please help
Please check the comments section of this video.
Thank you 🙏🏻
My pleasure :)
Thank you 😊 😍
You're welcome 😊
Excellent.......
Thank you! Cheers!
Good one
Thank you! Cheers!😀
Thank you
:)
Wonderful..!
Thank you :)
Thanks for this Good Content video, also I'm expecting advanced Dashboard videos using different data sets and In desgin perspective too..
😀👍
Me too
വളരെ ഉപകാര പ്രദം
Glad to hear that. Thank you :)
Month on month how can we update the tracker as per sales...using this dashboard
Super
😀👍
Hello sir
How you sort the data monthly could you please explain
Check my videos on 'Custom Lists' and the 'Sort' option in Excel.
ഒത്തിരി ഇഷ്ടം....
Chetta, njan description il kanunna linkil ninnum aanu data download cheythath but date wise sales report pivot table il cheythappol avide month alla varunnath oru date um thazhe thazhe varunnu, can you please help me.
Sir one doubt. Enganeyanu existing piviot dashbordil extra coloumn add cheithu update cheiyunne
If you are using an Excel Table as the source data for PivotTable, go to the PivotTable Analyze tab on the Excel Ribbon and click on Refresh.
Otherwise go the PivotTable Analyze tab on the Excel Ribbon > click on Change Data Source > redefine the data range of the source using the Change PivotTable Data Source dialog.
Check my video on introduction to PivotTable for more details.
@@XLnCADMalayalam thankyou sir for your valuable repky👍👍👍
So we can Incorporate yearly comparison v/s last year in nhe same dashboard?
Yes. Of course 👍
Excellent.
Thanks a lot. 👍👍
My pleasure :)
Personal income and expenses nu pattiya oru Dashboard create cheyyan tutorial vedio cheyyamo.?
While inserting slicer, where did the month column come from? Month was not there in the original data base. Pls clarify
Right click on the column with Dates > Group > In the dialog called Grouping, select Months and click OK
@@XLnCADMalayalam Thank you
When I drag date field to row. It shows date wise results, not month wise result as seen in the video. How can I convert the date wise information to month wise.
How can I do this???
Right click on the column with Dates > Group > In the dialog called Grouping, select Months and click OK
@@XLnCADMalayalam Thanx.
Now it's working..
One doubt Sir
Dash Board complete ചെയ്തതിനു ശേഷം Datas update cheyyan പറ്റുമോ?. I mean sales Datas.
അങ്ങിനെ datas update ചെയ്താൽ അതിൻ്റെ updation dashbord lum ഉണ്ടാകുമോ
after making the dashboard, if I change the values in the source list will change the dashboard accordingly?
After adding data to the source table, go to the PivotTable Analyze tab > click on Refresh