This site under reconstruction.
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…
I did something different. At least I think I did. One night, as I was perusing for the latest news, especially weather news, a YouTube video popped up in my feed about a new Excel function that could possibly replace Pivot Tables. Replace Pivot Tables ?!? Then, I realized I hadn’t been seeing any videos…
You must be logged in to post a comment.