ICAEW.com works better with JavaScript enabled.

Excel webinars

Recordings of Excel Community webinars.

Power BI Desktop - turn data into action

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

Almost exactly two years ago, Rishi Sapra presented an excellent introduction to Power BI and its capabilities. Since then, Microsoft has continued to update Power BI with significant updates arriving monthly. This webinar will focus on the free version of Power BI, Power BI Desktop, and cover the different components of Power BI Desktop using a practical example to take you from raw data to interactive report.

VLOOKUP

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

A quick introduction to the ubiquitous lookup-and-reference function, VLOOKUP – useful for everything from filling employee details from a master database to looking up prior year balances.

INDEX MATCH

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

The combination function INDEX MATCH is the most powerful, reliable, and flexible solution for any lookup-and-reference problem.

PivotTables

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

A starter kit for the most powerful data analysis and presentation tool in Excel, the PivotTable.

Showing 10 of 30 items