Uploaded August 2023 | Updated November 2026, 3 days ago
Learn how to calculate Quick Ratio, Inventory Turnover, IRR, ARPU, CAGR and many other accounting / finance KPIs using Excel in this video.
Accounting and Finance top 10 formulas covered in this video are:
0:00 - Introduction
0:11 - Net Profit Margin
0:49 - Revenue Growth
1:50 - Quick Ratio
3:44 - Inventory Turnover
4:47 - Days Inventory Outstanding
5:53 - Low Inventory Kernal Exposure ๐
6:16 - ARPU
6:49 - NPV
10:06 - Compound Interest
11:26 - CAGR
12:53 - Depreciation (SLN, DB vs DDB)
16:08 - Next steps
๐ Sample file with all these calculations
Download the sample file with all these calculations from this page - chandoo.org/wp/top-10-accounting-kpis-excel
~
๐บ WATCH NEXT:
Top 5 Finance Functions in Excel - Live Masterclass Replay (Must watch, 1.4 mn+ views) - youtu.be/B1WWWGeFqTM
Top 10 important Excel functions - youtu.be/HgNCvd8IbSc
Top 15 Excel functions - youtu.be/B5hayFelHDU
Top 8 Pivot Table tricks - youtu.be/aofsdpjvK7w
Learn how to calculate Quick Ratio, Inventory Turnover, IRR, ARPU, CAGR and many other accounting / finance KPIs using Excel in this video.
Accounting and Finance top 10 formulas covered in this video are:
0:00 - Introduction
0:11 - Net Profit Margin
0:49 - Revenue Growth
1:50 - Quick Ratio
3:44 - Inventory Turnover
4:47 - Days Inventory Outstanding
5:53 - Low Inventory Kernal Exposure ๐
6:16 - ARPU
6:49 - NPV
10:06 - Compound Interest
11:26 - CAGR
12:53 - Depreciation (SLN, DB vs DDB)
16:08 - Next steps
๐ Sample file with all these calculations
Download the sample file with all these calculations from this page - chandoo.org/wp/top-10-accounting-kpis-excel
~
๐บ WATCH NEXT:
Top 5 Finance Functions in Excel - Live Masterclass Replay (Must watch, 1.4 mn+ views) - youtu.be/B1WWWGeFqTM
Top 10 important Excel functions - youtu.be/HgNCvd8IbSc
Top 15 Excel functions - youtu.be/B5hayFelHDU
Top 8 Pivot Table tricks - youtu.be/aofsdpjvK7w



![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. ๐
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)




