This site under reconstruction.
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?…
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…
You must be logged in to post a comment.