I Charged Rs. 8000 for 1 Excel Dashboard 🔥🔥

[@learnwithlokeshlalwani]

FREE Live Masterclass. Register Now. event.webinarjam.com/register/13/m4851s2

[@AyushPal-r5t]

Sir mein kaun sa laptop lu for excel work and many more

[@kirtirawat4089]

I want to start urgently this year ... I know this already but it helps me to improve .. Thank u so much sir 😢

[@sharma7079]

Those who don't have teacher and they struggle alone to learn and earn from excel ..you are best sir thank you so much 🙏🏻

[@learnwithlokeshlalwani]

It's my pleasure

[@ExploringMinds0690]

Loving how you’re showing the real value of Excel. Video in Excel dashboard sounds awesome!

[@abduldanish4993]

KZbin me aapke jaise bando ke mani nahi hai lekin aap jaise cheezo ko samjhate hai wo bhut easy lagta hai sir. Thank you so much..

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@thefoodtravelvlogs7659]

Wow, Rs. 8000 for a single dashboard? 🔥🔥 Can't wait to see the upcoming video!

[@prateekgupta7049]

The value of Excel skills just keeps going up! Super excited to see!

[@Saikrishna21-s5m]

Hats off u sir u are teaching skills for free

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@Saikrishna21-s5m]

@@learnwithlokeshlalwani sir iam attending the webinar can I get free excel book

[@yuvarajsonale6447]

This is the 2nd video of yours I am watching and it blown my mind. Hats off to you and God bless you 🙏

[@learnwithlokeshlalwani]

Thank you so much

[@ahmedali-bo3dz]

Homework answer is 44515.76 and A Bar chart is more convenient to use over here.Thanks

[@nawazahamedthumbe9651]

Sir aap ka class really great sir...mai accounts job karr ra haa hoon...saath thoda sa advance excel knowledge hai.sql phython sab no idea....pls ek class vedio banao excel data se good Report (analysing dashboard)....so we can present good report sir...pls sir

[@shubhamsingh0208]

Wow! This video is going to be so helpful for freelancers like me. Can't wait to watch!

[@kunalmate2082]

Thank you so much Sir for this easy and quick learning! Wishing you the best of everything. I Created Bar Chart for the Sub Category and the profit amount for Phones is 44516. Looking forward to learning more from you!!

[@Mahadj-wv2uo]

Aisy hi achy v log banye hum jaison ko sajye ap ko Like milta rahye ga❤

[@Sahilkhan-jd5fz]

Great learning experience and you explained it so flawlessly.

[@learnwithlokeshlalwani]

Glad it was helpful!

[@meghabansal3333]

Thank you so much Sir for this easy and quick learning! Wishing you the best of everything. Looking forward to learning more from you!!🙏🏻

[@Anirudh0690]

I've always wondered how much people charge for dashboards, excited to learn your strategy!

[@shamskhattak1984]

I Created Bar Chart for the Sub Category and the profit amount for Phones is. 44516. Thanks for the updates regarding dashboards and excel work indeed it helps a lot.

[@learnwithlokeshlalwani]

Nice work! Thank you so much for your comment.

[@BILALKHAN-wj9jr]

I REALLY APPRICATE YOU I MADE DASH BOARD DMART DASHBOARD AFTER WACHED YOUR VIDEO IT'S REALLY AMAZING AND WONDERFULL CHART I MADE I WANT TO SUBMIT IN COMMENT BUT THERE HAVE NO OPITON FOR SUBMITED ...KINDLY TELL ME WHERE I HAVE TO SUBMIT THIS PROJECT ..THANK YOU

[@hemantshrivastav1142]

In a Column chart, Phones in sub category generated the profit of 44515.73

[@sirajummunira8443]

i really like your videos. I started freelancing on fiverr after watching your motivational videos. Now I really got an order. Thanks for those videos. From Bangladesh.

[@learnwithlokeshlalwani]

Great to hear! Keep watching!

[@lynexatik6625]

i'm from bangladesh , i love your content because you are a good teacher , we want to learn from you more . We want free data analyst full curse from you sir please ?

[@nitishk7865]

Bhai lekin wo "Category Wise Sales" ke pie chart mein client ko pata kaise chalega ki kaunsa piece furniture ko dikhaya hai kaun piece office supply ko dikhata hai... Kyunki legends toh hide kr diye aapne

