All articles with 'formulas' Tag
{ 1 Comment }
Top 10 Accounting KPIs and How to Calculate them in Excel?
Published on Aug 8, 2023 in Financial Modeling, Learn Excel

We can calculate any Finance & Accounting KPI values using Excel easily. In this article, I am sharing the top 10 accounting KPI calculations. These are… Topics ? Net Profit Margin Net Profit Margin = Net Profit / Sales Positive profit margin indicates business is profitable while negative indicates the business is in loss. ? […]
Continue »{ 3 Comments }
How to write complex Excel formulas (hint: it’s a lot like LEGO)
Published on Dec 9, 2021 in Excel Howtos, Learn Excel

Writing advanced formulas is a lot like LEGO. Use what you already have and combine them in creative ways. Let me demo with 5 examples.
Continue »