Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Increase your productivity by automating data management and analysis. This course on Power Query is designed for CPAs who want to streamline their data processing workflows.
In this course, you will receive hands-on training with Power Query, focusing on automating data tasks. From cleaning and transforming financial data to automating the analysis of large datasets, the course covers practical, real-world applications for various use cases.
By the end of this course, you will have the skills to process and analyze financial data using Power Query, allowing you to automate workflows and shift your focus to high-value work.
Topics Include:
- Automate Routine Data Tasks
- Streamline Data Analysis
- Apply Practical Use Cases
Key Takeaways
Upon completion of this course, you will be able to:
- Automate data cleaning, transformation, and processing.
- Use Power Query to handle large datasets and perform complex analyses efficiently.
- Work with real-world financial examples to implement Power Query in your practice.
Who Will Benefit
This seminar benefits accountants and financial professionals looking to automate repetitive data management and analysis tasks. Participants should have intermediate excel proficiency to fully benefit from this course.
How to Access the Course
This course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
Electronic material can be accessed one week prior to the course and should be downloaded in advance.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Tomas Milo is a CPA and PhD candidate in Management (Accounting specialization) at McGill University, where he combines his accounting expertise with a strong interest in data science and empirical research. Previously, Tomas worked at KPMG in their Audit, Deal Advisory, and Data Science departments, where he developed his skills in analyzing financial data and automating accounting processes. He is the creator of XBRLInsights, a leading open financial data database that is used by researchers and practitioners alike.