My Musings

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

  • |

    Random thoughts

    Today is going to be just sort of some random thoughts spilled out into this post. Nothing about new Excel tricks, amazing AI stuff, or enraging stuff from the hard-core capitalists, etc. I believe I said I would do a post outlining my thoughts about a project, but I am still cogitating over it (and…

  • 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…

  • I can’t hear you

    The topic is not dying down, although if I think about it, it appears to be coming from mostly on the Democrat side rather than the Republicans. It’s a rather sordid topic. I’m surprised at how long this topic has been going but I guess this is the one that the right, the conservatives, the…