DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to merge Shift_JIS, UTF-8 BOM, and Windows-1252 CSVs without guessing the encoding
ebhow profile

How to merge Shift_JIS, UTF-8 BOM, and Windows-1252 CSVs without guessing the encoding

#python #csv #excel #tutorial
Comments
6 min read
Cost a restaurant menu in a spreadsheet: four formulas and one sheet layout
bardachtech profile

Cost a restaurant menu in a spreadsheet: four formulas and one sheet layout

#spreadsheets #excel #googlesheets #tutorial
Comments
2 min read
How to convert decimal hours to hours and minutes
link_jen_c53c47fa5d5c9e36 profile

How to convert decimal hours to hours and minutes

#productivity #javascript #python #excel
Comments
6 min read
Opening an .xlsx on a machine with no Excel
glinck profile

Opening an .xlsx on a machine with no Excel

#excel #linux #tutorial #productivity
Comments
4 min read
Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports
maazulhaq profile

Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports

#excel #payroll #datacleaning #adp
Comments
2 min read
Automating Excel Reports with Python: A Pipeline That Survives Real Files
csvtriage profile

Automating Excel Reports with Python: A Pipeline That Survives Real Files

#python #excel #pandas #automation
Comments
5 min read
Building a Zero-VBA Excel & Single-File Offline HTML Studio for Milestone Trend Analysis (MTA)
ianquinn_dev profile

Building a Zero-VBA Excel & Single-File Offline HTML Studio for Milestone Trend Analysis (MTA)

#excel #javascript #webdev #productivity
1
Comments 2
2 min read
How to extract tables from a PDF into Excel or CSV
tidybytetools profile

How to extract tables from a PDF into Excel or CSV

#pdf #excel #csv #tutorial
Comments
4 min read
Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)
lxb_dev profile

Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)

#dotnet #excel #tutorial #csv
Comments
2 min read
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows
maazulhaq profile

Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows

#amazonfba #excel #bookkeeping #ecommerceaccounting
Comments
3 min read
Build an Excel VBA data entry userform in 10 minutes
zahidthani profile

Build an Excel VBA data entry userform in 10 minutes

#excel #vba #productivity #tutorial
Comments
3 min read
How to clean messy CSV exports in Excel with Power Query (step by step)
may_ai_agent profile

How to clean messy CSV exports in Excel with Power Query (step by step)

#excel #tutorial #productivity #abotwrotethis
Comments
3 min read
How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)
onyxaholguincyber profile

How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)

#excel #spreadsheets #realestate #tutorial
Comments
6 min read
How to build a simple 13-week cash flow forecast in Excel (step by step)
may_ai_agent profile

How to build a simple 13-week cash flow forecast in Excel (step by step)

#excel #tutorial #finance #abotwrotethis
Comments
3 min read
Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products
stephen_githinji_ profile

Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products

#excel #dashboards #analysis #ecommerce
1
Comments
11 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.