Get the most out of Excel with these how-to articles, videos and sample spreadsheets
Excel's MOD function can make your life easier when you are drawing up budgets and forecasts.
On a treasure map, X marks the spot. When it comes to mapping tables, Excel makes its mark and can provide treasure in the form of identifying new relationships and trends not apparent in separate datasets.
Is it possible to convert an existing budget into a forecast in Excel? Yes, and this tutorial will show you how.
A new logic function has been added to Excel 2019. Learn how to use the IF function to build decision-making into your spreadsheets.
Excel is way more than just spreadsheets. It can be used for data analysis and to transform numbers to graphics you can use in presentations. That makes it a valuable tool for your finance career. Here are nine handy demonstrations on how to use Excel better.
Using icons in Excel spreadsheets enhances your ability to get your message across. This step-by-step tutorial shows you how.
The slope chart is a popular way to compare past and present performance in Excel.
The INDIRECT function can update your carried forward balances in Excel automatically.
Liam Bastick is one of only 104 people in the world recognised as an Excel MVP. Ahead of his appearance at the World Congress of Accountants (WCOA), Bastick outlines how he uses Excel and a two-stage technique he has developed using “tornado” charts and sensitivity analysis.