This site under reconstruction.
In my attempt to find what was new in Excel during 2024, I asked CoPilot to provide me what it knew was new. One feature was the linking a cell to a shape which was interesting to me and reminded me of the camera in Excel feature. This feature is not a well-known feature and…
I was working with someone who was trying to find a position in the fraud/money laundering detection industry. I gathered she kept encountering Excel requirements for her job, so she asked me for some help in learning Excel, specifically Excel functions and other tools. But isn’t there software that does the detection for the banks?…
No, I’m not talking about a particular person. I’m referencing the Federal Reserve Economic Data. This all came about when I heard something so mind boggling that I had to do some research. Basically, I saw something that said the US had added 51 million jobs since 1989 or since the fall of the Berlin…
A couple of weeks ago I was working with someone and she asked me to show her a way of splitting a column. The route she took wasn’t working. During the attempt to show her, I learned a new process. A very easy process. No formulas required. No tricks. Example Let’s use an easy example….
I’ve been wanting to explore the Monte Carlo simulations in Excel and I finally cracked open some books on the topic. I’ve probably been playing around with some examples since June or July and have seen a few techniques. My understanding of a Monte Carlo simulation is that a scenario, a setup, a model is…
The function XLOOKUP is a great improvement over VLOOKUP, but there is a surprising quirk about it. It boggles my mind and kind of leaves me unmoored. Background This whole exercise stems from a desire to learn about how Monte Carlo simulations could be set up, so I used a book that incorporated Excel with…
You must be logged in to post a comment.