[@VikashGupta-ht3um]

Homework answer :- Sub category wise sales of phones - 44516 and appropriate chart is column chart. Thank you sir for this amazing video🙏.

[@learnwithlokeshlalwani]

Correct Answer!

[@akshpundir2649]

Thank you sir, please make more videos on excel dashboard🙏🙏

[@learnwithlokeshlalwani]

Sure. Will make more in future.

[@ravirangarja]

Nice sir Thank you sir🙏 Mujhe work mil gya aapki vajah se... Thank you so much😊

[@learnwithlokeshlalwani]

Glad to hear. Keep up the good work.

[@sabarahman4919]

You make such simple videos 😊

[@learnwithlokeshlalwani]

Thank you so much

[@debiprasaddutta2506]

Home Work Answer:- 1. Create 'Sub-Category Wise Profit Pivot Table'. 2. Based On The Pivot table Create a 'Column Chart'. We can use 'Bar Chart', but in this case I preferred to go with 'Column Chart'. 3.Create a 'Slicer' to Find-out 'Profit in Phones(44516) Sub-Category' with 'Column Chart'. Please let me know if I have done anything wrong. It's my humble request. Finally thanks for this session.🙏

[@learnwithlokeshlalwani]

Great work! Correct Answer!

[@debiprasaddutta2506]

@@learnwithlokeshlalwani Dear Sir, Please Provide Raw / Sample Data & Give us Home Work with a Series of Question. We will solve & let you know the Answer.

[@kunalroy9785]

thank you so very much for this please upload some new content with excel for better understanding

[@learnwithlokeshlalwani]

Sure, more to come.

[@rabiaakmal4191]

great video but music in the background is super distracting

[@sonia_fitnessjourney]

Sir apki videos se mujhe kafi inspiration mili hai. Lekin maine abhi kisi se bat ki uska kehna hai ki automation and coding ki wajah se isme jyada scope nhi hai. Sir mujhe apki guidance chahiye please sir ho sake to ispe kuch samjha dijiye.

[@Irshadali-cu2jq]

Sir! The subcategory wise profit in phones is "44516" with using "stacked line with marker chat".

[@learnwithlokeshlalwani]

The answer is correct.

[@Vijaykhandebharad8725]

sir your video is awesome and very helpful to viewers.👌💕

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@Rathod_Mayur04]

Thank you for this wonderful support

[@learnwithlokeshlalwani]

Always welcome

[@Rathod_Mayur04]

@@learnwithlokeshlalwani Sir but power query wali working book me slicer add ni ho raha

[@JustRanodmThoughts]

Very very informative video gonna dive in your videos to start my freelancing journey.. little bit nervous though When will you conduct your free session? And what are the necessary topics we should cover to start freelancing in excel And how to understand client needs and are there any sources to practice different scenarios on data ?

[@rjmordiya256]

Sir mujhe excel sikhna h to aapka koi course h kya mujhe aapki knowledge achhi lagi sir ❤❤❤

[@sahilsingh2535]

Sir, as you had given homework at the end of the video to calculate the profit of the phones. The answer is 44515 Sir, if my answer is correct then please write "good" in the comment. And I have used column chart in the data.

[@learnwithlokeshlalwani]

The answer is 44516. And appropriate chart type should be Bar Chart!!

[@fayazkhan2890]

But Lokesh what about Data cleaning, we might be having messy and unorganised data.

[@Ms_Office-0]

My Sub Category Profit is :- " 2,86,397 and i am using Coulmn Chart. And Thankyou for coming in my life ❤

[@7.22fanstastic]

It's very interesting video 😊

[@learnwithlokeshlalwani]

Thanks for visiting

[@Yash_Rajput14]

Thank you sir itna achi video bnane k liye ❤

[@jenilstech]

thank you sir for ist vary useful video

[@jenilstech]

I can post in my LinkedIn account and I mantion you ❤️

[@NazarFarid-wc7bu]

Very informative. Profit in phone sub category is 44516 and type of chart used Bar Chart. Butt pie charts used in video not showing Names of 1) Category 2) Region 3) Shipment Mode 4) Segment, we can't check which part of pie showing which detail.

[@learnwithlokeshlalwani]

Correct Answer!

