Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
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.
First broadcast on 22 June 2021