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.
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.
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 Dear Sir, Please Provide Raw / Sample Data & Give us Home Work with a Series of Question. We will solve & let you know the Answer.
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 ?
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 ?
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.
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.
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 🙏🏻
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 RUclips 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.
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....
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.
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
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.
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
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 😁
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.
@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
@@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 🙏🏻
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
I am from Pakistan Dear Respected Lokesh Lalwani your video is Very helpful.Today I create Dash Board with the helping your video.Thanks❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
if we sum all the profit of the mobile phones the answer is 0. If not this answer is pls let me know how to know pls dont tell me answer i want to do it myself. Thank You Sir!
FREE Live Masterclass. Register Now.
event.webinarjam.com/register/13/m4851s2
Sir mein kaun sa laptop lu for excel work and many more
I want to start urgently this year ... I know this already but it helps me to improve ..
Thank u so much sir 😢
Those who don't have teacher and they struggle alone to learn and earn from excel ..you are best sir thank you so much 🙏🏻
It's my pleasure
Wow, Rs. 8000 for a single dashboard? 🔥🔥 Can't wait to see the upcoming video!
Loving how you’re showing the real value of Excel. Video in Excel dashboard sounds awesome!
The value of Excel skills just keeps going up! Super excited to see!
Homework answer is 44515.76 and A Bar chart is more convenient to use over here.Thanks
This is the 2nd video of yours I am watching and it blown my mind. Hats off to you and God bless you 🙏
Thank you so much
Wow! This video is going to be so helpful for freelancers like me. Can't wait to watch!
Great learning experience and you explained it so flawlessly.
Glad it was helpful!
Hats off u sir u are teaching skills for free
Thank you so much for your comment.
@@learnwithlokeshlalwani sir iam attending the webinar can I get free excel book
Homework answer :- Sub category wise sales of phones - 44516 and appropriate chart is column chart.
Thank you sir for this amazing video🙏.
Correct Answer!
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.
Great to hear! Keep watching!
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.
Nice work! Thank you so much for your comment.
I've always wondered how much people charge for dashboards, excited to learn your strategy!
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.🙏
Great work! Correct Answer!
@@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.
Nice sir
Thank you sir🙏
Mujhe work mil gya aapki vajah se...
Thank you so much😊
Glad to hear. Keep up the good work.
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 ?
My Sub Category Profit is :- " 2,86,397 and i am using Coulmn Chart. And Thankyou for coming in my life ❤
Thank you sir, please make more videos on excel dashboard🙏🙏
Sure. Will make more in future.
great video but music in the background is super distracting
sir your video is awesome and very helpful to viewers.👌💕
Thank you so much for your comment.
You make such simple videos 😊
Thank you so much
answer
sub category profit by phone is total = 44516
The answer is correct And appropriate chart type should be Bar Chart!!
Thank you for this wonderful support
Always welcome
@@learnwithlokeshlalwani
Sir but power query wali working book me slicer add ni ho raha
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 ?
thank you so very much for this please upload some new content with excel for better understanding
Sure, more to come.
Thank you sir itna achi video bnane k liye ❤
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.
Correct Answer!
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.
The answer is 44516. And appropriate chart type should be Bar Chart!!
Sir! The subcategory wise profit in phones is "44516" with using "stacked line with marker chat".
The answer is correct.
music is too annoying .. it make difficult to listen n concentrate.
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 🙏🏻
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 RUclips 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.
Sir mujhe excel sikhna h to aapka koi course h kya mujhe aapki knowledge achhi lagi sir ❤❤❤
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....
Phones Profit 44,515. I used clustered column chart.
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.
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
i can't find the playlist of this kind of videos in your channel. could you please give us the link..
Profit in phone sub category is 44516 and type of chart used Bar Chart.
Amazing sir
Thanks and welcome
Thank you sir, for this session, my answer is profit in phones sub category 44516. and create a column chart.
The answer is correct! Great work!! Appropriate Chart Type - Bar Chart.
Thank you
Sir mein kaun sa laptop lu for excel work and many more
How I find a client
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.
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
The answer is correct! Great work!!
It's very interesting video 😊
Thanks for visiting
Very very thanks❤
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
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
PROFIT OF SUB- CATEGORY (paper) is 34054
Here is the answer of this video-
subcategory wise profit in phones 44516🎯
Highest profit in Copiers 55618⬆
Highest loss in Tables -17725⬇
ICIW-
The answer is correct.
Appropriate Chart Type - Bar Chart
HOW TO CREATE A OWN PORTFOLIO IN EXCEL. FOR FREELANCING. PLEASE SIR VIDEO BANAO😢
I have the skills required but not getting Cliens😢
Getting an error stating that this field don't have any field related date please assist
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 😁
The answer is correct!
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.
Profit in Phones Sub-Category is 44516,And i am using line chart
Correct Answer!
Sir meray slicers copy paste nhi ho rhi from one worksheet to another kindly guide ....Charts ho gye hyn
My answer is also 44515 I copied u but before I made bar chart I don't know which one is good I hope someone guide us
Sir merea dashboard me to timeline ka option hi nhi aa raha h😅 please help me
Wow❤❤
awesome video of dashboard sir, Sub category wise profit in phone is 44516.
Correct Answer!
@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
Thank you so much for your comment. Great work!
The data analyst and Excel together how much will you charge? Will it be 9999?
Please email at ask@nurturetechacademy.in
@@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 🙏🏻
Sub-Category wise Profit for Phone 44,516 and I use Bar chart.
Correct Answer!
Profit in phones is 44516
and i created a clustered column chart
The answer is correct!
Thanks for great Info. Does it ok with if i put this HW as sample projects in my profile?
Thank you so much for your comment. Yes, you can add them as sample projects.
🎉 from pakistan your fan
Thank you so much.
Thank you so much Sir
My pleasure.
44516 is the amount of profit in phones (sub-category)
Sir, background music irritating us 😢
sir agr costumer data khud hi collect krnay ko bolay to kis tara kr sakty han
Hello sir Kindly make a video on advanced level excel
Sure, will make a video in future.
Ans : 330007
(Profit In Phones Sub-Category )
Please check your answer again.
889 profit in phone category
Profit total 286397
Clustered Bar
Please check your answer again.
Profit of phones 44516 and i used bar chart
Sir i have no updated excel i have excel 2007😢😢😢😢
sir your full ms excel vidro available on RUclips????
No, you have to buy it for rs 2999
Pie Chart Created for Sub-Category Wise phone Profit
Amount?
44516
Clustered bar and Clustered Column.
Correct Answer!
Hello Sir...
Mayne Fiverr Pay Account Create Kar Liya Mujhe Clint Kaise milge ...?
Sir mya is sub profit in phone 44516. I use bar chart and slicer use sub category
Can you create one dash board to record investments appreciations ?
Thank you for your suggestion. Will look into it in future.
Sir laptop कौन सा लेना चाहिए 🤔
Sir registration nhi ho rha hai error bta rha hai ... what should I do ?
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?
data entry job ke upar ek video banao bhai
Sure, will make a video in future.
Hi Lokesh, Phone sub category profit is @ 44,516/-
Great work. Correct Answer!
Sir mere pass MS 365 hai usme adha se jayada featured lock hai
You need to have the paid version.
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
Sub-category profit in phones is 330007
Please check your answer again.
I am from Pakistan Dear Respected Lokesh Lalwani your video is Very helpful.Today I create Dash Board with the helping your video.Thanks❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
Glad to hear. Thank you so much for your comment!
Bhaiya koi bhi job nhi mil rha hai upwork se
How can i download updated excel
Account hi nai ban Raha or client kaha se layege itne sare jan kar rahe he koi hamara Kam lekar jyada paise me bech raha he yaha to....
fiverr me kam hi nai mil raha he koi or batav app
if we sum all the profit of the mobile phones the answer is 0. If not this answer is pls let me know how to know pls dont tell me answer i want to do it myself. Thank You Sir!