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

Replace broken brackets in Excel with clear, flexible Power Query rules that handle real-world data effortlessly.

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.