DEV Community

#excel

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Design the Paper Form for the Spreadsheet: Making Handwritten Field Sheets Convert Cleanly to Excel

Design the Paper Form for the Spreadsheet: Making Handwritten Field Sheets Convert Cleanly to Excel

Comments
5 min read
How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

Comments
6 min read
Setting Excel Worksheet Views with Python: View Modes, Zoom, Gridlines, and Tab Colors

Setting Excel Worksheet Views with Python: View Modes, Zoom, Gridlines, and Tab Colors

Comments
5 min read
How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

Comments
7 min read
How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

Comments
7 min read
Salary slip format in Excel: a printable payslip you fill from one register

Salary slip format in Excel: a printable payslip you fill from one register

Comments
3 min read
Invoice format in Excel: a simple layout with an optional tax % column

Invoice format in Excel: a simple layout with an optional tax % column

Comments
3 min read
Order Tracking Spreadsheet for Online Sellers: Ship-By Dates, Late Orders and Profit per Order

Order Tracking Spreadsheet for Online Sellers: Ship-By Dates, Late Orders and Profit per Order

Comments
4 min read
How to Batch Fill 100+ PDF Forms from an Excel or CSV File (Without Acrobat Mail Merge Plugins)

How to Batch Fill 100+ PDF Forms from an Excel or CSV File (Without Acrobat Mail Merge Plugins)

Comments
7 min read
How to Get a Table Out of a Photo or PDF and Into Excel Without Retyping It

How to Get a Table Out of a Photo or PDF and Into Excel Without Retyping It

Comments
3 min read
A simple order and shipping tracker spreadsheet for small online sellers

A simple order and shipping tracker spreadsheet for small online sellers

Comments
2 min read
How to Build an Inventory Reorder Sheet for Resellers in Excel

How to Build an Inventory Reorder Sheet for Resellers in Excel

Comments
4 min read
A freelance income tracker spreadsheet: invoices, unpaid clients, and money set aside for tax

A freelance income tracker spreadsheet: invoices, unpaid clients, and money set aside for tax

1
Comments 1
2 min read
엑셀 정기비용표: 월평균과 지급월 금액 나누기

엑셀 정기비용표: 월평균과 지급월 금액 나누기

Comments
2 min read
Building a printable invoice from a table in Excel and Google Sheets (no FILTER, no macros)

Building a printable invoice from a table in Excel and Google Sheets (no FILTER, no macros)

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.