One reason I like the N function is because it is Excel’s shortest function name. But it has quite a few useful features as well.
A while back I posted a formula to find the row number of the last used cell in a column. I revisit the solution to provide the last used column number in a row.
This is the recording of the second free Power Query webinar I ran in 2022.
You can watch the first one at this link.
In this session we see how to import multiple files in one Power Query. We look at importing CSV and Excel files.
You can download the materials, including a detailed pdf manual using the button below.
I wrote a blog post a while back about outliers and Excel and I thought I would revisit it thanks to dynamic arrays.
If we have a simple Profit and Loss and we want to figure out a breakeven point, we can use Goal Seek to find it.
We can also use it to see sales required to meet a certain profit.
All in less than in minute.
A recent update to Excel has made a slight change to the AutoCalculate feature. You can copy a value by simply clicking on it.