DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Building a printable invoice from a table in Excel and Google Sheets (no FILTER, no macros)
blackspectre512 profile

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

#excel #spreadsheet #freelance #productivity
Comments
2 min read
Turning a weekly meal plan into an aisle-sorted grocery list with plain spreadsheet formulas
blackspectre512 profile

Turning a weekly meal plan into an aisle-sorted grocery list with plain spreadsheet formulas

#excel #spreadsheets #productivity #tutorial
Comments
3 min read
Track online orders and shipments in Excel: ship-by dates, status and profit per order
ashishexcelnotes profile

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

#excel #ecommerce #orders #spreadsheet
Comments
3 min read
Paste Messy Text into Excel as a Real Table, Using ChatGPT as the Parser
hodadak_official profile

Paste Messy Text into Excel as a Real Table, Using ChatGPT as the Parser

#chatgpt #excel #productivity #beginners
Comments
2 min read
Translate a Japanese Excel File to English Without Breaking Formulas: TRANSLATE() vs a Small Python Round-Trip
crypteasensei profile

Translate a Japanese Excel File to English Without Breaking Formulas: TRANSLATE() vs a Small Python Round-Trip

#excel #python #i18n #abotwrotethis
Comments
6 min read
A 10-minute monthly budget ritual that doesn't die by month three
ljery profile

A 10-minute monthly budget ritual that doesn't die by month three

#personalfinance #productivity #excel
Comments
2 min read
How to delete EVERY copy of a duplicate line (not just the extras)
sujalkhatri profile

How to delete EVERY copy of a duplicate line (not just the extras)

#excel #productivity #tutorial #csv
Comments
2 min read
How to Compare Standard Mileage vs Actual Car Expenses in Excel or Google Sheets (2026, Tested)
onyxaholguincyber profile

How to Compare Standard Mileage vs Actual Car Expenses in Excel or Google Sheets (2026, Tested)

#excel #spreadsheets #productivity #tutorial
Comments
6 min read
Set Text Wrapping, Indentation, and AutoFit in Excel Using Python
allen_yang_f905170c5a197b profile

Set Text Wrapping, Indentation, and AutoFit in Excel Using Python

#python #programming #productivity #excel
Comments
5 min read
How to Build a Black Friday Deal Tracker in Excel or Google Sheets (Check the Real Discount, Tested)
onyxaholguincyber profile

How to Build a Black Friday Deal Tracker in Excel or Google Sheets (Check the Real Discount, Tested)

#excel #spreadsheets #productivity #tutorial
Comments
5 min read
Create Groups and Outlines in Excel Using Python
allen_yang_f905170c5a197b profile

Create Groups and Outlines in Excel Using Python

#python #programming #productivity #excel
Comments
5 min read
Five SUMIF patterns that run my household expense tracker
ljery profile

Five SUMIF patterns that run my household expense tracker

#productivity #excel #spreadsheets
Comments
2 min read
How to Build a Debt Payoff Calculator in Excel or Google Sheets (NPER, FV and PMT, Tested)
onyxaholguincyber profile

How to Build a Debt Payoff Calculator in Excel or Google Sheets (NPER, FV and PMT, Tested)

#excel #spreadsheets #productivity #tutorial
Comments
7 min read
The debt snowball, in spreadsheet formulas
ljery profile

The debt snowball, in spreadsheet formulas

#excel #personalfinance #productivity
Comments
2 min read
GST invoice format in Excel: a simple layout with automatic CGST/SGST or IGST
ashishexcelnotes profile

GST invoice format in Excel: a simple layout with automatic CGST/SGST or IGST

#excel #smallbusiness #tutorial #productivity
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.