DEV Community

#spreadsheet

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Spreadsheet Formulas for an Australian GST/BAS Quarter Tracker

Spreadsheet Formulas for an Australian GST/BAS Quarter Tracker

Comments
5 min read
How I checked a rental-property spreadsheet before selling it: three bugs a clean test run missed

How I checked a rental-property spreadsheet before selling it: three bugs a clean test run missed

Comments
2 min read
Build a Product Master Sheet Before a Thai Distributor Asks: Barcodes, Case Codes and Check Digits for 7-Eleven

Build a Product Master Sheet Before a Thai Distributor Asks: Barcodes, Case Codes and Check Digits for 7-Eleven

Comments
4 min read
How to Build a Timesheet in Google Sheets That Handles Overnight Shifts and Overtime

How to Build a Timesheet in Google Sheets That Handles Overnight Shifts and Overtime

Comments
3 min read
每周 15 分钟:三张表维护清单,月初记的账月底不用返工

每周 15 分钟:三张表维护清单,月初记的账月底不用返工

Comments
1 min read
The 8 Excel errors, explained: what #N/A, #VALUE! and #REF! actually mean

The 8 Excel errors, explained: what #N/A, #VALUE! and #REF! actually mean

Comments 1
3 min read
How does Goal Seek find a break-even point?

How does Goal Seek find a break-even point?

Comments
6 min read
How to find your break-even point with Goal Seek in a spreadsheet

How to find your break-even point with Goal Seek in a spreadsheet

Comments
3 min read
How to forecast next December's sales in a spreadsheet

How to forecast next December's sales in a spreadsheet

Comments
4 min read
How to remove duplicate customers from a spreadsheet by email address

How to remove duplicate customers from a spreadsheet by email address

Comments
3 min read
How to Clean a Messy Stripe / Shopify / Gumroad CSV Before Google Sheets (or Make)

How to Clean a Messy Stripe / Shopify / Gumroad CSV Before Google Sheets (or Make)

Comments
4 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
Track online orders and shipments in Excel: ship-by dates, status and profit per order

Track online orders and shipments in Excel: ship-by dates, status and profit per order

Comments
3 min read
Google Sheets vs a Real Dashboard: When It Is Time to Graduate

Google Sheets vs a Real Dashboard: When It Is Time to Graduate

Comments
3 min read
How to Build a Purchase Order in Google Sheets With the Discount, Tax and Shipping in the Right Order

How to Build a Purchase Order in Google Sheets With the Discount, Tax and Shipping in the Right Order

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