Professional Development and Event Catalog
Excel: Fundamentals, Data Entry and Basic Formulas
Wednesday, March 22nd, 10:00am - 12:00pm
Online
2.00 Credits
Are you self-taught on Excel? Have you ever wondered if you really know how to use Excel? Do you want to build a great foundation for using Excel? Are you new to using Excel? If you answered YES to any of these questions, this is for you. This course is designed to start with the basics of using Excel from the interface to the structure to data entry to formula basics. Whether you're a beginner or an intermediate user, you will gain valuable foundational knowledge for using Excel. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How Machines Are Coming Alive and Ruling the World
Wednesday, March 22nd, 10:00am - 12:00pm
Online
2.00 Credits
The course provides a concise overview of the Internet of Things (IoT), a global ecosystem of advanced technologies that connect objects to the Internet, each other and people. Discover how new IoT apps and devices are being used to increase operational efficiency, develop post-transaction relationships, and create new revenue streams in enterprises worldwide. You'll walk away with a fundamental understanding of IoT applications and their potential to help accountants boost their relevance, value, and revenue. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
S Corporation Essentials: Review and Update
Wednesday, March 22nd, 10:00am - 2:00pm
Online
4.00 Credits
This program addresses the critical issues and special opportunities facing S corporations, with a focus on the new IRS guidelines on shareholder stock and loan basis reporting. The impact of recent legislation, including the CARES Act and COVID-19 developments, on the tax filings of S corporations will be addressed, as well as the significant impact of the new Section 199A flow-through entities deduction on S corporations. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to leighanne.conroy@acpen.com.
Power BI: Use PBI Desktop to Create Reports and Dashboards
Wednesday, March 22nd, 10:30am - 2:30pm
Online
4.00 Credits
* This course is #8 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Power BI Desktop is a new stand-alone tool that adds visualization to your data. This course focus on learning the Power BI Desktop interface, connecting to data sources and creating the visualizations. We will demonstrate the creation of each of the various visualizations and the various options related to each. We will also show how the visualization can be connected together to provide fully-interactive reports with drill-down capabilities. This class does not require any Excel knowledge but understanding Power Pivot and Power Query can reduce your learning curve. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Current Issues in Performing Yellow Book Audits
Wednesday, March 22nd, 11:00am - 1:00pm
Online
2.00 Credits
Staying current on significant changes in Government Audit Standards can be difficult. This course covers the most important issues and changes relevant to Yellow Book financial statement audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Peer Reviews of SSARS Engagements
Wednesday, March 22nd, 11:30am - 1:30pm
Online
2.00 Credits
Cover the basic requirements of a peer review performed in accordance with AICPA's Peer Review Standards for firms that perform preparation, compilation, and review engagements. Topics include the documents reviewed by peer reviewers, the evaluation of the engagements, types of matters and peer review reports, the administrative process, peer review committee involvement, and requirements of the state boards of accountancy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Program Services & Governance: Form 990 Parts III & VI
Wednesday, March 22nd, 11:30am - 2:00pm
Online
2.50 Credits
Session 6 of Borenstein's Form 990 Foundational Series: The Form 990 Parts addressed in this session are two `legs' of the 990's non-financial disclosure-driven three-legged stool. Stakeholders, donors, competitors, and naysayers use both the Program Service Accomplishments Part's disclosures and the filer's responses to Part VI's "Governance" inquiries to assess the organization's credibility and have a sense of management's capacity. Part III not only details Program Services' output with great specificity, but also updates the Form's readers both as to the filer's largest arenas of activities and how conducted activities have changed. And Part VI, the infamous "Governance Part," provides information as to the composition of those "legally in charge," as well as how both the Board of Directors/Trustees and its delegated officials employ policies in favor of maintaining internal controls. Preparers need to appreciate the importance of these two key parts and ensure that filers put their "best foot forward" properly here. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2'S How To Run Microsoft Office From The Cloud
Wednesday, March 22nd, 12:00pm - 12:50pm
Online
1.00 Credits
Cloud-based options of familiar Microsoft Office applications have been available for over a decade. Moreover, these tools have matured to the point where their functionality rivals desktop-based options. Further, the ease of deploying, accessing, and using these tools is striking. In this session, you will learn about Cloud-based alternatives to everyday desktop applications and why you should consider adding them to your toolbox. You will also learn about the relative strengths of competitive services available from Zoho and Google and why you should consider these tools. Knowing all your options is imperative in the new cloud-connected world!
K2's Password Management Tools - Why And How You Should Use Them
Wednesday, March 22nd, 12:00pm - 1:48pm
Online
2.00 Credits
Correctly implemented passwords help protect valuable information. Both the complexity and the number of passwords required have multiplied. Further, it has been shown that using the same password for multiple sites or easy to guess passwords enable bad actors. Password management tools have emerged as a leading option for enhancing security to address these challenges. In this session, you will learn how password management tools can help you implement, update, and manage your passwords. You will also learn about the features of leading password management tools and why these tools are necessary to improve security. Finally, if you hope to implement a passwordless approach, we will spend time on the current options. If you are seeking to enhance security, this session is an absolute must!
K2's Amazing Accounting Add-Ons
Wednesday, March 22nd, 12:00pm - 1:50pm
Online
2.00 Credits
A complete accounting software solution almost always includes additional add-on products. For example, it is hard to accurately calculate sales tax, do budgeting, or have adequate reporting without third-party add-ons. This session provides guidance on some of the best add-ons in the market. If you have needs that your current solution does not meet, you may not need to change it. You may just need the right add-on! Attend this session to discover the best of best extensions for accounting software.
Leadership Skills for Peak Performance in 21st Century
Wednesday, March 22nd, 12:00pm - 2:00pm
Online
2.00 Credits
Your technical skills are strong. They got you to where you are today: leading teams, engagements, and client relationships. How do you focus your time and energy to be an effective leader? More importantly, how do you avoid the potholes that distract you from what you love to do? Join us to learn the key skills for peak performance in the 21st century. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Payroll Essentials: De-mystifying Form W-4
Wednesday, March 22nd, 12:00pm - 2:00pm
Online
2.00 Credits
With the roll out of a new Form W-4 in late 2019, the IRS made significant changes to employers' withholding and payroll reporting requirements. In addition to the myriad of changes brought about by COVID-19 legislation, carried out through the payroll function, the IRS fundamentally revamped Form W-4 for employee reporting, doing away with the concept of allowances and requiring changes to payroll administration and employee communications. Now more than ever, employers need to know that the W-4 they are working with is working to withhold income taxes correctly for their employees. In addition, it is the employer's responsibility to ensure Form W-4 is filled out correctly and accurately. Employers need to understand the nuances and requirements that come with this obligation. This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accounting & Auditing Update
Wednesday, March 22nd, 12:00pm - 4:00pm
Online
4.00 Credits
This course will cover what's going on at both the FASB and AICPA by reviewing the standards effective this year. We'll start with a review of the Accounting Standards Updates (ASUs) issued by the FASB that will be effective this year including a deep dive into Topic 842, Leases. The course will address those standards that will be effective for both public and private entities in 2022. We'll then turn our attention to the audit side of the house with a focus on SAS 142 which is effective this year. This course is a great way to overview all the A&A standards effective this year.
Common Yellow Book & Single Audit Deficiencies
Wednesday, March 22nd, 12:00pm - 4:00pm
Online
4.00 Credits
This course will review focus areas for peer review for Single Audits and Yellow Book engagements. We will review the requirements for major program determination, testing compliance, testing internal controls over compliance, sampling, and reporting for Single Audits. We also address Yellow Book CPE and independence requirements. This course will provide an overview of common deficiencies found during peer review and how entities can effectively and efficiently avoid these issues when performing these procedures.
Sexual Harassment in Professional and Corporate Environments
Wednesday, March 22nd, 12:30pm - 1:30pm
Online
1.00 Credits
The #MeToo movement is an example of how cultural, and even legal, changes can be initiated and promoted by social media. This workshop considers the changing legal and ethical ramifications of sexual harassment in the wake of this movement. Financial and accounting professionals need to be aware of these changes and how they may be expected to be part of the solution rather than part of the problem. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communication Skills for Introverts
Wednesday, March 22nd, 1:30pm - 3:30pm
Online
2.00 Credits
In today's technology-driven world, success in business depends upon your ability to translate data into information, communicate with anyone, and present ideas powerfully, whether it's one-on-one or in the boardroom. This fast-paced and interactive session covers specific techniques in three critical areas: listening, writing, and presenting. Learn about the hard skills involved in the softer side of leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2'S Choosing Your Mid-Market Accounting Solution
Wednesday, March 22nd, 2:00pm - 2:50pm
Online
1.00 Credits
Many businesses are being held back by legacy solutions. The old way of doing things just doesn’t work anymore. Instead, Software as a Service (SaaS) has transformed many mid-market companies. In this new world of cloud-based, workflow-enabled, data-centric, and connected solutions, you can solve existing and future business problems in new ways without being bogged down by paper-centric environments. This session covers integrated and ERP solutions that should work for businesses in the $10 Million to $1 Billion range. If your existing system has been in place for seven or more years, it is time to consider upgrading or replacing it. Leverage your instructor’s knowledge of the market to minimize your risk.
K2'S Implementing Data Loss Prevention For Better Security And Privacy
Wednesday, March 22nd, 2:00pm - 2:50pm
Online
2.00 Credits
Data Loss Prevention (DLP) is a means of creating and enforcing security policies in an organization. For example, you can create DLP rules that programmatically block all outbound email messages containing Social Security or credit card numbers. Unfortunately, most business professionals have yet to discover DLP and how it improves security. In this session, you will learn the fundamentals of DLP and, through demonstrations, see how you can use DLP to enhance organizational security. You do not want to miss this chance to learn how to take advantage of one of the most innovative security options available to you!
K2'S The Best Small Business Accounting Tools
Wednesday, March 22nd, 2:00pm - 3:40pm
Online
2.00 Credits
Working with a small business, you know that keeping the company’s finances in order is critical to success. While numerous software programs and tools are available to help you do this, they vary substantially in many significant aspects. In addition to conventional options like QuickBooks and Sage 50, you can choose from Cloud-based tools such as Zoho Books, QuickBooks Online, Spire Systems, Xero, Accounting Suite, Accounting Power, and many more. In this session, we’ll look at the best accounting tools for small businesses and discuss the benefits of each one. This session covers accounting solutions that should work for startups and companies with up to $10 million in annual revenue. So, whether you work with a startup or an established small business, attend this session to find out which tools can help you achieve your financial goals.
K2's Formatting Excel Spreadsheets The Right Way
Wednesday, March 22nd, 2:00pm - 3:50pm
Online
2.00 Credits
Some estimates indicate that business professionals spend as much as half their time in Excel working on formatting. If you are interested in getting better formatting results in less time, participate in this session to learn the best practices for applying formats in Excel. In this session, you will learn the right way to apply formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial amounts of time when working in Excel.