ICAEW.com works better with JavaScript enabled.

Excel webinars

Recordings of Excel Community webinars.

Super charge your PivotTables with Power Pivot

This is exclusive item - please log in or subscribe to view this item.

Power Pivot is freely available in Excel, but is often overlooked. But the powerful add-in can supercharge your PivotTables, allowing more nuanced and detailed calculations and summaries than ever before.

Excel Tip of the Week Live #7

Discover useful Excel hints and tips so you can use Excel more efficiently and effectively with our Excel expert David Lyford-Smith.

The comprehensive guide to PivotTables

This is exclusive item - please log in or subscribe to view this item.

One of the most enduringly popular data analysis features in Excel, PivotTables are an essential ingredient in any accountant’s data analysis toolbelt.

Power BI presentation features

This is exclusive item - please log in or subscribe to view this item.

Power BI Desktop is a free application that can turn financial data into animated and interactive visualisations.

Introduction to Power Query

This is exclusive item - please log in or subscribe to view this item.

David Lyford-Smith returns to Excel’s powerful automation and data cleaning tool, Power Query.

Extracting accounting systems data in Excel

This is exclusive item - please log in or subscribe to view this item.

Providing a step-by-step guide demonstrating how to methodically transform any automatically generated report extract into usable data.

Experimental Excel - look, no formulae

This is exclusive item - please log in or subscribe to view this item.

The introduction of the Power Query tools to Excel in Excel 2010 made it possible to fully automate a range of spreadsheet processes.

Showing 10 of 38 items