Even with the best intentions, it can be difficult to find time to dedicate to PD. The summer vacation season provides an opportunity to explore alternatives to in-class professional development and squeeze in a few hours from home, the cabin, the beach or anywhere on the go. These live webinars—focused on cybersecurity, fraud prevention, and data analytics—allow participants to interact with instructors and other attendees in real-time. Participants are given a special web link to access the webinar from their personal computer at work, home, or anywhere with a computer and internet connection.
EXCEL TECHNIQUES FOR DETECTING AND PREVENTING FRAUD
Live Webinar – July 10
Fraud is alive and well! From large, multi-national companies to small, family-held businesses, fraud continues to plague businesses. The latest surveys suggest that fraud consumes approximately 5% of all revenues generated in the US economy. This webinar provides a practical approach for uncovering fraud using easy to implement procedures in Excel.
DO IT YOURSELF BUSINESS INTELLIGENCE
Live Webinar – July 11
Microsoft has created two parallel environments for delivering business intelligence reports and dashboards. One uses Excel and the four premium data-analysis add-ins (PowerPivot, Power View, 3D Maps, and Power Query) available in Office Professional Plus and the standalone version of Excel. The other environment uses the cloud-based tools of Power BI and the free Power BI Desktop application to create dashboards without Excel. Both environments allow business professionals to create user-interactive tabular reports and dashboards using quick and easy drag-and-drop processes.
Don’t miss this opportunity to see and evaluate these outstanding business intelligence solutions in action.
SECURITY – A PRACTICAL GUIDE
Live Webinar – July 18
For many, security incidents are not a matter of “if” but a matter of “when.” Therefore, you should use an end-to-end approach for protecting your data, and in this session you will learn how to do just that. Specific topics covered include multi-factor authentication, password managers, encryption, mobile device management, anti-virus, firewalls, policies, and other tools that you can implement immediately. Remember, spending more does not make you more secure, but doing the right things can.
UNDERSTANDING KEY INTERNAL CONTROLS OVER TECHNOLOGY
Live Webinar – July 24
Internal controls over technology are essential to the effective operation of any business, and yet many financial professionals do not adequately consider the impact of IT controls on the effectiveness of the organization’s control environment. This session reviews IT terminology and key IT controls provides an overview of the types of policies and procedures needed in any organization and discusses the scope and nature of major key third party control evaluations (SOC 1, SOC 2, SOC 3, SOC for Cybersecurity, and ISO 27001).
Attend this session and become more effective at understanding, documenting, identifying, and mitigating risks in your IT environment.
POWERFUL DATA ANALYSIS WITH POWERPIVOT
Live Webinar – August 1
PowerPivot provides unparalleled options for analyzing data and preparing summary reports in Excel. With PowerPivot, available in Microsoft Office Professional Plus or the standalone version of Excel, your PivotTable reports become even more powerful. PowerPivot can connect directly to a large number of common external data sources or can be used in conjunction with Power Query for superior data import and transformation capability. DAX functions allow users to create sophisticated calculations, both columns and measures, and the relational functionality of PowerPivot provides all the tools necessary for creating an intermediary database from multiple data sources.
Put PowerPivot to use immediately by participating in this very practical session, which is sure to help you improve your analytical and reporting processes.
QUICKBOOKS ONLINE – CHANGING THE PARADIGM OF SMALL BUSINESS ACCOUNTING
Live Webinar – August 13
QuickBooks Online has come a long way since its initial release in 2000 and now provides a very reliable and robust set of tools for assisting small businesses in managing their finances. From basic accounting transactions to accounting for inventory to managing payroll, QuickBooks Online now provides access to many of the tools small businesses need to manage operations more efficiently and profitably. If you are thinking about converting from another accounting program or cloud-based accounting service, or if you are curious about cloud-based accounting options, learn how to put the power of QuickBooks Online to use by participating in this program.
View CPA Alberta’s PD Program for more webinars, online self-study, and mobile learning options.