A new logic function has been added to Excel 2019. Learn how to use the IF function to build decision-making into your spreadsheets.
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.
PivotTables are one of Excel's most powerful features. They have the ability to summarise huge data sets into a table-based report with a few mouse clicks.
The Format as Table icon on the Home ribbon tab was added in Excel 2007. Unfortunately, most people think it is a formatting feature. Rather, it is a database option. By using the Format as Table icon you instruct Excel to treat a table like a basic database.
Power Query is an underutilised Excel tool. Here are a few user interaction tips to add flexibility to your queries.
A variance chart plots both monthly and year-to-date variances for two metrics over time. Here's how to create a variance chart in Excel.
Excel is known for the power of its numeric calculations, but it can also perform calculations based on dates and times.