Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
Excel for Business Analysts Series' Articles
Back to Michael Nocito's Series
Build a Dashboard in This Order: Correct, Then Clear, Then Compelling
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 17
Build a Dashboard in This Order: Correct, Then Clear, Then Compelling
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
10 min read
The Names Came In as Gibberish and Excel Said Nothing
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 19
The Names Came In as Gibberish and Excel Said Nothing
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Chart Design Basics: Take Things Away, Then Point
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 19
Chart Design Basics: Take Things Away, Then Point
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Check Your Work Before Anyone Else Does
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 19
Check Your Work Before Anyone Else Does
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
8 min read
The Dialog That Quietly Deletes Your Zip Codes
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 19
The Dialog That Quietly Deletes Your Zip Codes
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
The Finding That Was Just Your Own Definition
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 20
The Finding That Was Just Your Own Definition
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Show the Unit Without Breaking the Number
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 20
Show the Unit Without Breaking the Number
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Write the Sentence Your Dashboard Is Arguing
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 20
Write the Sentence Your Dashboard Is Arguing
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
One Row at a Time, or All Rows at Once
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 20
One Row at a Time, or All Rows at Once
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Four Numbers Across the Top Do More Than Four Charts
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 20
Four Numbers Across the Top Do More Than Four Charts
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Label Your Rows Before You Chart Them
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
Label Your Rows Before You Chart Them
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
8 min read
Name Your Data So Your Formulas Stop Breaking
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
Name Your Data So Your Formulas Stop Breaking
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
7 min read
Pick the Chart Your Number Already Decided
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
Pick the Chart Your Number Already Decided
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Percentages Are the Whole Story and Excel Hides Them
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
Percentages Are the Whole Story and Excel Hides Them
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
5 min read
A Pivot Table Is a Question, Not a Report
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
A Pivot Table Is a Question, Not a Report
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Make One Control Drive Every Chart on the Page
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
Make One Control Drive Every Chart on the Page
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
Sort Your Bar Chart or It Means Nothing
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
Sort Your Bar Chart or It Means Nothing
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
5 min read
Excel Just Summed Your ID Numbers and Said Nothing
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
Excel Just Summed Your ID Numbers and Said Nothing
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
6 min read
SUMIFS and COUNTIFS: Add Up Only the Rows That Match
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
SUMIFS and COUNTIFS: Add Up Only the Rows That Match
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
12 min read
VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 21
VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
13 min read
How to Connect Excel to a SQL Database (And Stop Pasting)
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 22
How to Connect Excel to a SQL Database (And Stop Pasting)
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
12 min read
How to Clean Messy Data in Excel: TRIM, CLEAN and the Space You Cannot See
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 22
How to Clean Messy Data in Excel: TRIM, CLEAN and the Space You Cannot See
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
14 min read
Conditional Formatting Based on Another Cell
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 23
Conditional Formatting Based on Another Cell
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
14 min read
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 23
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
14 min read
Excel Dates: Serial Numbers, Text That Looks Like a Date, and How to Fix It
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 23
Excel Dates: Serial Numbers, Text That Looks Like a Date, and How to Fix It
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
15 min read
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 23
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
14 min read
How to Use IFERROR in Excel, and What It Quietly Hides
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 24
How to Use IFERROR in Excel, and What It Quietly Hides
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
15 min read
Nested IF vs IFS in Excel: The Order That Silently Relabels Your Data
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 24
Nested IF vs IFS in Excel: The Order That Silently Relabels Your Data
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
14 min read
INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 24
INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
17 min read
Month-over-Month Growth in Excel, and the Month That Is Not There
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 25
Month-over-Month Growth in Excel, and the Month That Is Not There
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
13 min read
How to Make a Pivot Table, and Read the Answer It Gives You
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 25
How to Make a Pivot Table, and Read the Answer It Gives You
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
18 min read
Power Query for Beginners: The Steps That Run Again Next Month
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 25
Power Query for Beginners: The Steps That Run Again Next Month
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
15 min read
Remove Duplicates in Excel Without Losing Data
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 25
Remove Duplicates in Excel Without Losing Data
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
14 min read
SUMPRODUCT Explained: Multiply Down, Then Add
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 26
SUMPRODUCT Explained: Multiply Down, Then Add
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
13 min read
Excel Tables vs Ranges: What Ctrl+T Actually Changes
Michael Nocito
Michael Nocito
Michael Nocito
Follow
Aug 26
Excel Tables vs Ranges: What Ctrl+T Actually Changes
#
excel
#
dataanalysis
#
tutorial
#
beginners
Comments
Add Comment
14 min read
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account
