K2's Road to Excellence
Online Seminar

When you take a K2E Canada seminar you have the opportunity to learn from a highly respected instructor with over 30 years of experience in helping accounting professionals identify, address and solve issues through the practical application of technology.

This series of free seminars will improve your productivity and turbocharge your use of Microsoft products. As an added bonus, in the second half of each seminar you will be introduced to technology solutions specifically designed to enhance modern accounting and bookkeeping practices.

Earn verified PD credits - Attendees must answer at least 75% of poll questions during the live seminar and attend for a minimum of 50 minutes to earn 1 verified PD credit. Attendees who do not meet the credit requirements during the live seminar earn 1 non-verifiable PD credit.

Register to attend an online seminar and you'll receive the link to the recording and the teaching files within 1 day of the session. Recorded seminars can be viewed when it's convenient for you at the office or at home, and on any device. 



"I am really enjoying the Office series and the sponsor info on software as well." Jane K. Howe, CPA, CMA


"Thanks for hosting these webinars. I found them very useful. Just recently, I was trying to update a document and had to figure my way out through trial and error. Your webinar helped me to understand the process a lot better." Howard Brown


"These webinars have been great for tips and usage that I would not know about in my regular activities." Kelly Farfaras

All sessions begin promptly at 12.00pm ET

Upcoming Seminars

K2's Road to Excellence - Part 9
Super-charging Working Papers, Year End Analysis in Excel
and Receipt Bank
Wednesday October 14, 2020

K2's Road to Excellence - Part 10
Top Online Mistakes
and Connected Accounting ERP Software
Thursday October 29, 2020

K2's Road to Excellence - Part 11
Expense Tracking and Zoho
Tuesday November 3, 2020

K2's Road to Excellence - Part 12
Better Collaboration and Receipt Bank
Tuesday November 17, 2020

K2's Road to Excellence - Part 13
Automating Workflows with Microsoft's Power Automate
and Receipt Bank
Tuesday December 1, 2020

K2's Road to Excellence - Part 14
Password Managers and Zoho
Thursday December 10, 2020

Recorded Seminars

Recording Date	Title	Overview	Partner	Recommended Webinars
Sept 23 2020	K2's Road to Excellence - Part 8 XLookup and Xero	It is time to say good-bye to your old favourites Vlookup, Hlookup, and index and match. This new function in Excel can replace all of them. In this session, we will introduce you to the powerful new function Xlookup.	Xero	K2's Improving Collaboration with Microsoft Teams K2's Excel's Best New Features K2's Excel's Best New Features
Sept 9 2020	K2's Road to Excellence - Part 7 Ethics and Technology (Technoethics) and Zoho	In this session, you will learn about “technoethics” and the implications this has on individuals and organizations. To that end, we will explore many of the current and emerging issues associated with ethics and technology, such as cybercrimes, privacy versus security, and AI technologies.	Zoho Books	Improving Collaboration with Microsoft Teams Personal Technologies Securing Your Data - Practical Tools for Protecting Information
Jun 16 2020	K2's Road to Excellence - Part 6 Power Excel Session 2 and Zoho	This session will introduce you to PivotTables, which are widely considered the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. In this series of seminars, you will learn how to build PivotTables, how to group data inside PivotTables – including grouping options for fiscal periods – and how to create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including how to build PivotTables that consolidate data from multiple data ranges and PivotTables dynamically connected to external databases and financial accounting systems.	Zoho Books	K2's Bringing Artificial Intelligence to Your Excel Workbooks - On Demand K2's Data Analysis with Power Pivot - On Demand K2's Excel Data Models, Combinations and Consolidations - On Demand
May 12 2020	K2's Road to Excellence - Part 5 Power Excel Session 1 and Client Track	Many of us spend a vast portion of our time banging our heads against Excel. In this webinar Alan will show you how to use Analysis Tools in Excel to improve your productivity. You will learn the Analysis Tools Goal Seek, Break Even Analysis, Moving Average, Solver and more.	Client Track	K2's The How's and Why's of Creating User Defined Functions in Excel K2's Mastering Advanced Excel Functions and Formulas
Apr 7 2020	K2's Road to Excellence - Part 4 Alan's Top PowerPoint Tips and Zoho	Many of us spend a vast portion of our time banging our heads against Excel. In this webinar Alan will show you tricks you can pull off inside the cells and out with his formula tips and tricks. You will learn tips on how to manipulate text; change normal text to sentence text; generate random numbers; date calculations; days in a month; calculate a person’s age using dateif; ratios; sumproductif and more.	Zoho Books	K2's Office 365 - New Tools, New Tricks K2's Security - A Practical Guide
Mar 10 2020	K2's Road to Excellence - Part 3 Alan's Top Excel Tips, Session 2 and Receipt Bank	You will learn tips on planning your presentation; the bullet death trap; using the PowerPoint Designer; choosing the right fonts: using visual metaphors to display your data; customize your slides for different audiences and more.	Receipt Bank	K2's Microsoft 365 All the Things You Need to Know K2's Excel Power Query - Ten Things You Need to Know