DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How I cost a restaurant menu in a plain Excel sheet (formula walkthrough)

How I cost a restaurant menu in a plain Excel sheet (formula walkthrough)

Comments
4 min read
Technical Guide: Automating SQL CREATE TABLE and INSERT Generation from Excel

Technical Guide: Automating SQL CREATE TABLE and INSERT Generation from Excel

Comments
6 min read
TBEG template syntax: repeat, merge, bundle, and hideable (Kotlin/Java)

TBEG template syntax: repeat, merge, bundle, and hideable (Kotlin/Java)

Comments
7 min read
Azure DevOps work items in Excel on a Mac: what works and what doesn’t

Azure DevOps work items in Excel on a Mac: what works and what doesn’t

Comments
3 min read
How to combine multiple Excel files with different columns into one fixed report, and check the totals

How to combine multiple Excel files with different columns into one fixed report, and check the totals

Comments
9 min read
Excel & CSV ops for IT admins: cleaning Intune device exports without breaking your UPNs (Power Query basics + 9 pitfalls)

Excel & CSV ops for IT admins: cleaning Intune device exports without breaking your UPNs (Power Query basics + 9 pitfalls)

Comments
6 min read
Your first Excel report in 5 minutes - a TBEG quick start (Kotlin/Java)

Your first Excel report in 5 minutes - a TBEG quick start (Kotlin/Java)

Comments
4 min read
Stop writing Excel reports cell by cell - bind data to templates instead (Kotlin/Java)

Stop writing Excel reports cell by cell - bind data to templates instead (Kotlin/Java)

Comments
6 min read
Is one client most of your income? Two SUMIFS formulas and a check row

Is one client most of your income? Two SUMIFS formulas and a check row

Comments
2 min read
Is the spreadsheet warrior a dying breed?

Is the spreadsheet warrior a dying breed?

Comments
6 min read
Merge many Excel/CSV files into one sheet: Power Query steps and 3 gotchas

Merge many Excel/CSV files into one sheet: Power Query steps and 3 gotchas

Comments
2 min read
10 things Excel cannot do but VisiMark can

10 things Excel cannot do but VisiMark can

Comments
3 min read
Building an Interactive Excel Dashboard for E-commerce Product Analysis

Building an Interactive Excel Dashboard for E-commerce Product Analysis

Comments
3 min read
Jumia Product Data Analysis using Excel

Jumia Product Data Analysis using Excel

Comments
1 min read
5 Excel chores worth automating with Python (and how to tell which ones aren't)

5 Excel chores worth automating with Python (and how to tell which ones aren't)

1
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.