Get the most out of Excel with these how-to articles, videos and sample spreadsheets
Excel Power Query can save hours of time for people who have to take data from multiple sources and reorder it for reports and analysis.
When you record a macro in Excel, you create a repeatable set of commands in a language called Visual Basic for Applications (VBA). Here's how to add basic interaction to a recorded macro by using message boxes.
Neale Blackwood CPA began writing his monthly Excel Yourself column in 2002, before the articles and their popular accompanying videos were available online.
Conditional formatting in Excel enables you to apply a format to a cell or range of cells, so you can identify important information. The video tutorial below explains.
Excel expert Neale Blackwood began writing his monthly column in INTHEBLACK magazine in 2002, and recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions.
Excel is not only readily available at low cost on almost every laptop, but it contains much of the computing power needed for sophisticated forecasting, says expert Dr Liam Bastick. Learn how to get the most out of the Excel forecast functions.
There are a number of ways to create an interactive chart in Excel. The quickest and easiest way is to use a PivotChart.
Excel expert Neale Blackwood CPA began writing his monthly column in INTHEBLACK magazine in 2002, before the magazine was available online and without the popular accompanying videos.
Reporting dashboards are more popular than ever. Here's how to get the most ouf of Excel reporting dashboards.
Sometimes you need to allocate amounts to specific months; this technique shows how the LEN function works in Excel.
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.