Machine learning and deep learning have become an important part of many applications we use every day. There are few domains that the fast expansion of machine learning hasn’t touched. Many ...

Excel is incredibly powerful when your data is complete, but what happens when you need to solve for unknown variables? Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy ...

Fix Excel formulas that won’t spill! Learn how to troubleshoot #VALUE errors caused by Analysis ToolPak functions and improve your workflow.

Along with Visual Basic for Applications, the scripting language used in many business-oriented spreadsheets, Excel also lost Solver when it was upgraded to be included in Office 2008. Since Solver ...

Have you ever found yourself wrestling with Excel, wishing it could just do *that one thing* to make your work easier? Maybe you’ve spent hours manually replacing text, trying to filter data with ...

Q. I have an Excel spreadsheet where I need to enter the ticker symbol ACN for Accenture. Excel keeps changing ACN to CAN. What can I do? A. Most of us are familiar with how helpful autocorrect can be ...

Can AI be used to intelligently rank expertise? Serial entrepreneur Peter Relan thinks it can, and has today launched what he’s billing as a “knowledge-as-service” (KaaS) web platform to connect ...

In the August 2013 JofA, I challenged readers to solve an Excel problem in which a preformatted report fetched an ever-changing last row of data. We received well over 200 solutions from a group of ...