Practical Excel utilities are being prepared.
Excel Utilities
Quick, focused tools for common Excel tasks.
Excel Column Letter to Number Converter
Convert Excel column letters such as A, AA and XFD into column numbers, or convert numbers back into column letters.
Open ToolExcel Cell Reference Generator
Generate relative, absolute and mixed Excel references such as A1, $A$1, A$1 and $A1.
Open ToolExcel Percentage Calculator
Calculate percentages, increases, decreases and percentage change with matching Excel formulas.
Open ToolExcel Date Difference Calculator
Calculate days, weeks, complete months, complete years and detailed date differences with Excel formulas.
Open ToolExcel Formula Generator
Generate ready-to-copy Excel formulas for SUM, AVERAGE, COUNT, MAX, MIN, ROUND and more.
Open ToolExcel Text Case Converter
Convert text to uppercase, lowercase, Proper Case, Sentence case or toggle case, with matching Excel formulas where available.
Open ToolExcel Number Format Generator
Generate Excel custom number format codes for numbers, percentages, currency, leading zeros, scientific notation and more.
Open ToolExcel Workdays Calculator
Calculate calendar days, working days, weekend days and full weeks with Excel NETWORKDAYS guidance.
Open ToolExcel Age Calculator
Calculate age in years, months and days, plus total months, total days, next birthday and Excel DATEDIF formulas.
Open ToolExcel Loan Payment Calculator
Calculate loan payments, total payments and total interest with matching Excel PMT formulas.
Open ToolProfit Margin Calculator
Calculate profit, profit margin, markup and selling price with matching Excel formulas.
Open ToolBreak-Even Calculator
Calculate contribution margin, break-even units, break-even sales and target-profit requirements with Excel formulas.
Open ToolVAT / Sales Tax Calculator
Add tax to a net amount or extract tax from a tax-inclusive amount with matching Excel formulas.
Open ToolDiscount & Sale Price Calculator
Calculate sale price from a discount, or find the discount percentage from original and sale prices.
Open ToolCommission Calculator
Calculate commission amount, total earnings, or the commission rate from sales and commission values.
Open ToolSalary Increase Calculator
Calculate a new salary from an increase percentage, or find the increase percentage between two salaries.
Open ToolGross Profit Calculator
Calculate gross profit, gross margin and cost ratio, or find the revenue required for a target gross margin.
Open ToolNet Profit Calculator
Calculate net profit, net profit margin, total expenses and expense ratio, or work backwards from a target net margin.
Open ToolROI Calculator
Calculate return on investment, net return and return multiple, or find the total return required for a target ROI.
Open ToolCompound Interest Calculator
Calculate final balance, total contributions and interest earned with regular contributions and multiple compounding frequencies.
Open Tool