DEV Community

Excel for Business Analysts Series' Articles

Back to Michael Nocito's Series
How to Make a Pivot Table, and Read the Answer It Gives You
michaelnocito profile

How to Make a Pivot Table, and Read the Answer It Gives You

#excel #dataanalysis #tutorial #beginners
Comments
18 min read
Power Query for Beginners: The Steps That Run Again Next Month
michaelnocito profile

Power Query for Beginners: The Steps That Run Again Next Month

#excel #dataanalysis #tutorial #beginners
Comments
15 min read
Remove Duplicates in Excel Without Losing Data
michaelnocito profile

Remove Duplicates in Excel Without Losing Data

#excel #dataanalysis #tutorial #beginners
Comments
14 min read
SUMPRODUCT Explained: Multiply Down, Then Add
michaelnocito profile

SUMPRODUCT Explained: Multiply Down, Then Add

#excel #dataanalysis #tutorial #beginners
Comments
13 min read
Excel Tables vs Ranges: What Ctrl+T Actually Changes
michaelnocito profile

Excel Tables vs Ranges: What Ctrl+T Actually Changes

#excel #dataanalysis #tutorial #beginners
Comments
14 min read
Absolute vs Relative References in Excel: What the Dollar Sign Locks
michaelnocito profile

Absolute vs Relative References in Excel: What the Dollar Sign Locks

#excel #dataanalysis #tutorial #beginners
Comments
15 min read