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
How I cost a restaurant menu in a plain Excel sheet (formula walkthrough)
karim alfhar
karim alfhar
karim alfhar
Follow
Oct 9
How I cost a restaurant menu in a plain Excel sheet (formula walkthrough)
#
excel
#
productivity
#
food
#
tutorial
Comments
Add Comment
4 min read
Technical Guide: Automating SQL CREATE TABLE and INSERT Generation from Excel
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Oct 9
Technical Guide: Automating SQL CREATE TABLE and INSERT Generation from Excel
#
excel
#
sql
#
datasort
#
automation
Comments
Add Comment
6 min read
TBEG template syntax: repeat, merge, bundle, and hideable (Kotlin/Java)
Yongho Hwang
Yongho Hwang
Yongho Hwang
Follow
Oct 8
TBEG template syntax: repeat, merge, bundle, and hideable (Kotlin/Java)
#
java
#
kotlin
#
excel
#
tutorial
Comments
Add Comment
7 min read
Azure DevOps work items in Excel on a Mac: what works and what doesn’t
JR DevTools
JR DevTools
JR DevTools
Follow
Oct 7
Azure DevOps work items in Excel on a Mac: what works and what doesn’t
#
azuredevops
#
excel
#
macos
#
productivity
Comments
Add Comment
3 min read
How to combine multiple Excel files with different columns into one fixed report, and check the totals
Duaer Team
Duaer Team
Duaer Team
Follow
Oct 8
How to combine multiple Excel files with different columns into one fixed report, and check the totals
#
excel
#
spreadsheets
#
productivity
#
tutorial
Comments
Add Comment
9 min read
Excel & CSV ops for IT admins: cleaning Intune device exports without breaking your UPNs (Power Query basics + 9 pitfalls)
AdminPackStudio
AdminPackStudio
AdminPackStudio
Follow
Oct 7
Excel & CSV ops for IT admins: cleaning Intune device exports without breaking your UPNs (Power Query basics + 9 pitfalls)
#
excel
#
sysadmin
#
intune
#
powerquery
Comments
Add Comment
6 min read
Your first Excel report in 5 minutes - a TBEG quick start (Kotlin/Java)
Yongho Hwang
Yongho Hwang
Yongho Hwang
Follow
Oct 7
Your first Excel report in 5 minutes - a TBEG quick start (Kotlin/Java)
#
java
#
kotlin
#
excel
#
tutorial
Comments
Add Comment
4 min read
Stop writing Excel reports cell by cell - bind data to templates instead (Kotlin/Java)
Yongho Hwang
Yongho Hwang
Yongho Hwang
Follow
Oct 6
Stop writing Excel reports cell by cell - bind data to templates instead (Kotlin/Java)
#
java
#
kotlin
#
excel
#
springboot
Comments
Add Comment
6 min read
Is one client most of your income? Two SUMIFS formulas and a check row
Hexloom Labs
Hexloom Labs
Hexloom Labs
Follow
Oct 6
Is one client most of your income? Two SUMIFS formulas and a check row
#
freelance
#
excel
#
spreadsheet
#
productivity
Comments
Add Comment
2 min read
Is the spreadsheet warrior a dying breed?
Daniel Pank
Daniel Pank
Daniel Pank
Follow
for
Operelio
Oct 5
Is the spreadsheet warrior a dying breed?
#
excel
#
productivity
#
career
#
data
Comments
Add Comment
6 min read
Merge many Excel/CSV files into one sheet: Power Query steps and 3 gotchas
Junyoung Park
Junyoung Park
Junyoung Park
Follow
Oct 3
Merge many Excel/CSV files into one sheet: Power Query steps and 3 gotchas
#
excel
#
productivity
#
automation
#
python
Comments
Add Comment
2 min read
10 things Excel cannot do but VisiMark can
Michał Niedźwiedzki
Michał Niedźwiedzki
Michał Niedźwiedzki
Follow
Oct 2
10 things Excel cannot do but VisiMark can
#
excel
#
markdown
#
git
#
ci
Comments
Add Comment
3 min read
Building an Interactive Excel Dashboard for E-commerce Product Analysis
Ruto Kipkirui Robert
Ruto Kipkirui Robert
Ruto Kipkirui Robert
Follow
Oct 2
Building an Interactive Excel Dashboard for E-commerce Product Analysis
#
beginners
#
excel
#
analysis
Comments
Add Comment
3 min read
Jumia Product Data Analysis using Excel
Nidhi J Poojary
Nidhi J Poojary
Nidhi J Poojary
Follow
Oct 2
Jumia Product Data Analysis using Excel
#
beginners
#
dataanalysis
#
excel
Comments
Add Comment
1 min read
5 Excel chores worth automating with Python (and how to tell which ones aren't)
Junyoung Park
Junyoung Park
Junyoung Park
Follow
Oct 3
5 Excel chores worth automating with Python (and how to tell which ones aren't)
#
python
#
excel
#
automation
#
productivity
1
 reaction
Comments
Add Comment
2 min read
đź‘‹
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