Professional Development and Event Catalog

Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. This session is presented using Excel 2013. Regardless of the version you are using, ALL 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.

Automation options abound, and in this session, you will learn how to take advantage of many personal automation tools and services. You will learn about various automation platforms, creating automation workflows, and automation tools to become more efficient.

With many technologies now ready for “prime time,” it’s exciting to see some of the options for improved productivity in CPA firms. Learn more about these new tools in this session.

How do you raise your skills to the next level to master the Controller or CFO role?  Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency.  How are your technical skills?  Are you a traditional accountant or have you learned to expand your technical skills to go beyond “what are the financial numbers?” to “why did these financial results occur?”  Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action?  Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills?  Can you set a vision? Can you develop a strategy?  Do you understand the macroeconomic environment of your organization?   Can you lead a major project to a successful conclusion?  This session will explore the role of business as opposed to tracking the results of the business. How are your people skills?  How good is your ability to influence others? How are successful are your negotiation skills?   How well can you communicate?  Are you a collaborator or a partner?  This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills?  Do you inspire staff or make them angry?  Do you know why your staff work for your company and you?  Do you understand what employees want from their position?  Do you know how to deal with a difficult staff person?  Can you lead difficult change?  This session will help you recognize what leadership truly is as opposed to what passes for day to day management.

Being consistently ethical is a challenge. Most of us have had to make tough choices.  This session will discuss real world cases involving thorny ethical dilemmas and how to resolve them. Being ethical is not the same as complying with the law and ethical issues are not always black and white. This session will review different professional ethical standards.  What does integrity mean in the office? If you want to learn lessons from the best in a short time, this session is for you.  Participate in engaging dialogue about how to prepare for the inevitable ethical situations.  These lessons are valuable for every business leader.

This course is designed to equip CPAs, EAs, attorneys, and tax professionals with the essential knowledge and strategies needed to navigate the latest developments. Explore innovative approaches to maximize retirement savings, discuss tax- efficient retirement plan options, and align estate planning techniques with current trends. Gain a thorough understanding of altered rules for Required Minimum Distributions (RMDs) and discover how to optimize estate plans in response to changing regulations. This update is tailored for professionals seeking practical insights in the realm of contemporary retirement planning. **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 kori.herrera@acpen.com.

This course will help you develop a strategic marketing and business development plan for your firm using 7 key principles to help maximize lead generation. You will learn how to establish and grow your B2B business in any niche using time-tested strategies, proven processes for attracting and retaining customers, and how to measure your results so you can spend your money and time effectively to own your market and attract higher ROI clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.  

Network forensics - defined as the investigation of network traffic patterns and data captured in transit between computing devices - can provide insight into the source and extent of an attack. It is used in forensic accounting and with the expansion of information technology it has become a growing field. Network forensics is a relatively new field of forensic science. Computing has become network centric. Data is now available outside of disk-based digital evidence. Network forensics can be performed as a standalone investigation or alongside a computer forensics analysis. When used alongside a computer forensic analysis it is used to reveal links between digital devices or reconstruct how a crime was committed. Network investigations deal with volatile and dynamic information and is a sub-branch of digital forensics. It relates to the monitoring and analysis of computer network traffic for information gathering, legal evidence, or intrusion detection. This course is a complement to our other courses in the series on becoming a forensic accountant.  

Using Outlook for email management is routine for most business professionals these days. But unfortunately, using this tool for so long may cause some to perpetuate bad practices and habits when working in Outlook and exploring new options Outlook offers. In this session, you will discover ten valuable tips to take you to the next level of your email and work management.

Accountants are expected to demonstrate a questioning mindset. While such professional skepticism is an obvious requirement for assurance engagements, it is applicable elsewhere in the practice of public accounting. In fact, a skeptical mindset offers benefits to both public accountants and those who work in industry. This course provides specific examples of professional skepticism while suggesting best practices.

Tax rates, personal liability, operations – these are all factors to be weighed when advising clients about their choice of entity decision.  This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. **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 kori.herrera@acpen.com.

OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.

Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program provides an update to the latest tax developments, rules and regulations impacting individual taxpayers, with a review and integration of the numerous 2021/22 legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

Each year brings its own set of tax planning challenges, and this year is no exception. This course aims to arm tax planners with planning strategies and ideas that all clients, but in particular, wealthy clients, middle-income clients, and closely held business owners need to consider right now to take advantage of present opportunities and plan for future tax advantages. Learn strategies that can really have an impact on client lives, while also bringing value to you and your firm. This material is continuously updated for recent legislation impacting individual taxpayers.

This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.

Today's CPAs can expect their prospects, clients, referral partners, and candidates to research them on LinkedIn. The good news is that you can leverage LinkedIn to craft a digital presence that demonstrates your expertise, showcases your personal brand, and aligns with your values. Learn how to create a LinkedIn profile that is not just a resume but a valuable marketing tool for your CPA business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In today's workplace, employees are faced almost daily with customers or teammates that may have needs or concerns that we are forced to handle. Though many of these situations are easily dealt with through simple communication skills, others may become heated and, in some instances, violent. Today we will discuss healthy ways to de-escalate a wide variety of potential issues.