Spreadsheet - DEV Community

Skip to content

DEV Community

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

Black

Oct 25

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

#excel #spreadsheet #freelance #productivity

2 min read

Ashish Srivastava

Oct 25

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

#excel #ecommerce #orders #spreadsheet

3 min read

Linac

Oct 24

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

#analytics #spreadsheet #businessintelligence #dataviz

3 min read

Ashish Srivastava

Oct 20

How CGST/SGST vs IGST logic works in an Excel invoice template (with formulas)

#excel #spreadsheet #tutorial #productivity

3 min read

Oct 16

The Status Column Trap: Why Your Tracker Has 12 Statuses and Nobody Updates It

#spreadsheet #productivity #googlesheets #xlsx

4 min read

Oct 16

One Sheet vs Linked Sheets: When to Break Up a Solo-Operator Template

#spreadsheet #productivity #googlesheets #xlsx

4 min read

Oct 16

Freeze the Schema: A Rule That Stops Shared Spreadsheet Templates From Rotting

#spreadsheet #productivity #xlsx #tutorial

4 min read

Oct 15

Design a Template People Can Fill in Under 5 Minutes

#spreadsheet #productivity #templates #ux

5 min read

GreenFlux

Oct 16

Classify spreadsheet rows with Jev, and know which answers to trust

#jev #ai #spreadsheet #javascript

1 min read

Oct 14

Excel vs Google Sheets vs Notion: How I Pick a Template Format (Without Overthinking It)

#spreadsheet #productivity #msexcel #notetaking

3 min read

Oct 15

The Week-2 Death of Spreadsheet Templates (And a Checklist That Keeps Yours Alive)

#spreadsheet #productivity #excel #googlesheets

5 min read

Ashish Srivastava

Oct 21

How to Build a Monthly Sales Summary with SUMIFS (No Pivot Table)

#excel #spreadsheet #productivity #tutorial

3 min read

Ashish Srivastava

Oct 21

How to Catch Duplicate Orders and Misspelled Customer Names in a Spreadsheet

#excel #spreadsheet #productivity #tutorial

3 min read

Oct 16

Etsy profit per order: a worked example and the formula (after fees, shipping and product cost)

#ecommerce #etsy #spreadsheet #finance

2 min read

MonkeyRun

Sep 30

Counting the formulas in my own $5 spreadsheet: 51 of them, and not one is a GPA

#spreadsheet

7 min read

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