Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more.
I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. www.excelcampus.com/newsletter/
And don't forget to subscribe to our RU-vid channel. Thank you!
2% difference is also the correct answer. There is an absolute difference and a relative difference. 2% is an absolute difference. 66.7% is a relative difference. that's all.
We have a longer video (2 min) on our channel that explains what version this is on and the keyboard shortcuts for it. Click the link in this video to watch it.
Great video of how the Groupby & Pivotby are awesome new Excel formulas. I have been playing around with them and they are great. One thing I was wondering is there anywhere to group together multiple items (like with pivot table groupings), for example if you have data on fruit and want apple, oranges, and bananas separate but what to group all other fruit together as Misc (grapes, peaches, plums, watermelon, ect..)? Any thoughts on how can be done using these formulas??
This has solved a problem I'd been struggling with, summarising a list of supporting documents relevant to each of our organisational policies. Works perfectly. Thanks so much.
Very helpful video, thank you! Question please, is there a way to select ALL the boxes for a 'sum' from the Subtotal dialog? I have hundreds of columns I need to sum by different categories. Thank you!
But percent itself is a scaled measure. Then if you do this calculation over percentages, then you have to say "rate of A is x times better/worse than rate of B"
Jon, I have a nonprofit and we would like to discuss a position on our Advisory Board. I am not sure how to connect. Our channel is Best Coaching 4 Life Success. We are a family Coaching org.
Good reason to drop percentage...use a factor. Percentages are kinda "shortcuts" for old fashioned (Casio,....) calculators. I've spend 14 day to explain to the Casio users that 2% markup is the same as multiplying by 1.02. Even though the results are the same they refused to believe it. I rest my case...IMHO people should pass a basic exam in math before they are allowed to use excel... Remember that a percentage literally means ''per hundred" ...
Great question, Anthony! I'll do my best to explain the algebra here. The subtraction in the numerator (formula on the top) in New-Old/Old can be split into New/Old - Old/Old This split can happen because both values have the same denominator of Old (value on the bottom). Old/Old = 1 So that part can be simplified. New/Old cannot be simplified any further. So, the remaining formula is New/Old - 1 I'm not going to claim to be an algebra teacher. Haha! So, if anyone has a better explanation, please share. 🙂 I hope that helps. Thanks again and have a nice day!
This is another outstanding video from Jon at ExcelCampus. This is much easier than using drilldown feature in pivot tables. When you have time, would like to see how you would handle when the columns are not side by side. Many thanks again Jon!
Actually, 2% isn't wrong. If you're looking at descriptive statistics such as what is the difference between the conversion rates between B and A it is a 2% difference in asbolute value. However, if you're looking at change over time or the RELATIVE difference from where it used to be (e.g. the 3% at A) then it would be a 66.7% increase from the relative comparison value. The percentage change value is actually very highly contextual and an increase of 66.7% in different circumstances means different things - it could mean a jump from 30% to 50% - an absolute increase by 20% which I would argue is a much better increase than a measley 2% in this scenario (assuming all other things are equal). It's the same as saying an increase from 1% to 3% is a 200% increase from the previous, even though it is the same absolute magnitude as going from 8% to 10% (an increase of 25% relatively).
Hi Christopher, Thanks for your comment. My point is that it can be much more beneficial to look at the relative difference instead of the absolute. I agree that context is needed, and I always like to show the percentages being compared along with the percentage change (relative difference). Sorry, I forgot to mention that in the video.
@@ExcelCampus This is a rare scenario where I would philosophically disagree with you. Just like in your example of going from 3% to 5% being 66.7% and 5% to 3% being 40%, the context influences the analysis. Your video, however, is spot on for teaching how to use that formula (whenever that is relevant). I just don't really know of many situations where I would be relying on a context-influenced value as opposed to an absolute.
This is absolutely great! I've just copied the formula for a project of mine. Thanks, Jon. I was wondering if you could modify the formula in such a way that the details are still visible if you put a filter in one of the columns. For example, you want an overview of all the orders from July 13, filter by that date in the date column and then select the checkbox for order 202121 so you still see the 5 items for that order. Hope that makes sense. But, thank you so much again for this fantastic solution.