Excel for Finance
How to Calculate Dividend Per Share in Excel (3 Simple Ways)
Learn how to calculate Dividend Per Share in Excel using total dividends, outstanding shares, EPS, and payout ratios with easy formulas.
Read article
Author & Spreadsheet Consultant
Rudra Nil Utsa
128 Articles PublishedPublishing since
Rudra Nil Utsa holds a BBA and MBA in Marketing from Jahangirnagar University, where he developed strong analytical and spreadsheet-focused skills. With 3+ years of Excel experience, including 7 months dedicated to advanced workflows, he specializes in formulas, text functions, PivotTables, financial calculations, automation, and data cleanup. He has created extensive tutorials, workflow guides, and troubleshooting resources. He enjoys exploring formula tricks and automation techniques.
Editorial Review
Articles Published by Rudra Nil Utsa
Articles by Rudra Nil Utsa are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel for Finance
How to Create a Cash Flow Diagram in Excel (3 Different Cases)
Learn how to create a cash flow diagram in Excel by visualizing inflows, outflows, and cumulative cash flow using a combo chart layout.
Read article
Excel for Finance
How to Calculate Straight Line Depreciation in Excel
Learn how to calculate straight line depreciation in Excel using the SLN function or manual formula with clear, step-by-step guidance.
Read article
Excel for Finance
How to Calculate Margin Percentage in Excel (with Quick Steps)
Learn how to calculate margin percentage in Excel with simple steps, including adding a column and using the correct formula.
Read article
Excel for Finance
How To Calculate Selling Price from Cost and Margin in Excel
Learn how to calculate selling price from cost and margin in Excel by adding a helper column and applying the right formula step-by-step.
Read article
Excel for Finance
How to Calculate Cost Per Unit in Excel (3 Effective Ways)
Learn how to calculate cost per unit in Excel using total cost, total fixed cost, and fixed cost per unit for accurate cost analysis.
Read article
Excel for Finance
How to Calculate YTD in Excel (4 Useful Methods)
Learn how to calculate Year-to-Date (YTD) in Excel using SUMIF, SUM with FILTER, IF-SUM, and SUM-INDEX-XMATCH for dynamic YTD tracking.
Read article
Excel for Finance
How to Calculate Year-Over-Year Growth in Excel
Learn how to calculate year-over-year growth in Excel using data from two or multiple years, including presuming growth rates effectively.
Read article
Excel Pivot Table
How to Calculate Weighted Average in Excel Using Pivot Table
Learn how to calculate weighted average in Excel using a Pivot Table with helper columns and calculated fields in a few simple steps.
Read article
Excel Pivot Table
Create a Pivot Table Calculated Field That Divides Sum by Count
Learn how to create a Pivot Table calculated field in Excel that divides sum by count using a helper column and a custom formula step-by-step.
Read article
Excel Pivot Table
How to Use an IF Statement in a Calculated Field of a Pivot Table
Learn how to use an IF statement in a Pivot Table’s calculated field in Excel, including applying conditions to text fields effectively.
Read article
Excel Pivot Table
How to Delete Calculated Field in Excel Pivot Table (2 Methods)
Learn how to delete a calculated field in Excel PivotTables manually or by using VBA for quick and efficient cleanup of your data.
Read article