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 ...

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?

Brian Beers is a digital editor, writer, Emmy-nominated producer, and content expert with 15+ years of experience writing about corporate finance & accounting, fundamental analysis, and investing.

Excel spreadsheet databases work because users can filter the data inside these workbooks. Filters are conditions you specify in databases and spreadsheets to extract only the precise, requested ...

Doug Wintemute is a staff writer for Forbes Advisor. After completing his master’s in English at York University, he began his writing career in the higher education space. Over the past decade, Doug ...

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...