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.
(more…)
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.
(more…)
The recent TRIMRANGE function update to Excel makes it easier to determine the last used row in a column.
(more…)
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.
(more…)