#Excel Trick : Finding #Percentage #Change with =PERCENTOFNew, Old - 1 #exceltips #exceltricks

Need a super quick way to see percentage growth or decline between two numbers in Excel? 🤔 Tired of the old (New Value - Old Value) / Old Value formula? This video introduces a much simpler approach using the handy PERCENTOF function!

While the PERCENTOF function primarily tells you what percentage one number is of another, we'll focus on a clever trick: using the formula pattern =PERCENTOF(NewValue, OldValue) - 1 to instantly calculate the percentage change. It's clean, fast, and easy to understand!

In this friendly, step-by-step guide, you'll learn:
✅ How the clever =PERCENTOF(New, Old) - 1 formula works for % change.
📈 How to quickly calculate percentage increase (growth).
📉 How to easily see percentage decrease (decline).
🔢 Why this method can be faster and cleaner than traditional formulas.
💡 Practical examples showing how this simplifies tracking changes in sales, costs, metrics, or any comparative data.
⚙️ How this function streamlines your analysis.

Whether you're analyzing sales figures, tracking financial performance, or comparing any metrics over time, this PERCENTOF trick is a fantastic shortcut for calculating percentage changes!

(Friendly Note: The PERCENTOF function is one of the newer functions available in Microsoft 365 versions of Excel.)

👍 If this Excel shortcut makes calculating percentage changes easier for you, please give this video a thumbs up and subscribe for more simple tips! Let us know in the comments where you'll use this trick!

Subscribe for more simple Excel and Python tips: https://lnkd.in/e2XPfkTh
Follow me on LinkedIn for more tips & tricks: https://lnkd.in/eA5KMPTJ
Download slides and find more like this: https://lnkd.in/dsz5mVFy
Join the FINREX community: https://lnkd.in/dVgiw9na

#Excel #PERCENTOF #PercentageChange #PercentChange #ExcelTips #ExcelFormulas #MicrosoftExcel #ExcelTutorial #DataAnalysis #Finance #SalesAnalysis #Productivity #OfficeTips #LearnExcel #ExcelTricks #Microsoft365

Видео #Excel Trick : Finding #Percentage #Change with =PERCENTOFNew, Old - 1 #exceltips #exceltricks канала Kiarash Arian