The Magical N Function in Excel
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.
(more…)Last used column number in a row in Excel
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.
(more…)Excel Power Query and Multiple Files 2022
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. Download Materials https://vimeo.com/698458526
Removing Outliers in Excel
I wrote a blog post a while back about outliers and Excel and I thought I would revisit it thanks to dynamic arrays.
(more…)One Minute to Excel #25 – Find the breakeven point
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. https://vimeo.com/692114288
Capture an AutoCalculate Value in Excel
A recent update to Excel has made a slight change to the AutoCalculate feature. You can copy a value by simply clicking on it.
(more…)