[@Crypto.khabar11]

Sir ap jo homework dete hai agr vo solve krne me problem aa rhi toh uske lie??.... Please khi pr ek community type kuch bnaiye jha pr sb log join ho or problems solve ho sake

[@shubham_M7777]

Can I become self taught data Analyst, by watching yt tutorials videos or online courses? I'm not good at maths, hate maths so it'll good career option for me? Can I suitable for this role because I'm not good at maths and all 😢 Also Confused to choose between web developer vs animation vs graphics/ui/ux designer. Confused 😕 Can I get a job by learning these skills by doing course or from yt? Without graduation, degree? Because They said you can get job without degree, graduation. Lot of people are self taught still working in office, that's why I'm confused in these skills. If i learnt any skill from these i have to freelance it, most of companies ask for requirements qualifications but I'm dropout and confused. I'm interested in freelancing, i like it but watched some videos that they are saying freelancing is hard it's not easy to depend on freelancing etc. can I make career in freelancing? Can I do it as full time, lifetime business? How to convert it into business? Very 1st thing i want to choose between those skills, so as a freelancer and experienced person/ freelancer can you suggest/guide me which is better? How to choose? Web development vs data analyst vs graphics/ui/ux designer ? Please help 🙏🏻

[@learnwithlokeshlalwani]

Thanks for reaching out! I can sense you're in a spot many people find themselves in when deciding on a career path, especially with the rise of online learning and freelancing. Let me try to break this down for you. Data Analyst Role (without strong math skills): Yes, it’s absolutely possible to become a self-taught data analyst by watching KZbin tutorials and doing online courses. You don’t need to be a math genius, but a basic understanding of statistics will help. The good news is, most data analytics involves tools like Excel, Power BI, and SQL, which handle the calculations for you. If you enjoy working with data, solving problems, and presenting insights, you could thrive in this field, even without an advanced math background. Web Development vs Animation vs Graphics/UI/UX Design: These fields are all creative and have the potential for growth, but they each require different skill sets. Web Development: If you like coding, solving problems, and building websites/apps, this could be a great fit. There are many self-taught web developers, and the demand is high. Graphics/UI/UX Design: If you’re more inclined towards creativity and design, UI/UX could be ideal. It’s less technical than web development but still has good demand. Animation: This is more niche but highly creative. It’s a bit harder to break into compared to the other two, and the tools can be complex. Getting a Job Without a Degree: It’s true that many people have built successful careers without a degree, especially in tech and creative fields. However, it might require more effort to prove yourself-through a solid portfolio, freelancing, or internships. Keep in mind, some companies still prioritize degrees, but with freelancing, you get to control your career. Freelancing as a Full-Time Career: Freelancing can definitely be turned into a full-time, long-term business. However, it’s true that it’s not easy, especially when starting out. It requires persistence, building a client base, and marketing yourself. The freedom and flexibility are great, but income can be unstable in the beginning. If you enjoy the hustle, freelancing can be rewarding, but it’s important to have a plan to grow it into a sustainable business. How to choose? Ask yourself a few questions: What excites you the most? Coding, design, or working with data? Do you enjoy working on creative projects or problem-solving with numbers and logic? Are you willing to invest time in building a strong portfolio and skills, even if it takes a while? As someone with experience in freelancing, I’d suggest starting with the skill that excites you the most and testing it through projects or freelancing. You can always pivot later if needed. Remember, there’s no one-size-fits-all answer. It’s more about what aligns with your interests and how committed you are to learning and improving in that field. Hope this helps you make an informed decision! Feel free to ask if you need more guidance.

[@anujdhaka3507]

Profit in phones sub category:44,516 Bar chart used

[@gaffarhusain3632]

Very very thanks❤

[@govindmallik6640]

Hello sir Kindly make a video on advanced level excel

[@learnwithlokeshlalwani]

Sure, will make a video in future.

[@Deepak_mdptkm]

There are no free options to apply any job.... So how can we get job... Everyone are new here so why will pay for apply job and how much is the chances of getting selected as we are Fresher on this site for them....

[@Excelhero1122]

Which version of MS Office are you using?

[@Crypto.khabar11]

Amazing sir

[@learnwithlokeshlalwani]

Thanks and welcome

[@chetanjuwar1999]

How I find a client

[@blackhole3553]

