Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.

Over the past six months, we’ve learned how AI can be used for many tasks: creating art, powering a sophisticated chatbot, and so on. But what if you could use it to actually assist you in your job?

Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, but well-designed formulas or other tools like Power Query often handle ...

If Excel is not highlighting cells in the formula, read this post to know how to fix the issue. The default behavior of Excel is to highlight the cells that are part of a formula when a user ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

To lock cells in Microsoft Excel, follow the methods below. A Format Cells dialog box is open. In the dialog box, click the Protection tab. On the Protection tab page, check if the lock checkbox is ...

A quick keyboard shortcut puts you right into the Formula bar. You don't need the mouse at all! When entering formulas, you select a cell and start typing. To edit an existing formula, you probably ...