Use MAP and LAMBDA to build centralized, error-proof, and auto-spilling Excel spreadsheet systems.

If you work with large spreadsheets, this one's for you.

THREE months after the Senate Blue Ribbon Committee started investigating “in aid of legislation” the massive corruption scandal involving the Department of Public Works and Highways (DPWH) flood ...

President Donald Trump signs an executive order barring transgender female athletes from competing in women's or girls' sporting events. (Alex Brandon/AP) Column by Sally Jenkins There is a reverse ...

Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

"VBA in Excel Applications" (Copyright 10178983) is a classic and is my seventh tutorial aimed at beginners, currently in its first revised edition. This tutorial ...

My brain is always going a million miles a minute about a thousand different things. Being a mom of three young kids, I’m also being pulled in three different directions, constantly. There’s never a ...

In an interview with Time magazine, President Trump explained how he approaches tariffs and trade negotiations. I use the word “explained” with some trepidation because explanations imply a certain ...

The 2024 Acura ZDX that took me to the airport last month was a little aggressive. The car changed lanes more often than I would have, looking for an opening in traffic, but who was I to complain? I ...