2 Credits: Computer Software & Applications
In the ever-evolving landscape of Excel, staying updated with the latest AI-powered features is crucial for Office 365 subscribers, yet many are unaware of these advancements or unsure how to use them effectively. This course demystifies the cutting-edge AI tools integrated into Excel, including Ideas, new data types, data insertion from pictures, and dynamic arrays. Often, professionals struggle with time-consuming data analysis and accuracy issues, but these AI features are designed to address these challenges. By learning how to harness these tools, you’ll significantly save time and enhance accuracy in your Excel tasks. This session provides practical guidance on integrating artificial intelligence into your Excel workbooks, transforming your approach to data handling and analysis, and opening up a world of efficiency and precision.
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
August 23, 2022
Fundamental knowledge of Microsoft Office Excel
CFP Notice: Not all courses that qualify for CFP® credit are registered by Western CPE. If a course does not have a CFP registration number in the compliance section, the continuing education will need to be individually reported with the CFP Board. For more information on the reporting process, required documentation, processing fee, etc., contact the CFP Board. CFP Professionals must take each course in it’s entirety, the CFP Board DOES NOT accept partial credits for courses.
Meet The Experts
Ward Blatch 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 …