Sometimes when you’re building a formula the range that you select is further down the sheet than the formula cell. There is a keyboard shortcut that you can press to return to the formula cell. Shout out to Mike Girvin for sharing this tip in his latest book Excel the Only App that Matters.
Monthly Archives: March 2025
Observation is a dying art.
Stanley Kubrick
Modelling Home Loans in Excel
You may be aware that Excel can calculate loan repayments. But you may not know that it can also work out lots of different loan combinations based on two variables.
Tell me the facts and I’ll learn. Tell me the truth, and I’ll believe. But tell me a story and it will live with me forever.
Native American Proverb
Last Used Row Number in a Column
The recent TRIMRANGE function update to Excel makes it easier to determine the last used row in a column.
Action is the foundational key to all success.
Pablo Picasso
Extracting Data from the Web with Power Query
Power Query can import table-based data direct from the web. As an example, we can extract the public holiday dates for Western Australia from the WA government website. This process is sometimes called web scraping.
It is not enough to do your best; you must know what to do, then do your best.
W Edwards Deming