Excel Yourself

Get the most out of Excel with these how-to articles, videos and sample spreadsheets

Hitting the slope charts in Excel


Excel's INDIRECT function is useful for carried forward balances

Understanding Excel's INDIRECT function


Who has spare time anymore! Do more with Excel with these handy Excel shortcuts.

超好用的Excel快捷键,你知道吗?


The tornado chart approach is based on the 80/20 rule focusing on drivers that stand out beyond the rest.

Modelling with tornado charts in Excel


Expand your Excel horizons by performing calculations within your PivotTable


Understanding Excel's misunderstood 'Format as Table' icon


Follow these tips to get more out of Excel's Power Query

How to harness power query in Excel


How to create a variance chart in Excel


Learn how Excel treats dates and times.

Calculating dates and times in Excel


Excel yourself: how to capture logic in a single row