Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula.

Microsoft recently added a new optical character recognition feature to Excel that lets users import data from a photograph taken from a smartphone. Here's how to use it. I first started using ...

Breakthroughs, discoveries, and DIY tips sent every weekday. Terms of Service and Privacy Policy. Listen, unless you’re an expert, spreadsheets can be daunting. You ...

REGEX is a smarter version of Excel's FIND function, which works well for basic lookups. However, REGEX handles more complex scenarios. For instance, if you need to pull phone numbers from messy text, ...

Tom Warren is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers.