How-To Geek on MSN

How to use the LAMBDA helper functions in Microsoft Excel

Replace legacy formulas with MAP, BYROW, BYCOL, SCAN, and REDUCE to build secure, scalable, and automated spreadsheets.
Geeky Gadgets

Stop Dragging in Excel : This Genius Function Will Change Your Life

Have you ever found yourself endlessly dragging that little Excel fill handle, trying to populate rows or columns with numbers, dates, or formulas? It’s tedious, time-consuming, and let’s be ...