Managing Expense Reports with Power Query & Excel | Ken Puls - VanPUG Excel Edition-May 2023
SESSION OUTLINE:
Joseph Yeates will kick things off with showing us some of the latest updates and features to Power BI. Next, Ken Puls will present on managing expense reports using Excel and Power Query.
If you have ever been given a corporate visa card, you know the monthly drill: the accountant wants a summarized and coded version of your receipts for easy entry into the system. In this session, Ken Puls will demonstrate how we can build an application to do this easily – using only Excel. You’ll learn a variety of tricks related to Power Query and Excel to eliminate much of the manual drudgery that typically follows this monthly task.
SPEAKER PROFILE:
Ken Puls, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Ken is a blogger, author and trainer with over 20 years of corporate accounting and IT experience. He is one of the world’s leading experts in Microsoft Excel, Power Query and Power BI, and provides live and online training to clients around the world, including on the Skillwave Training learning platform that he co-founded in 2020. In recognition of his contributions, Ken has held the prestigious Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories.
Connect with and follow Ken online at:
Excelguru Website: excelguru.ca
Skillwave Training Website: skillwave.training
LinkedIn: / kenpuls and / excelguruconsulting
Twitter: @kpuls
Facebook: @xlguru