2026 Virtual Professional Development Days & AGM

Workshops and Concurrent Sessions

Ethics

• Ethics in BC’s Healthcare Finance: AI, Internal Controls, and Professional Judgement in a Time of Change

Workshops + Concurrent Sessions

• list coming!

Computer Labs

Frank Byl

Certified Microsoft Master Instructor

Frank has helped thousands of clients to hone their computer skills. He has previously taught OneNote as well as Excel classes at previous BCFHPS Conferences. Network with other professionals and learn tricks to maximize your and your employer's productivity + systems.

NOTE ABOUT CONNECTING REMOTELY: Participants should have two monitors or two devices, so that they can watch on one screen and practice on the second screen. The second device must be a tablet or another computer, a phone will not be sufficient. A link to download any required files will be provided prior to the workshop and at the start of the workshop.

RECORDING OF WORKSHOP: We will record the presentation and allow the video to be accessed via the conference website for six weeks after the conference for those who wish to review the presentation or for members that were not able to attend the workshop.

Join Frank in these computer lab sessions:

Workshop 1b: Power Query

Excel’s Power Query tools allow for automated uploading of data from multiple sources and types. We will work with real (sanitized) data in various forms including PDF, Text files, CSV, and Excel formats to show how data can be automatically uploaded, converted, and organized into useful Excel tables. Further to creating the original query participants will learn how to append and remove data using the same queries.

Workshop 1c: Advanced Excel for Accountants

Excel is constantly creating new functions that provide faster, easier, and more powerful ways to compile and analyze information. Initially we will build key skills of understanding the importance of building expandable named ranges in functions. Then we will spend some time discovering useful functions and how to apply them and to use the built-in help features. Along the way we will reveal some of the new “Spill” functions and some of the unique syntax required to work with them. Finally, we will also develop some tools to automate repetitive functions that might be done daily, weekly, or monthly.

Workshop 2b: Power Pivot

Many times, data is not provided in a single table but is in multiple tables that are related. Perhaps a table of Physician Info, Client Info, and Service Info. While related each table contains unique information. Power Pivot allows users to connect those tables and create meaningful reports and even charts. This workshop would provide data sets to be used in the workshop. For continuity, that data will be the same data that was created in the Power Query workshop so that participants could understand the full flow of data from raw data to final reports. The final portion of the presentation will integrate skills from the Power Query functions taught in the first session.

Concurrent 1a & 2a: Using CoPilot in Excel

CoPilot is like having a really smart and useful assistant helping you with your Excel. This could be very useful but how do you communicate what you would like your CoPilot to do? Learn how to apply a structured prompting framework and how to modify and improve your instructions. Then experience how Copilot can clean and organize financial data, analyze results looking for variance, trends and KPI’s. Finally, learn how Copilot can Generate reports and summaries.

See 2026 schedule