MUO on MSN

This tiny symbol in Excel changes everything (and most people ignore it)

The @ symbol can also appear in regular formulas outside of tables when Excel thinks you're trying to reference a single value from a range. If you see it pop up unexpectedly, it usually means Excel ...
MUO on MSN

Learning REDUCE in Excel completely changed how I use spreadsheets

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a ...

8 Excel Features That Quickly Improve Your Work : Flash Fill, Paste Special & the Magic F4 Key

Learn Paste Special math, Flash Fill patterns, Go To Special filters, and the F4 shortcut to clean data fast and share Excel ...

This battery analyzer I discovered is a power users' dream - how it stands out

The VX2 Pro is a two-slot battery charger that can take a wide variety of cell types and sizes. You can pop in AA, AAA, C, D, 18650, 21700, and more, and the unit will automatically detect the battery ...

This Simple Excel Trick Makes Dynamic Filters Update Themselves in Seconds

Learn how DROP, REDUCE, LAMBDA, and STACK make Excel arrays update automatically, split text, and stack filtered results ...