Dr. Seth Thomas is a PhD level physicist with an interest in all things scientific. With more than a decade of writing experience, he has a love of creating content that’s as fun to read as it is ...

Customer Counts Month over Month that can be extended to MRR and other SaaS calculations and Models. Far too many people seem to lack an understanding of array formulas or their usefulness in Excel ...

Hi there and welcome to my LinkedIn Blog Series where I find interesting Excel problems in the r/Excel subreddit, solve them, and explain the solution here in depth. Rather than trying to blog about ...

Imagine you’re tasked with analyzing two datasets—one containing a list of products and another with customer segments. How do you uncover every possible pairing to identify untapped opportunities?

Navigating the world of Excel can sometimes feel like trying to solve a puzzle with missing pieces. If you’ve ever found yourself wrestling with the XLOOKUP function, only to be met with a chaotic ...

Excel's randomization functions generate values, shuffle datasets, and simulate timelines using simple formulas.

From simple lists to dynamic spill ranges and cascading menus, Excel drop-downs offer flexible control over data entry.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. The recent article How to generate random letters in Excel shows you how to generate random letters.