Professional Development and Event Catalog

Leaders naturally wield power and influence. But, to avoid the temptation of abusing power, leaders must apply ethical behaviors for themselves and others. Words, actions and deeds which demonstrate integrity and trust yield the credibility that make others want to follow ethical leaders. Betraying trust can destroy careers, whole organizations, and lives. This is why trust is a top prerequisite for principled and ethical leadership. Positive (and negative) influence is derived from the credibility trust brings. Ethical leaders who continually work to earn and keep trust reap enormous payback in all aspects of business including superior economic, competitive, and strategic performance.

Excel has over 500 functions and among those, Defined Names is one of the top choices in creating formulas that make your spreadsheets work better for you. After understanding what they are and how to properly create Defined Names, you will wonder how you managed without them for so long. This course is designed to build the foundation to becoming an Excel Formula Expert. Our focus will be on design techniques that should be used when creating formulas. You will learn how to use Defined Names and Excel Tables as an important and fundamental part of EVERY spreadsheet. You will learn techniques that most advanced users don't implement in their spreadsheets but should. After completing this course, you will be well on your way to becoming an Excel Formula Expert. 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.

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.

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.

The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As talent advance into supervisory roles they have to transition from being individual contributors to organizing a team to produce the results. However, most were never taught how to do the planning and scheduling to run projects because many of their leaders learned on the job as well. In this session we will borrow project management skills to teach a new supervisors and managers how to start making longer term plans to optimize the team. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course is a complement to our series on Becoming a Forensic Accountant and the focus of the course is on steganography techniques. Steganography is the art and science of embedding secret messages in a cover message in such a way that no one, apart from the sender and intended recipient, suspects the existence of the message. The first use of steganography can be traced to 440 BC when ancient Greece, people wrote messages on wood and covered it with wax, that acted as a covering medium Romans used forms of Invisible Inks, to decipher those hidden messages light or heat were used. During World War II the Germans introduced microdots, which were complete documents, pictures, and plans reduced in size to the size of a dot and were attached to normal paperwork. Null Ciphers were also used to hide unencrypted secret messages in an innocent looking message. Given the amount of data being generated and transmitted electronically, it’s no surprise that numerous methods of protecting that data have evolved. There are various types of steganography: Text Steganography - Hiding information inside the text files. This involves changing format of existing text, changing words in a text, generating random character sequences or using context-free grammars to generate readable texts. Image Steganography - Process of hiding text in an image without distorting the picture. Video Steganography - Technique to hide any kind of files into a cover video file. Audio Steganography - The secret message is embedded into an audio signal which alters the binary sequence of the corresponding audio file. Network Steganography - The process of utilizing active network protocols as carriers to transmit a covert message, undetectable by an uninformed party, from a host to its destination. This session will review these methods and also discuss relevant software.  

Governmental accounting is very unique. This course will introduce the financial reporting basics for governments, including fund accounting and the modified accrual basis of accounting. Attendees will analyze the layouts of the fund financial statements as well as the government-wide financial statements. The course will also cover the concept of component units, Management Discussion & Analysis (MD&A), and the Annual Comprehensive Financial Report.

For accounting and tax professionals, understanding the inner workings of blockchain and cryptocurrency is no longer just an advantage—it’s a necessity. This course provides an in-depth look into the mechanics of digital currencies and revolutionary blockchain technology, equipping attendees with the knowledge to navigate benefits and risks effectively. Special emphasis is placed on the tax implications for both individuals and estates, ensuring that attendees can confidently advise on these issues, which are becoming increasingly relevant in financial planning and asset management. This offering is more than just a learning experience; it’s an investment in one’s professional growth. By understanding the tax complexities and estate planning challenges posed by digital assets, participants will be able to offer valuable insights and strategic solutions. They will emerge from this course not just with theoretical knowledge but with actionable skills that can be applied immediately. In a landscape where digital assets are becoming commonplace, this is the education that will differentiate the exceptional from the average. Join today and step into a role as a leader in finance for the digital age. **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.

Today's senior executives use LinkedIn to impress hiring managers, find talent, develop opportunities, and build relationships. This interactive session is for the financial executive who wants to position themselves internally and externally for career success by leveraging the #1 professional digital platform. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich.  Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively.  This session will cover a wide variety of day-to-day cash management tools.  

If sales increase, so should profits.  Yet, the opposite result often leaves executives scratching their heads.  When organizations work with inferior cost information, they make mistakes in four specific situations.  Bad information causes sellers to overprice easy, high-volume work and underprice difficult, low-volume work.  This session discusses how to use activity-based costing data to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services.  

Generative AI tools such as ChatGPT, Bard, and Copilot are available to everyone and offer great promise for improved productivity. Learn how you can begin to take advantage of these tools by participating in this session.

You spent your life building retirement savings.  Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation.  Come hear a veteran financial educator talk about money management and planning issues for this phase of your life.  

You are likely familiar with the various forms of penalty relief (reasonable cause, administrative remedies, and first-time penalty relief), BUT can you apply this and consistently expect a favorable outcome? This program will focus on crafting a well-executed request for penalty relief, along with exploring a lesser-known option which can be employed as an effective case resolution tool. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most business professionals have used Excel for years, often without the benefit of any formal training. Thus, they don't know about key features in the application and, therefore, don't use them. Of course, this leads to inefficiencies and errors. Isn't it time to stop this madness? This session is for you if you're ready to become more efficient and effective with Excel! You will learn ten critical features that can help you get more work done in less time and improve your accuracy. We encourage you to make plans to join us for this session to learn the best ways of working with Excel!

This comprehensive four-hour course takes CPAs beyond the basics, diving deep into the ethical quandaries that professionals face. Beyond just the rules of Circular 230, you'll explore a variety of ethical issues, discovering the best ways to handle them with integrity and wisdom. The course provides a dual focus: understanding your obligations under Circular 230 and tackling wider ethical challenges that can arise in your day-to-day work. With real-world scenarios and interactive discussions, you'll come away with practical solutions and the confidence to make the right decisions, keeping your practice ethical and your professional standing secure. **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 is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.

Protecting yourself from ransomware requires more than just anti-virus software. Additional technology protections are necessary. Further, business continuity, legal and regulatory, and cybersecurity insurance considerations should all be a part of your risk abatement strategy. Attend this session to determine if your current level of ransomware protection reduces your risk to an acceptable and identify ways to ensure that you are protected.

Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process. Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit.  This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.