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
Adding and Customizing Sparklines in Excel Using Python
Allen Yang
Allen Yang
Allen Yang
Follow
Nov 6
Adding and Customizing Sparklines in Excel Using Python
#
python
#
productivity
#
programming
#
excel
Comments
Add Comment
6 min read
Moderation
Adding Trendlines and Regression Equations to Excel Charts Using Python
Allen Yang
Allen Yang
Allen Yang
Follow
Nov 6
Adding Trendlines and Regression Equations to Excel Charts Using Python
#
python
#
productivity
#
programming
#
excel
Comments
Add Comment
6 min read
Moderation
Why Converted PDF Tables Break in Excel and Word (And How to Fix '=SUM() = 0')
Vaibhav Srivastava
Vaibhav Srivastava
Vaibhav Srivastava
Follow
Nov 6
Why Converted PDF Tables Break in Excel and Word (And How to Fix '=SUM() = 0')
#
python
#
architecture
#
excel
#
productivity
Comments
Add Comment
4 min read
Moderation
Automating Excel Data Consolidation for Power BI and Tableau
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 6
Automating Excel Data Consolidation for Power BI and Tableau
#
excel
#
salesreporting
#
powerbi
#
tableau
Comments
Add Comment
6 min read
Moderation
Your client paid you less than the invoice. Here's where the money went (and how to get it back)
Aan Chen
Aan Chen
Aan Chen
Follow
Nov 5
Your client paid you less than the invoice. Here's where the money went (and how to get it back)
#
freelance
#
business
#
excel
#
productivity
Comments
Add Comment
5 min read
Moderation
How to remove duplicate customers from a spreadsheet by email address
Hanako H.
Hanako H.
Hanako H.
Follow
Nov 6
How to remove duplicate customers from a spreadsheet by email address
#
spreadsheet
#
excel
#
productivity
#
tutorial
Comments
Add Comment
3 min read
Moderation
Can You Guess What Happens During an Excel Import?
manjushaps
manjushaps
manjushaps
Follow
Nov 6
Can You Guess What Happens During an Excel Import?
#
rust
#
excel
#
webdev
#
beginners
Comments
Add Comment
1 min read
Moderation
Textbook quartiles equal Excel's QUARTILE.EXC, but only when n is odd
Wait
Wait
Wait
Follow
Nov 5
Textbook quartiles equal Excel's QUARTILE.EXC, but only when n is odd
#
abotwrotethis
#
statistics
#
excel
#
javascript
Comments
1
 comment
10 min read
Moderation
How to Automate Excel With AI Without Breaking Your Workbook
Daylongs
Daylongs
Daylongs
Follow
Nov 5
How to Automate Excel With AI Without Breaking Your Workbook
#
excel
#
ai
#
productivity
#
tutorial
Comments
Add Comment
5 min read
Moderation
The day my spreadsheet total said zero — and every cell looked right
ToolBrewLab
ToolBrewLab
ToolBrewLab
Follow
Nov 5
The day my spreadsheet total said zero — and every cell looked right
#
excel
#
productivity
Comments
Add Comment
2 min read
Moderation
How to Calculate Hours Worked in Excel Without Breaking Payroll Math
RainyChen
RainyChen
RainyChen
Follow
Nov 4
How to Calculate Hours Worked in Excel Without Breaking Payroll Math
#
excel
#
payroll
#
productivity
#
tutorial
Comments
Add Comment
5 min read
Moderation
Solving Google Ads Data Consolidation: A Deep Dive into Excel and Power Query Limitations and Automated Approaches
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 4
Solving Google Ads Data Consolidation: A Deep Dive into Excel and Power Query Limitations and Automated Approaches
#
googleads
#
excel
#
dataconsolidation
#
ai
Comments
Add Comment
7 min read
Moderation
5 PivotTable habits that save me from wrong Excel reports
MayAI Cindy
MayAI Cindy
MayAI Cindy
Follow
Nov 4
5 PivotTable habits that save me from wrong Excel reports
#
excel
#
tutorial
#
productivity
#
abotwrotethis
Comments
Add Comment
2 min read
Moderation
Excel or Google Sheets to a Markdown Table, the Fast Way
Usman
Usman
Usman
Follow
Nov 3
Excel or Google Sheets to a Markdown Table, the Fast Way
#
markdown
#
github
#
productivity
#
excel
Comments
Add Comment
5 min read
Moderation
Copilot in Excel: 6 ready prompts and how to prepare your data
AyNova-Academy
AyNova-Academy
AyNova-Academy
Follow
Nov 2
Copilot in Excel: 6 ready prompts and how to prepare your data
#
ai
#
excel
#
productivity
#
tutorial
Comments
Add Comment
2 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