This site under reconstruction.
I don’t think I have ever seen anybody talk about this, but did you know you can separate the tab with the pivot table from the file with the source data? Literally, separate the tab with the pivot table from the file that contains the source table of data that pivot table pulls from. Doing…
In my last post I showed some charts, some pulled from FRED and others from a Microsoft function called STOCKHISTORY. I am going to write about STOCKHISTORY because it is a new function and somewhat interesting. You can use STOCKHISTORY to pull historical data for a stock or for an index such as Dow Jones…
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…