If alan would have also spent more than the average 2982 then how would have the expenses split?

First of all, you explain the detailed things so easily. Thanks for the video! Maybe you can help me, I would like to show values of a row in % of a sum. So the first column says 700 and second says 300, so the sum is 1.000. But I want it to be shown in 70% and 30%. Thanks a lot!

Thanks chand...

Thanks chand...

Hi Chandoo Sir, Please make tutorial on Hierarchical Data Hierarchy using Excel : example - level 1, level 2, etc fields data to be viewed in Hierarchy in Excel using pivot table etc. Type of Chocolates, Chocolate Brand, Chocolate Price looking at them or viewing them in Hierarchy using Excel. Really much appreciated 👍

And finally i recognize that your a really Chandoo

Sir Your teaching has changed my work style..efficiency..You are younger to me .l bow down to you for the learnings take away from you❤🙏

i spent around 10 hours in my session by understanding nothing, but here everything is simplified and taught in just 16 mins. welldone bro thanks....

very helpful and informative in less time duration, thanks chandoo bhaiya

best of the best ..

Hi Chandu, was trying to filter text string within a cell with search. But when error value is there Filter gives Error instead giving non error results. Can you help me with this, =FILTER($K$12:$K$14,(SEARCH(H12,K12:K14)))

the chocolate bars graph is yummy indeed 😄. Thanks for the tips Chandoo !

How to get excel dashboard making project for practice.

👌👌

I learned a lot!... Thank you..

do you create custom charts or templates

Thank you sir, we are MBA students and we watch your videos in groups to help each other your are working really hard for such great content, Thank you once again.

hello sir, sir please give me a data for practice please. i would request you give me data for practice of these functions please.

Thanks for sharing - but does you first calculation take into account leap years?

You are really Great ❤❤❤

i am facing syntax error 1064 while selecting columns from a table, how to solve that plz help

Sir is there any other alternative of filter as it is not available in my version

Just wanted to give you a best teacher award 🥇 very helpful! Thankyou for teaching !

Wow, LOVE the detailed the explanation!♥

I have a really complex problem. I feel like there is some way using filter & xlookup to solve this but I can't figure it out. I have a table that has 5 columns (standard, 5 day, duplicate, pre-eng, dwgs only, transcend, other) & then 10 rows with codes for simplicity sake well just say (AA, BB, CC, DD, etc.) There is data that intersects with each column & row. There is a validation input cell. My boss made this huge Ifs formula with Vlookup. I tried to just change all the VLookup with Xlookup but i get an error. I saw a video that can use multi criteria column header with row data but can't make that based on a validation input cell. I know there is a way but I'm wracking my brain to figure it out.

great

Make SQL videos, tutorial

One question is the remaining Number to text example. If possible Please put an example for this question.

What is the DAx to be used to get previous month

I normally love your stuff, but I have to admit this one doesn't hit for me. I'm a huge fan of a high data-to-ink ratio (to borrow a term), meaning anything on there should have meaning. The purple background (3 different shades of purple) is unnecessary. The faded borders and rounded corners on the graph don't add anything. The images on the metrics on the left hand side are fine, because they give you a quick way to know which metric to look at without having to read the header (though I question if those are all the best metrics -- total salary is probably more useful than average salary for HR managers, for instance). You can keep a color on there (I would suggest not purple, but maybe that's a company color), but remove the gradient. Similarly, there are too many colors of the charts. There should be one main color (blue is fine), with a highlight (I prefer orange, but it doesn't matter as long as it's colorblind-friendly) to call out key numbers. The red/yellow of the pie chart really sticks out, but the coloring isn't significant. Purple, dark blue, and orange stick out, but they aren't sticking out on purpose. What I think the dashboard really needs is better design elements and interactivity. The "what do they do?" chart has labels that are too big ("Packaging A..., Production ..."). I would move the labels to the inside, and instead of having numbers on the inside, remove them entirely and replace them with an axis along the top. I would replace the pie chart with a thermometer-style stacked bar chart, and drop the decimals. Really, a simple text box might be equally effective, since people can generally visualize a comparison of two numbers that add to 100. (Or thinking of it, add the male/female color distinction to all of the other charts, so you get an even more in-depth insight!) Age distribution needs more numbers on the X axis, and needs some clarity on the buckets. Is the most common grouping 30-35 or 28.5-32.5? Change the title to an auto-calc text box that tells you either the mean, median, or mode age (highlight the same number on the graph). Salary vs qualifications doesn't really tell you anything, so I'd consider scrapping it. If you must keep it, the colors don't tell you anything, since each lane is also it's own qualification. Add the qualification caption to the beginning of each lane and drop the data key. Add a different colored dot for the average of each lane. For the last graph, the callouts are unnecessary since you've got an axis (they will also likely have to be manually moved around as new data is added -- no fun!). They can be removed. And that small graph is unlabeled, unreadable, and unclear what it's supposed to be until you sit and look at it for a while. I would combine the two into some kind of combo chart, or a set of two panel charts, so at least the year axis are lined up. Maybe a waterfall chart (if you have the proper data for it, this could also show you how many hires were new positions vs turnover). If you've got turnover, call that out, because that's a very important HR metric! Other potential metrics that could be missing: tenure (by gender, position, age, salary, qualification), sick time taken this year (by same categories, plus maybe an average per employee -- if the dashboard is internal only, put names on there for the top sick time takers), vacation lost, salary history, etc, etc, etc. The biggest thing it's missing for me as an analyst are combinations of the graphs. Gender could be added to almost every graph, for instance, or what if you want to know degree by position, or salary by position, or degree or salary by age? The easiest way to do this would be with slicers, though there are probably more advanced ways to do it depending on what you wanted to look at.

@chandoo_ నమస్కారం chandoo గారు మీ videos చూసి నేను చాలా insipre అయ్యాను నాకూ 5 years career gap ఉంది. నేను excel,sql,power bi...etc., అన్ని నేర్చుకోని data analyst job చేయవచ్చ.... మీ reply కోసం ఎదురుచూస్తుంట. Thank you so much🙏 sir

Yes

Thank you Sir

Which excel version is have to use

select geo.*,sales.* from geo, sales where geo = 'Canada'and Amount >5000 order by Boxes;

Very well explained with lot of ease and simplicity in demonstration. Hope much more good helpful videos like this even in future.Tq

hello sir I am new to your channel, i want to learn complete excel from beginning for data analysis but i don't know where to start in your channel, I don't know the order to follow, which playlist should i follow first, so could you please tell me sir