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?

ChatGPT can assist with complex Excel formulas, including a VLOOKUP plus IFERROR to return not listed when no match appears.

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...

Replace confusing cell references with global constants, local variables, and reusable custom functions.

Most people are still using Excel like it’s 2010 with functions like INDEX MATCH, SUMIFS, or VLOOKUP. In this video, we’ll explore 5 NEW Excel functions that can replace numerous old ones, allowing ...

Q. How do I spill formulas in Excel? A. Spilling is a feature available in Excel 365 and later versions. With spilling, you can create a formula in one cell, and that formula will then spill over into ...

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...

One of the most useful new features that Microsoft has incorporated into Excel in recent years is the ability to incorporate Python code directly into a spreadsheet. While it has long been possible to ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

Imagine opening an Excel file expecting to see numbers, only to find that every cell displays formulas like =SUM(A1:A10), instead of the actual results. It can be confusing and frustrating, especially ...

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

Spreadsheets aren’t just for business owners and data analysts—here are some easy ways to integrate Microsoft Excel into your life. Microsoft Excel is part of the Excel is part of the Microsoft Office ...