DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Opening an .xlsx on a machine with no Excel

Opening an .xlsx on a machine with no Excel

Comments
4 min read
Automating Excel Reports with Python: A Pipeline That Survives Real Files

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

Comments
5 min read
How to extract tables from a PDF into Excel or CSV

How to extract tables from a PDF into Excel or CSV

Comments
4 min read
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows

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

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

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

Comments
2 min read
Build an Excel VBA data entry userform in 10 minutes

Build an Excel VBA data entry userform in 10 minutes

Comments
3 min read
How to clean messy CSV exports in Excel with Power Query (step by step)

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

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

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

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

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

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

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

1
Comments
11 min read
How to find your break-even point with Goal Seek in a spreadsheet

How to find your break-even point with Goal Seek in a spreadsheet

Comments
3 min read
Come funziona la stampa unione, spiegata con una trentina di righe di Python

Come funziona la stampa unione, spiegata con una trentina di righe di Python

Comments
4 min read
Comment fonctionne le publipostage, expliqué en une trentaine de lignes de Python

Comment fonctionne le publipostage, expliqué en une trentaine de lignes de Python

Comments
4 min read
How does mail merge work? Rebuilt in about 30 lines of Python

How does mail merge work? Rebuilt in about 30 lines of Python

Comments
4 min read
Come rimuovere i duplicati da una lista clienti in Python quando nessuna riga è identica

Come rimuovere i duplicati da una lista clienti in Python quando nessuna riga è identica

Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
⌂ 换网址