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

Upcoming Seminars

K2's Road to Excellence - Part 7
Ethics and Technology (Technoethics) and Zoho
Wednesday September 9, 2020

K2's Road to Excellence - Part 8
Xlookup and Xero
Wednesday September 23, 2020

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

Recorded Seminars

Recording Date	Title	Overview	Partner	Recommended Webinars
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 (2 CPD Hours) K2's Data Analysis with Power Pivot - On Demand (2 CPD Hours) K2's Excel Data Models, Combinations and Consolidations - On Demand (2 CPD Hours)
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
Feb 11 2020	K2's Road to Excellence - Part 2 Alan's Top Excel Tips, Session 1 and Xero	In this webinar Alan will show you tricks you can pull off inside the cells and out, improving Excel's interface while making your calculations more powerful and versatile. You'll be able to speed up data entry, change values worksheet-wide, etc. You will learn tips to automate data; No formula fumbling; pasting up; quick formatting; defining; cutting corners and more.	Xero	K2's Excel Best Practices K2's Securing Your Data - Practical Tools for Protecting Information
Jan 15 2020	K2's Road to Excellence - Part 1 Our Top Picks from CES 2020 and Client Track	After returning from the Consumer Electronics Show (CES) 2020 Ward Blatch will be covering all of the latest technology from the event including new tech for business and personal use.	Client Track	K2's Personal Privacy K2's Critical Tips for Avoiding Identity Theft K2's Implementing Password Management and Data Loss Prevention Tools for Better Security