Skip to content
Microsoft Excel tips and tricks
Learn how to manage your all-important cash with these Excel spreadsheet skills.
The AI-powered tool lives up to its name by generating visualisation options from data.
Our Excel MVP unveils a fistful of functions that pack a real punch.
Working with a spreadsheet from a country where the date format differs from yours can cause real problems. Here’s how to solve them.
Avoid building a complicated formula in your model with a ‘step it out’ approach.
Though not yet generally available, the new function gets a rare syntax shakeup.
With a little algebra and a lot of flexibility, spreadsheet builders can set up a forecasting model that handles simultaneous changes in multiple parameters.
They aren’t yet generally available, but they look like an X-cellent matched set.
The winner of a global student competition offers simple tips for the average user to get the most out of Microsoft’s spreadsheet application.
When it comes to crafting the most effective spreadsheets, modellers are wise to remember that less can be more.
A formula-based approach can allow spreadsheet modellers to build a full financial time series from just three lines of data.
Spreadsheet modellers can use the MOD function to obtain residuals and handle calculations at regular time intervals.
Learn the spreadsheet skills necessary to determine pre-tax cost of equity and net present value for assets, businesses, and more.
Spreadsheet modellers should take care to remove unneeded mentions of the current worksheet name.
To speed up Excel workbooks, modellers should plan to keep the number of volatile functions and range names to a manageable minimum.
In celebration of CIMA’s 100th anniversary, this guide provides 100 ways to more effectively use technology such as Excel.
This spreadsheet technique accommodates cyclical, multiyear capital spending, allowing for an accurate year-to-year calculation of cash flows.
This spreadsheet technique could prove helpful when determining the value of an asset.
Accountants who build spreadsheet models can employ data validation techniques to improve accuracy and performance.
The Name Manager can make spreadsheets easier to follow, but Excel modellers must know how — and, more importantly, when — to properly use the tool.
