Excel

  • |

    Using AI agents

    After asking my generative AI, in this instance ChatGPT, what was new in Excel for 2025, the top news was AI agents. At least that was my impression. I already knew about the Excel’s Agent Mode but I did not know about the Word or the PowerPoint version. The Microsoft 365 environment keeps changing so…

  • Using Dynamic Range

    I’ve been working on this project that enabled me to use quite a few interesting functions and approaches: hyperlinks, EDATE, Agent Mode. And now dynamic range. Dynamic ranges are ranges that grow and shrink depending on the situation. Here are some visual examples of what I mean: Pay attention to the section outlined in red….

  • EDATE: a quirk of the dates

    It’s the day before Thanksgiving and I thought I would do a post before doing some feasting. I’m continuing on writing about some “findings” that I encountered while working on a project. This time it is about the function EDATE and its curious quirk. But it does make sense for the quirk. Little background First,…

  • Hyperlinks: subtle oddities

    I’ve been working on a project which I thought I would explain some nuances about parts of Excel that I learned while doing this project. Today’s post will be on hyperlinks. So far that I know, there are kinds of hyperlinks: 1) one where you apply links via the Insert tab in the menu bar…