Thanks for great Info. Does it ok with if i put this HW as sample projects in my profile?

[@learnwithlokeshlalwani]

Thank you so much for your comment. Yes, you can add them as sample projects.

[@insight_ways]

I have a genuine question, Does the client will give the requirements question? What should be the direction of achieving the objective? Please answer. Thank you!

[@learnwithlokeshlalwani]

Yes, clients usually provide their requirements, but it’s also your responsibility to ask the right questions to clarify their needs. To achieve the objective, focus on understanding the client's goals, defining clear deliverables, and planning your steps accordingly.

[@azazullah7494]

🎉 from pakistan your fan

[@learnwithlokeshlalwani]

Thank you so much.

[@Stylishwithmou999]

Sir I have a question ye jo insert timeline wala option hai bho meri pc me nhi aa raha hain kyuki bho old version hain so instead of this what should I use for this please tell me iske liye bohut problem ho rahi hain mujhe ??

[@SUPRISING_FACTS03]

answer sub category profit by phone is total = 44516

[@learnwithlokeshlalwani]

The answer is correct And appropriate chart type should be Bar Chart!!

[@harshthakur1430]

Thank you so much Sir

[@learnwithlokeshlalwani]

My pleasure.

[@AyushPal-r5t]

Sir mein kaun sa laptop lu for excel work and many more

[@purnendulohar1716]

i can't find the playlist of this kind of videos in your channel. could you please give us the link..

[@shivanandshivayogimath7044]

The data analyst and Excel together how much will you charge? Will it be 9999?

[@learnwithlokeshlalwani]

Please email at [e-mail]

[@shubham_M7777]

​@@learnwithlokeshlalwaniCan I become self taught ui/ux designer? Also Confused to choose between web developer vs animation vs graphics/ui/ux designer. Can I get a job by learning these skills by doing course or from yt? Without graduation, degree? Because They said you can get job without degree, graduation. Lot of people are self taught still working in office, that's why I'm confused in these skills. If i learnt any skill from these i have to freelance it, most of companies ask for requirements qualifications but I'm dropout and confused. I'm interested in freelancing, i like it but watched some videos that they are saying freelancing is hard it's not easy to depend on freelancing etc. can I make career in freelancing? Can I do it as full time, lifetime business? How to convert it into business? Very 1st thing i want to choose between those skills, so as a designer can you suggest/guide me which is better? How to choose? Web development vs graphics/ui/ux designer vs animation Please help 🙏🏻

[@sonusingh2436]

Phones Profit 44,515. I used clustered column chart.

[@sketchoholic6901]

Profit in Phones Sub-category is 44516 and I have used line chart

[@mukulm8853]

How to just highlight slicer selection instead of filtering it ? Like if I click on Phones in slicer then in "sub category wise sales" the PHONES data gets highlighted with may be other colour and other sub category are also shown in the bar chart with default colour.

[@ratanyadav6522]

Sub category profit by phone is 44515.73 using bar chart. for better understanding of are we doing exact what you expect, please can you also make a video on homework, so we can match our work with yours. thank you

[@hydnawabff3459]

Unable to use slicer in my excel cuz i have 2007 version and I somehow manage doing data cleaning in it but iam not able to manage dashboards in it only because of the slicer.

[@SINHA_1357]

Sir, when I copy the DMart Sales page only and work, then the insert timeline is not working & it's showing "Can't create a timeline because date is not given". And if I just download and work then it works well. Why so

[@radhikamittal7744]

Profit in phone sub category is 44516 and type of chart used Bar Chart.

[@creativeaccountant1368]

Thank you sir, for this session, my answer is profit in phones sub category 44516. and create a column chart.

[@learnwithlokeshlalwani]

The answer is correct! Great work!! Appropriate Chart Type - Bar Chart.

[@fakharabbas-gd2rd]

sir agr costumer data khud hi collect krnay ko bolay to kis tara kr sakty han

[@saqibkhan4025]

sir your full ms excel vidro available on KZbin????

[@pratyush1995]

No, you have to buy it for rs 2999

[@Alphamotivater]

I have the skills required but not getting Cliens😢

[@AmanSharma-tn3dy]

i have a question : profit of table subcateory is -17725 it goes left to line, but bar overlap my label, how can I fix it

[@craftme123]

