Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
excel
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook
ActvKey Official
ActvKey Official
ActvKey Official
Follow
Nov 19
Debugging Severe Excel Freezes, Memory Exhaustion, and Automating Large Dataset Calculations: A Systems Engineering Runbook
#
excel
#
performance
#
python
#
sysadmin
Comments
Add Comment
4 min read
Moderation
How to Move Columns in Excel Without Dragging
Chloe
Chloe
Chloe
Follow
Nov 19
How to Move Columns in Excel Without Dragging
#
productivity
#
csharp
#
excel
#
tutorial
2
 reactions
Comments
Add Comment
10 min read
Moderation
Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys
Adan Potyondy
Adan Potyondy
Adan Potyondy
Follow
Nov 18
Data-cleaning edge cases that break integrations: Excel serial dates, ERP negatives and match keys
#
dataengineering
#
etl
#
dataquality
#
excel
Comments
Add Comment
4 min read
Moderation
One semantic model, four tools: the same numbers and the same permissions
Sergei Semenkov
Sergei Semenkov
Sergei Semenkov
Follow
Nov 18
One semantic model, four tools: the same numbers and the same permissions
#
security
#
powerbi
#
excel
#
mcp
Comments
Add Comment
5 min read
Moderation
Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds
RickZhang
RickZhang
RickZhang
Follow
Nov 18
Material Shortage Calculation in Excel: 4 Silent Math Traps That Stall Small-Batch Hardware Builds
#
excel
#
manufacturing
#
supplychain
#
hardware
Comments
2
 comments
6 min read
Moderation
How to Ingest NetSuite Journal Entries into SQL Databases Cleanly
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 18
How to Ingest NetSuite Journal Entries into SQL Databases Cleanly
#
netsuite
#
sql
#
excel
#
dataengineering
Comments
Add Comment
3 min read
Moderation
Printing address labels for holiday cards from a spreadsheet
Label Peel
Label Peel
Label Peel
Follow
Nov 18
Printing address labels for holiday cards from a spreadsheet
#
spreadsheets
#
excel
#
printing
#
tutorial
Comments
Add Comment
4 min read
Moderation
Fix garbled Chinese, Japanese or emoji text (" ") in ExcelJS streaming WorkbookReader
Cyber Pusa
Cyber Pusa
Cyber Pusa
Follow
Nov 17
Fix garbled Chinese, Japanese or emoji text (" ") in ExcelJS streaming WorkbookReader
#
javascript
#
node
#
excel
#
exceljs
Comments
Add Comment
4 min read
Moderation
XLOOKUP vs VLOOKUP: switch for new files, keep the old ones
Daylongs
Daylongs
Daylongs
Follow
Nov 17
XLOOKUP vs VLOOKUP: switch for new files, keep the old ones
#
excel
#
xlookup
#
vlookup
#
spreadsheets
Comments
Add Comment
4 min read
Moderation
How to track Etsy sales and real profit in a spreadsheet
Zahid Thani
Zahid Thani
Zahid Thani
Follow
Nov 16
How to track Etsy sales and real profit in a spreadsheet
#
googlesheets
#
excel
#
ecommerce
#
tutorial
Comments
Add Comment
3 min read
Moderation
Getting a bank statement into a spreadsheet without losing a cent
Seller Tools
Seller Tools
Seller Tools
Follow
Nov 16
Getting a bank statement into a spreadsheet without losing a cent
#
python
#
excel
#
finance
#
productivity
1
 reaction
Comments
Add Comment
6 min read
Moderation
Why the Lowest Unit Price Costs $403 More: Auditing Supplier Quotes for MOQ, Reel Multiples, and MOV in Excel
RickZhang
RickZhang
RickZhang
Follow
Nov 17
Why the Lowest Unit Price Costs $403 More: Auditing Supplier Quotes for MOQ, Reel Multiples, and MOV in Excel
#
excel
#
hardware
#
procurement
#
supplychain
Comments
2
 comments
3 min read
Moderation
How to make a pivot table in Excel in five steps (no formulas)
Daylongs
Daylongs
Daylongs
Follow
Nov 16
How to make a pivot table in Excel in five steps (no formulas)
#
excel
#
spreadsheets
#
productivity
Comments
Add Comment
4 min read
Moderation
How to flag low-stock items in Excel with conditional formatting (no VBA)
thienkrik - small shop
thienkrik - small shop
thienkrik - small shop
Follow
Nov 15
How to flag low-stock items in Excel with conditional formatting (no VBA)
#
excel
#
tutorial
#
productivity
#
beginners
Comments
Add Comment
2 min read
Moderation
Consolidating Multi-Store Shopify CSV Exports Without Breaking Relational Order Data
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 15
Consolidating Multi-Store Shopify CSV Exports Without Breaking Relational Order Data
#
shopify
#
excel
#
datacleaning
#
ecommerce
Comments
Add Comment
3 min read
Moderation
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account