The life-changing benefits of using Power Query when working with any form of external data might be obvious, but using Power Query is also a quicker, easier and more automatic way to handle a whole range of everyday Excel problems, even within a single workbook. This webinar will provide a brief introduction to how Power Query works before showing how you can use it to make many common Excel techniques and processes easier and more automatic. Amongst the problems that the webinar will address will be rounding, working with dates, dealing with duplicates, automating management reports and allocating transactions to different periods in a cash flow forecast.
Access to this webinar is included within membership of the Excel Community (which is also part of Tech Faculty membership), and to subscribers of Faculties Online. Excel Community membership gives you access to exclusive premium content including our webinars, eight suites of Excel online training, regular eBulletins and extensive online resources focused on technical and soft skills to support your career. For more information about Excel Community membership and our latest joining offers, please visit icaew.com/joinexcel. For more information about Faculties Online, please visit icaew.com/subscribefo.
Should you experience webinar difficulties, please click here
If you are an ICAEW Member or Student or have already created an Account please login below. Otherwise please create an Account.
This screen shows you the details for the selected product.
Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.
If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you. Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.
If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.
Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.