music is too annoying .. it make difficult to listen n concentrate.

[@ayushk1498]

Sir i have no updated excel i have excel 2007😢😢😢😢

[@JayantaRoy-x6m]

Wow❤❤

[@geekygamer828]

sir mere pc me excel nahi hai or kharid ne ke liye 💸 bhi nahi hai kuch aesa tarika hai ki free me excel pe kaam kar ke fiverr se earn kar sake?

[@abdullahmuhammad6559]

Sir meray slicers copy paste nhi ho rhi from one worksheet to another kindly guide ....Charts ho gye hyn

[@Sandeesh_Srikantam]

Can you create one dash board to record investments appreciations ?

[@learnwithlokeshlalwani]

Thank you for your suggestion. Will look into it in future.

[@SalmaAkter-q7s]

Profit in phones is 44516 and i created a clustered column chart

[@learnwithlokeshlalwani]

The answer is correct!

[@sundeep841]

awesome video of dashboard sir, Sub category wise profit in phone is 44516.

[@learnwithlokeshlalwani]

Correct Answer!

[@RajuKumar-xg9uw]

Sir merea dashboard me to timeline ka option hi nhi aa raha h😅 please help me

[@ShreshthaAwasthi-x7u]

Getting an error stating that this field don't have any field related date please assist

[@ashmitchoudhury6211]

@learnwithlokeshlalwani sir I have Created the Bar Chart for the subcategory and the profit amount for Phones is- 44516. Thank you so much for creating such awesome videos and this was one of them. Keep going sir, lots of respect and ♥for you

[@learnwithlokeshlalwani]

Thank you so much for your comment. Great work!

[@khaleddigital]

Sub-Category wise Profit for Phone 44,516 and I use Bar chart.

[@learnwithlokeshlalwani]

Correct Answer!

[@mtchannel80]

889 profit in phone category

[@kuldeepyadavsultanpur8319]

Here is the answer of this video- subcategory wise profit in phones 44516🎯 Highest profit in Copiers 55618⬆ Highest loss in Tables -17725⬇ ICIW-

[@learnwithlokeshlalwani]

The answer is correct. Appropriate Chart Type - Bar Chart

[@debaratnaadhikari4113]

Hello sir I have done my homework And I have been waiting for your videos to learn something new 😊 Here the details my sub category wise profit in phones is 44516 And sorry for late ans And I have use pie chart thank you 😁

[@learnwithlokeshlalwani]

The answer is correct!

[@Rajaji9782]

HOW TO CREATE A OWN PORTFOLIO IN EXCEL. FOR FREELANCING. PLEASE SIR VIDEO BANAO😢

[@AlexKing-x9l]

data entry job ke upar ek video banao bhai

[@learnwithlokeshlalwani]

Sure, will make a video in future.

[@tarekmd4136]

44516 Clustered bar and Clustered Column.

[@learnwithlokeshlalwani]

Correct Answer!

[@vnyvlogs]

The Home work answer is Profit in phones sub category =44516 I have used the bar chat to analys the phone sub category is the second topest category

[@learnwithlokeshlalwani]

The answer is correct! Great work!!

[@AnisMohammed-x8g]

Sir registration nhi ho rha hai error bta rha hai ... what should I do ?

[@cannonstrikers91]

Just like he cannot earn from stock market but he will teach you stock market on yt same as he cannt earn from excel freelancing but can teach you for cuz he can earn from this only

[@meditationforhealth8406]

Pie Chart Created for Sub-Category Wise phone Profit

[@learnwithlokeshlalwani]

Amount?

[@sonalpendhari1382]

Sir how to start ??? It is worth ???

[@Anmol790]

Profit in Phones Sub-Category is 44516,And i am using line chart

[@learnwithlokeshlalwani]

Correct Answer!

[@rohitkumarmaurya6106]

Profit In phones is 44516 and I created a line chart

[@Tanisha.merotha]

sir aap practice sheet phle wale method se de skte h abhi jha se practice sheets milti h unhe me copy nhi kr pa rhi hu or wo use me nhi le pati can u please help sir

[@learnwithlokeshlalwani]

Please email at [e-mail] with the screenshot and the error you are receiving.

[@VishalGupta-ml1km]

Sir mya is sub profit in phone 44516. I use bar chart and slicer use sub category