close

DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column
michaelnocito profile

INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column

#excel #dataanalysis #tutorial #beginners
Comments
17 min read
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula
michaelnocito profile

Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula

#excel #dataanalysis #tutorial #beginners
Comments
14 min read
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them
michaelnocito profile

Excel Drop Down Lists and Data Validation, and the Paste That Removes Them

#excel #dataanalysis #tutorial #beginners
Comments
14 min read
How to Connect Excel to a SQL Database (And Stop Pasting)
michaelnocito profile

How to Connect Excel to a SQL Database (And Stop Pasting)

#excel #dataanalysis #tutorial #beginners
Comments
12 min read
Excel Just Summed Your ID Numbers and Said Nothing
michaelnocito profile

Excel Just Summed Your ID Numbers and Said Nothing

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
openpyxl writes formulas. It never evaluates them — so your generated spreadsheet can be silently wrong.
atlasventuresgroup profile
atlas

openpyxl writes formulas. It never evaluates them — so your generated spreadsheet can be silently wrong.

#python #testing #excel
Comments
4 min read
One Row at a Time, or All Rows at Once
michaelnocito profile

One Row at a Time, or All Rows at Once

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
Show the Unit Without Breaking the Number
michaelnocito profile

Show the Unit Without Breaking the Number

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
Four Numbers Across the Top Do More Than Four Charts
michaelnocito profile

Four Numbers Across the Top Do More Than Four Charts

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
The Finding That Was Just Your Own Definition
michaelnocito profile

The Finding That Was Just Your Own Definition

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
Advanced Techniques for Merging Disparate Excel Sheets from Multiple Files
maazulhaq profile

Advanced Techniques for Merging Disparate Excel Sheets from Multiple Files

#excel #dataconsolidation #datamerging #powerquery
Comments
6 min read
The Names Came In as Gibberish and Excel Said Nothing
michaelnocito profile

The Names Came In as Gibberish and Excel Said Nothing

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
Chart Design Basics: Take Things Away, Then Point
michaelnocito profile

Chart Design Basics: Take Things Away, Then Point

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
The Dialog That Quietly Deletes Your Zip Codes
michaelnocito profile

The Dialog That Quietly Deletes Your Zip Codes

#excel #dataanalysis #tutorial #beginners
Comments
6 min read
Writing a million-row .xlsx from Dart without running out of memory
yusufihsangorgel profile

Writing a million-row .xlsx from Dart without running out of memory

#dart #excel #ffi #backend
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.