Get the most out of Excel with these how-to articles, videos and sample 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.
Excel拥有极为强大的数据处理和报告功能，而随着这些功能的不断发展，Excel设置了大量的快捷键方便用户提高效率、节省时间。接下来，本文就将给大家介绍一些非常有用的Excel快捷键。
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.
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.