This site under reconstruction.
Not this week, but last week, I went to an Excel webinar where the presenter showed a very simple way of doing sensitivity analysis without data tables. The technique utilized the newest functions and array capabilities that Excel now brings. I’ve used one of the functions but only in a straightforward way and did not…
In the last post, I showed you how to bring in data from PDFs into Excel through Power Query. This post will detail some of the rudimentary power query capabilities to get you started. If you need to know how to access Power Query, just follow along the last post located here. Otherwise, continue reading…
Have you been keying in data from PDFs into your Excel spreadsheets? Did you know that Power Query and PDF work well together? Yes! You no longer have to key in data from PDFs. This helpful feature came on the scene maybe a few years ago but I was only reminded of this nifty feature…
I’ve been working on figuring out what was new in Excel in 2024 but using CoPilot. Using these generative AI to summarize what was new is a pretty nifty idea. One of the new things were templates to create random data. Now, Excel has a template that is a random data generator. Have you ever…
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?…
You must be logged in to post a comment.