This course introduces two of the most powerful Excel 365 reporting and analysis tools - Power Query and Power Pivot, using them to produce an Excel Dashboard. We will examine Excel tools for 'What if' and newer techniques in the very important data analysis areas of LOOKUP (especially XLOOKUP) and FILTERING. Finally, we will use the Excel Dashboard we have created to communicate the results via exchanges between Excel and PowerPoint.                                                 

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources. This course provides a solid introduction to using Power BI Desktop to connect to data, create visualisations, query the data and publish reports.

Join the Practice Consulting Team as they focus on the latest key auditing issues for micro, small and medium sized companies in the UK & Ireland. How to ensure you continue to meet your Quality Management/ISQM requirements will also be a focus.

This course is designed to give Excel users a deeper knowledge of functions and formulas for a more effective way of reporting using charts, Pivot Tables and Data Tables.

This event offers a unique opportunity for women in the accountancy profession to connect, collaborate, and grow together. Through peer mentoring, participants will share experiences, gain fresh perspectives and receive valuable guidance on navigating their careers. This is not just an event—it’s a chance to build lasting relationships and expand your professional network in a supportive, empowering environment.