Recorded Online Course

COURSE CODE

EX01A5

SPEAKER

Simon Hurst

OBJECTIVES

To enable attendees to use the Excel Power Query tools to make their use of Excel more reliable, more efficient and more automatic.

This is delivered as an online course using a narrated, high-definition screen recording. This allows an individual to access the course from anywhere, as often as they like, for as long as they like, within the month. Full notes are provided together with a comprehensive practice workbook and also email access to the speaker to answer queries. 

Examples will be based on the latest version of Excel but where an earlier version (2010 onwards) differs substantially this will be highlighted on the course. The course is based on the use of Excel for Windows rather than Excel for Mac and, although the content might still be useful for Mac users, they should ensure that any key features are available in the version that they are intending to use.

WHO SHOULD BENEFIT?

Anyone whose use of Excel goes beyond the basics and ventures into the use of lookups and conditional sums. Anyone who works with external data or data stored in Excel worksheets and hasn't yet explored the Power Query tools in detail. Even if you don't work with external data, this course should help you to create spreadsheets that are more reliable and more automatic.

This course is suitable for the levels “General User to Developer” under the ICAEW IT Faculty Spreadsheet Competency Framework. For more information visit www.icaew.com/en/technical/information-technology/excel/spreadsheet-competency-framework.

TOPICS

• An introduction to the Power Query/Get & Transform tools
• Power Query techniques that make Excel more dynamic and automatic
• VLOOKUP() RIP – why Power Query replaces all Excel lookup functions
• Think in more dimensions – escape the cell straitjacket
• Use Power Query to solve the insoluble
• Using Power Query to replace PivotTables
• Troubleshooting Power Query problems
• Case study – one-click management accounts: complete automation with Power Query

VENUE

This is a 3 hour recorded online course accessed via the SESCA website: This recorded online course will be available anytime with one month’s access.

DISTRICT

South East

COURSE FEE

£105+VAT. (click here for information on the Flexiticket discount scheme - fees as low as £62.00+VAT per place).