DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook

Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook

Comments
4 min read
How to Move Columns in Excel Without Dragging

How to Move Columns in Excel Without Dragging

2
Comments
10 min read
Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys

Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys

Comments
4 min read
One semantic model, four tools: the same numbers and the same permissions

One semantic model, four tools: the same numbers and the same permissions

Comments
5 min read
Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds

Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds

Comments 2
6 min read
How to Ingest NetSuite Journal Entries into SQL Databases Cleanly

How to Ingest NetSuite Journal Entries into SQL Databases Cleanly

Comments
3 min read
Printing address labels for holiday cards from a spreadsheet

Printing address labels for holiday cards from a spreadsheet

Comments
4 min read
Fix garbled Chinese, Japanese or emoji text (" ") in ExcelJS streaming WorkbookReader

Fix garbled Chinese, Japanese or emoji text (" ") in ExcelJS streaming WorkbookReader

Comments
4 min read
XLOOKUP vs VLOOKUP: switch for new files, keep the old ones

XLOOKUP vs VLOOKUP: switch for new files, keep the old ones

Comments
4 min read
How to track Etsy sales and real profit in a spreadsheet

How to track Etsy sales and real profit in a spreadsheet

Comments
3 min read
Getting a bank statement into a spreadsheet without losing a cent

Getting a bank statement into a spreadsheet without losing a cent

1
Comments
6 min read
Why the Lowest Unit Price Costs $403 More: Auditing Supplier Quotes for MOQ, Reel Multiples, and MOV in Excel

Why the Lowest Unit Price Costs $403 More: Auditing Supplier Quotes for MOQ, Reel Multiples, and MOV in Excel

Comments 2
3 min read
How to make a pivot table in Excel in five steps (no formulas)

How to make a pivot table in Excel in five steps (no formulas)

Comments
4 min read
How to flag low-stock items in Excel with conditional formatting (no VBA)

How to flag low-stock items in Excel with conditional formatting (no VBA)

Comments
2 min read
Consolidating Multi-Store Shopify CSV Exports Without Breaking Relational Order Data

Consolidating Multi-Store Shopify CSV Exports Without Breaking Relational Order Data

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.