Register for Webcast

Live On-Demand

Learn more about live on-demand here.


Computer Software and Applications
Fundamental knowledge of Microsoft Office Excel

Course Description

If you are an Office 365 subscriber, you should know that Microsoft is bringing artificial intelligence to your Excel workbooks. These leading-edge features include Ideas, new data types, the ability to insert data from a picture, and dynamic arrays.  If you know how to use these tools, these AI-powered additions to Excel will save you time and improve accuracy. Take part in this session to learn how you can bring artificial intelligence to your Excel workbooks.

Major Topics Covered

  • How to use Excel's Ideas feature
  • Working with Excel's new data types
  • How to use Dynamic Arrays


K2 Enterprises (Ward Blatch)

Ward provides consulting and training services as the Managing Director for K2E Canada throughout the United States and Canada. The professional development courses presented by Ward include cloud computing, business intelligence, security, technology updates, internal controls, paperless office, mobile office, Adobe Acrobat, Excel, Word, PowerPoint and Outlook. Ward obtained his CPA, CA designation while working at a Nova Scotia regional accounting firm before starting his own consulting and accounting practice. His practice provides accounting, tax, training, support, and network evaluations for small businesses and not-for-profit organizations. Currently Ward lives in rural Nova Scotia with his partner Elizabeth and their twin daughters. The family enjoys exploring the outdoors by foot and canoe.

Course Specifics

Computer Software and Applications
Mar 18, 2020
Fundamental knowledge of Microsoft Office Excel

Compliance Information

Qualifies for CA Fraud: No

Learning Objectives

Upon completing this session, you should be able to:

  • List the AI tools available in Excel
  • Create formulas that work with Dynamic Arrays
  • Utilize Ideas to find information in your data

Back to top