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
Opening an .xlsx on a machine with no Excel
Anuj Kabra
Anuj Kabra
Anuj Kabra
Follow
Nov 11
Opening an .xlsx on a machine with no Excel
#
excel
#
linux
#
tutorial
#
productivity
Comments
Add Comment
4 min read
Moderation
Automating Excel Reports with Python: A Pipeline That Survives Real Files
Lv Shao Mu
Lv Shao Mu
Lv Shao Mu
Follow
Nov 11
Automating Excel Reports with Python: A Pipeline That Survives Real Files
#
python
#
excel
#
pandas
#
automation
Comments
Add Comment
5 min read
Moderation
How to extract tables from a PDF into Excel or CSV
Tidy Byte Tools
Tidy Byte Tools
Tidy Byte Tools
Follow
Nov 11
How to extract tables from a PDF into Excel or CSV
#
pdf
#
excel
#
csv
#
tutorial
Comments
Add Comment
4 min read
Moderation
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 10
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows
#
amazonfba
#
excel
#
bookkeeping
#
ecommerceaccounting
Comments
Add Comment
3 min read
Moderation
Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)
lxb dev
lxb dev
lxb dev
Follow
Nov 10
Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)
#
dotnet
#
excel
#
tutorial
#
csv
Comments
Add Comment
2 min read
Moderation
Build an Excel VBA data entry userform in 10 minutes
Zahid Thani
Zahid Thani
Zahid Thani
Follow
Nov 10
Build an Excel VBA data entry userform in 10 minutes
#
excel
#
vba
#
productivity
#
tutorial
Comments
Add Comment
3 min read
Moderation
How to clean messy CSV exports in Excel with Power Query (step by step)
MayAI Cindy
MayAI Cindy
MayAI Cindy
Follow
Nov 10
How to clean messy CSV exports in Excel with Power Query (step by step)
#
excel
#
tutorial
#
productivity
#
abotwrotethis
Comments
Add Comment
3 min read
Moderation
How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)
Sheet & Flow
Sheet & Flow
Sheet & Flow
Follow
Nov 9
How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)
#
excel
#
spreadsheets
#
realestate
#
tutorial
Comments
Add Comment
6 min read
Moderation
How to build a simple 13-week cash flow forecast in Excel (step by step)
MayAI Cindy
MayAI Cindy
MayAI Cindy
Follow
Nov 9
How to build a simple 13-week cash flow forecast in Excel (step by step)
#
excel
#
tutorial
#
finance
#
abotwrotethis
Comments
Add Comment
3 min read
Moderation
Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products
Stephen Githinji
Stephen Githinji
Stephen Githinji
Follow
Nov 10
Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products
#
excel
#
dashboards
#
analysis
#
ecommerce
1
 reaction
Comments
Add Comment
11 min read
Moderation
How to find your break-even point with Goal Seek in a spreadsheet
Hanako H.
Hanako H.
Hanako H.
Follow
Nov 9
How to find your break-even point with Goal Seek in a spreadsheet
#
spreadsheet
#
excel
#
productivity
#
business
Comments
Add Comment
3 min read
Moderation
Come funziona la stampa unione, spiegata con una trentina di righe di Python
Hanako H.
Hanako H.
Hanako H.
Follow
for
Best AI Tools in italiano
Nov 8
Come funziona la stampa unione, spiegata con una trentina di righe di Python
#
python
#
docx
#
automazione
#
excel
Comments
Add Comment
4 min read
Moderation
Comment fonctionne le publipostage, expliqué en une trentaine de lignes de Python
Hanako H.
Hanako H.
Hanako H.
Follow
for
Best AI Tools en français
Nov 8
Comment fonctionne le publipostage, expliqué en une trentaine de lignes de Python
#
python
#
docx
#
automatisation
#
excel
Comments
Add Comment
4 min read
Moderation
How does mail merge work? Rebuilt in about 30 lines of Python
Hanako H.
Hanako H.
Hanako H.
Follow
Nov 8
How does mail merge work? Rebuilt in about 30 lines of Python
#
python
#
excel
#
automation
#
tutorial
Comments
Add Comment
4 min read
Moderation
Come rimuovere i duplicati da una lista clienti in Python quando nessuna riga è identica
Hanako H.
Hanako H.
Hanako H.
Follow
for
Best AI Tools in italiano
Nov 7
Come rimuovere i duplicati da una lista clienti in Python quando nessuna riga è identica
#
python
#
dati
#
pulizia
#
excel
Comments
Add Comment
5 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
⌂ 换网址