Vincent is a French registered chartered accountant and auditor. He has been advising SMEs for more than 12 years and is specialized in optimizing information system and data management.
Invested in Excel, VBA and SQL, he naturally transitioned to Power BI and Power Query for reporting purposes and data management. Using these “power” tools enabled him to develop new techniques to handle data.
He is certified DA-100 (data analyst) from Microsoft and has also written articles about Excel and Power BI and co-hosted a webinar about Power BI for financial and accounting functions.
He is part of a French association “Finance Audit Gestion” (FAG) uniting accountants, auditors, finance departments and business controllers around Power BI.
Power Query for Powerful Financial Reporting: From Accounting entries to Consolidated Reporting
In today’s world, creating a reporting is sometime stressful and time-consuming with multiple manual actions.
Whether you are an accountant, an auditor, a financial department or a business controller, you may be juggling between Excel sheets and other files.
This session will explain how you can profit from Power Query (in Excel and Power BI) through a use case showing how you can automate the restructuring of your accounting source (from an exported general ledger) and the mapping of your reporting through a unified process.
During this hour, learn how to use the most common Power Query functions to produce more efficient and reliable reporting.
Excel Virtually Global is an independent conference and is neither sponsored nor approved by Microsoft.