CPE + Events Catalog

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

This course introduces how data analytics can be used to improve engagement quality and efficiency. Participants explore the use of data analytics to assess risk, support financial statement assertions, assess internal controls and uncover fraud. Apply the ADA IDEASc approach to using data analytics on engagements to ensure compliance with audit and review standards and to provide value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

More Dates

This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

More Dates

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

QuickBooks Online's (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool's available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables - including grouping options for fiscal periods - and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.

With the explosion of technology over the past thirty years, one fair question is, "what are the ethical considerations and impacts related to this technology?" Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about "techno ethics" and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session in which you will ever participate.

Part one of a five-course series, address common issues new staff members face. Focus on strategies to improve efficiency and quality control, build technical skills, and make valuable contributions to a company. Dive into the fundamentals: workpaper techniques, analytical procedures, compilation and review services, tax recognition and research techniques, understanding audit objectives, and auditing and reviewing selected accounts. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

This 2-hour mini course highlights leadership skills and situations that are common for managers. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people. Leading Others - Coaching & Developing Staff - prioritizing the coaching and development of staff in a post-pandemic work environment, including delegation for development, effective feedback, and managing virtual employees. Building Leadership Communication Skills - strategies to influence and lead others through effective communication in both individual and group settings. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

This course introduces how data analytics can be used to improve engagement quality and efficiency. Participants explore the use of data analytics to assess risk, support financial statement assertions, assess internal controls and uncover fraud. Apply the ADA IDEASc approach to using data analytics on engagements to ensure compliance with audit and review standards and to provide value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

More Dates

This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

More Dates

In today's world of everchanging demands and dynamics of the workplace, it is imperative that we use a tool to help us bring balance, strength, and stability in all we do at work and at home. Mindfulness is an easy and effective tool to help us with this. The Mindful-CPA program via this webinar is designed specifically for Finance and Accounting Professionals. You will learn: The fundamental principles of Mindfulness An 8-minute Mindfulness Practice to be done daily Creative and fun ways to apply Mindfulness to work activities Effective overall strategies to bring creativity, balance, and energy to daily activities. Sunish Mehta, CPA has been a practitioner and instructor of Mindfulness for over 20 years and has worked with several Mindfulness Organizations to date. Having studied with some of the top Mindfulness Teachers in the world including His Holiness The Dalai Lama, Sunish has integrated mindfulness into his learning and consulting work with the focused goal to help conscious professionals bring focus, creativity, and balance to their professional and personal lives. You can learn more at www.mindful-cpa.com.

OSCPA Members: One hour FREE CPE offered at each knowledge network! The OSCPA Not-for-Profit Knowledge Networks offer a great opportunity to explore important not-for-profit topics in one-hour informal discussions with experts and peers - and to obtain valuable CPE. Developed by OSCPA Not-for-Profit Strategic Committee.

OSCPA Members: One hour FREE CPE offered at each knowledge network! The OSCPA Not-for-Profit Knowledge Networks offer a great opportunity to explore important not-for-profit topics in one-hour informal discussions with experts and peers - and to obtain valuable CPE. Note: Date changed from originally scheduled date on March 4, 2025. Developed by OSCPA Not-for-Profit Strategic Committee.

OSCPA Members: One hour FREE CPE offered at each knowledge network! The OSCPA Not-for-Profit Knowledge Networks offer a great opportunity to explore important not-for-profit topics in one-hour informal discussions with experts and peers - and to obtain valuable CPE. Developed by OSCPA Not-for-Profit Strategic Committee.