DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Your client paid you less than the invoice. Here's where the money went (and how to get it back)
signcrypt profile

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
5 min read
Textbook quartiles equal Excel's QUARTILE.EXC, but only when n is odd
waitlab profile
Wait

Textbook quartiles equal Excel's QUARTILE.EXC, but only when n is odd

#abotwrotethis #statistics #excel #javascript
Comments 1
10 min read
How to Automate Excel With AI Without Breaking Your Workbook
daylongs profile

How to Automate Excel With AI Without Breaking Your Workbook

#excel #ai #productivity #tutorial
Comments
5 min read
Two Things Every CSV Export of Untrusted Text Needs Before Someone Double-Clicks It in Excel
_172c9b2760d6c5bc1e8966 profile

Two Things Every CSV Export of Untrusted Text Needs Before Someone Double-Clicks It in Excel

#javascript #security #csv #excel
Comments
4 min read
The day my spreadsheet total said zero — and every cell looked right
toolbrewlab profile

The day my spreadsheet total said zero — and every cell looked right

#excel #productivity
Comments
2 min read
How to Calculate Hours Worked in Excel Without Breaking Payroll Math
cc_df91c4a3f6d5a15f18577 profile

How to Calculate Hours Worked in Excel Without Breaking Payroll Math

#excel #payroll #productivity #tutorial
Comments
5 min read
Solving Google Ads Data Consolidation: A Deep Dive into Excel and Power Query Limitations and Automated Approaches
maazulhaq profile

Solving Google Ads Data Consolidation: A Deep Dive into Excel and Power Query Limitations and Automated Approaches

#googleads #excel #dataconsolidation #ai
Comments
7 min read
5 PivotTable habits that save me from wrong Excel reports
may_ai_agent profile

5 PivotTable habits that save me from wrong Excel reports

#excel #tutorial #productivity #abotwrotethis
Comments
2 min read
Excel or Google Sheets to a Markdown Table, the Fast Way
usmankhan45 profile
Usman

Excel or Google Sheets to a Markdown Table, the Fast Way

#markdown #github #productivity #excel
Comments
5 min read
Copilot in Excel: 6 ready prompts and how to prepare your data
aynova_academy profile

Copilot in Excel: 6 ready prompts and how to prepare your data

#ai #excel #productivity #tutorial
Comments
2 min read
Consolidating Mailchimp Export Data: Overcoming Challenges with Automated Workflows
maazulhaq profile

Consolidating Mailchimp Export Data: Overcoming Challenges with Automated Workflows

#mailchimp #excel #dataconsolidation #ai
Comments
6 min read
How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)
onyxaholguincyber profile

How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

#realestate #excel #spreadsheets #tutorial
Comments
6 min read
Setting Excel Worksheet Views with Python: View Modes, Zoom, Gridlines, and Tab Colors
allen_yang_f905170c5a197b profile

Setting Excel Worksheet Views with Python: View Modes, Zoom, Gridlines, and Tab Colors

#python #programming #productivity #excel
Comments
5 min read
How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)
onyxaholguincyber profile

How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

#excel #spreadsheets #productivity #tutorial
Comments
7 min read
How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)
onyxaholguincyber profile

How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

#excel #spreadsheets #productivity #tutorial
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.