View all the services available for students of the Institute
Study with us
View member services
Services to support your business
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.
This course will be delivered via Zoom. The Zoom link will be emailed to participants the day before the course is due to take place.
This course is aimed at experienced Excel users who have to:
This course has four main parts:
This course will operate with a mixture of instructor-delivery and practical exercises using a case-study approach. The emphasis will be on delivering practical techniques which can be used in everyday work, rather than on esoteric theory.
Participants will benefit from:
Professional Training is a group of experienced specialists providing focused training in IT and Management skills. Our trainers use a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation by our course participants. We have delivered a range of CPD programmes with Chartered Accountants Ireland since 1997. Website: www.professional.ie
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930.
This packed course tackles new Excel Functions like FILTER UNIQUE, SEQUENCE, SORT and SORTBY showing their effectiveness over traditional Functions. We explore writing Custom Functions (LAMBDA, BYCOL) and use important Pivot Table techniques (in-table calculations, multi-sheet generation and the new PIVOTBY and GROUPBY). All manifestations of Formatting and key specific areas of Charting and Effective Macro creation and editing are explored.
This course is designed for those who want to appraise and improve the way they utilise the features of MS Excel and MS PowerPoint to communicate effectively. It will challenge how we present information and explore how we can engage our audience and transfer technical and financial information clearly and simply.
Advances in AI coupled with modern features in PowerPoint greatly simplify creating eye-catching and informative presentations. Effective usage of Copilot or ChatGPT cuts the time and manual input required for presenting and reporting on data for regular meetings, ad-hoc assignments or regulatory requirements. This hands-on course will guide you through using AI Tools with Microsoft 365 to efficiently and professionally present information.