From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
Michael NocitoAug 22, 2026 • 12 min read
How to Connect Excel to a SQL Database (And Stop Pasting)
Connect Excel to SQL Server, Postgres, MySQL or SQLite with Power Query, so the monthly report refre...
#excel#dataanalysis#tutorial#beginners
0 0
Michael Nocito5d ago • 14 min read
Excel Tables vs Ranges: What Ctrl+T Actually Changes
One keystroke moves the edges of your data. Structured references, the calculated column that fills ...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 23, 2026 • 14 min read
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula
One formula, many cells. FILTER, UNIQUE, SORT and SORTBY worked on a real table, the spill reference...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 6 min read
Excel Just Summed Your ID Numbers and Said Nothing
Drop a column into a pivot's Values and Excel picks Sum for anything numeric, including ID codes. Th...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 23, 2026 • 14 min read
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them
Build a dropdown in four clicks, put the list somewhere it can grow, and know the gap: an ordinary p...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 24, 2026 • 17 min read
INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column
MATCH finds the position, INDEX fetches the value. Why that beats a hard-coded column number, with a...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 7 min read
Name Your Data So Your Formulas Stop Breaking
How to turn a range into an Excel Table with Ctrl+T and write structured references. Formulas read l...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 6 min read
Pick the Chart Your Number Already Decided
Comparing groups takes a bar, change over time takes a line, a relationship between two numbers take...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 6 min read
A Pivot Table Is a Question, Not a Report
The reframe that makes pivot tables click: Rows is what you group by, Values is what you count. Writ...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 5 min read
Percentages Are the Whole Story and Excel Hides Them
How to show percentages in an Excel pivot with Show Values As, and which of the three percent option...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 13 min read
VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch
VLOOKUP has three ways to hand you a wrong value without an error. Here is what each one looks like,...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 23, 2026 • 15 min read
Excel Dates: Serial Numbers, Text That Looks Like a Date, and How to Fix It
A date is the number 46027 wearing a format. How to tell a real date from text in two seconds, three...
#excel#dataanalysis#tutorial#beginners
0 0
Michael Nocito6d ago • 15 min read
Power Query for Beginners: The Steps That Run Again Next Month
Power Query records what you click and replays it on the next file. Getting data in, the Applied Ste...
#excel#dataanalysis#tutorial#beginners
0 0
Michael Nocito6d ago • 13 min read
Month-over-Month Growth in Excel, and the Month That Is Not There
Aggregate to one row per month, then divide. The calendar table that turns a gap into a zero, what t...
#excel#dataanalysis#tutorial#beginners
0 0
Michael Nocito6d ago • 14 min read
Remove Duplicates in Excel Without Losing Data
The columns you tick are the definition of duplicate, and the dialog deletes without telling you wha...
#excel#dataanalysis#tutorial#beginners
0 0
Michael Nocito6d ago • 18 min read
How to Make a Pivot Table, and Read the Answer It Gives You
Four clicks to a summary table, then the parts that decide whether it is right: what Rows and Values...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 23, 2026 • 14 min read
Conditional Formatting Based on Another Cell
One formula rule, one dollar sign, and a whole row lights up from a value in one column. Where the f...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 5 min read
Sort Your Bar Chart or It Means Nothing
An unsorted bar chart hands the ranking work to the reader. Sort descending and the chart answers at...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 24, 2026 • 15 min read
How to Use IFERROR in Excel, and What It Quietly Hides
IFERROR catches every error, not just the one you meant. The syntax, the choice between 0 and blank,...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 6 min read
Make One Control Drive Every Chart on the Page
How to add a slicer and connect it to every pivot with Report Connections: the moment a spreadsheet ...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 8 min read
Label Your Rows Before You Chart Them
How to add a category column in Excel with a nested IF, and why labelling beats filtering: a filter ...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 22, 2026 • 14 min read
How to Clean Messy Data in Excel: TRIM, CLEAN and the Space You Cannot See
Find the problem before you fix it with LEN and CODE, then TRIM, SUBSTITUTE and PROPER. Includes the...
#excel#dataanalysis#tutorial#beginners
0 0
Michael NocitoAug 21, 2026 • 12 min read
SUMIFS and COUNTIFS: Add Up Only the Rows That Match
How to sum only the rows that match your conditions, why SUMIF and SUMIFS put the sum range in oppos...
#excel#dataanalysis#tutorial#beginners
0 0
Michael Nocito5d ago • 13 min read
SUMPRODUCT Explained: Multiply Down, Then Add
Pair up two columns, multiply each pair, add the results. The weighted average it exists for, condit...
#excel#dataanalysis#tutorial#beginners
0 0