Professional Development and Event Catalog

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

By now, we should all understand the ethical obligations we have as CPAs.  So, theoretically, if we just all agree to remain ethical, we should not have CPA ethical violations.  But, of course, our professional ethics committees still have plenty of cases to investigate.  This session will examine several ethical frameworks, including the AICPA’s Code of Professional Conduct’s and the GAO Yellow Book’s Threats and Safeguards approach to remaining ethical and resolving ethical dilemmas.  The session will present several ethical case studies that illustrate the complexities of and challenges to staying ethical. By exercising our “ethical muscles”, we should be better positioned to effectively deal with the ethical dilemmas that we will inevitably encounter.

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.  

Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: •    Digital forensics •    Network forensics. •    Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.  

We all know that Fraud Happens. But, why? Why do people we think we can trust let us down? This session will explore the minds of white-collar criminals and examine some recent high-profile fraud cases. Why did they do it? How did they do it? What were the warning signs? If you think that fraud cannot happen to your organization, this session might give you pause.

Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace.  These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these assets.  **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.

Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.

Increasingly, automating business processes is a necessity. In this session, you will learn about real-world examples of automating business processes. Remember, the survival of your business might depend upon successful automation!

Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.

Unlike technologies we use every day, many currently emerging technologies can change how we work in the future. This session covers an assortment of technologies nearing mainstream adoption and helps you understand what they do, how they work, and some of the potential risks and rewards they offer. Attend this course, and learn the basics of blockchain, cryptocurrencies, big data, artificial intelligence, and machine learn.

Employees, now more than ever, are experiencing stress, anxiety and other mental health challenges and all of those come with them each day to the workplace. In order to ensure the safety and security of their workplace, employers need to address these issues and support their employees. Join us to discuss the challenges to providing mental health support to employees, the potential risks of deprioritizing mental health, and tangible actions employers can take to support the mental health of their work group. The cost of providing mental health resources and support pales in comparison to the cost of NOT providing it. Make a plan. Be ProActive.

Have you ever found yourself wondering why people won't just listen to you? Or maybe you have found yourself surrounded by people that make your jaw clench...you know the people...the challenging people.  HR Professionals walk a tight rope of being strong, but not aggressive, polite, but not a push over. It is exhausting! In this session, you will uncover the secrets to working with (and overcoming) challenging people derived from the decades of experience Summer brings from her time on the frontlines and as an HR Professional working with companies such as Walt Disney World, H-E-B and even a dude ranch.  

Appreciation affects your bottom line and your workplace culture. Don’t think so? Think again! Your customers, clients, and co-workers want and need to know they are appreciated. How do you show them appreciation? You show them in their preferred appreciation style.  You have a bias for how you like to receive appreciation, and so do the people with whom you work. In this program, we will build on the research of Gary Chapman and Paul White on appreciation languages – words, time, service, and gifts.  Appreciation is a skill and practice that promises to influence your work life positively. You will experience strategies you can employ in your day-to-day lives to improve your team culture and manage work relationships.

Tax developments have been in the forefront of the news, and tax practitioner can find it challenging to remain up-to-date with these changes.  This 8 hour program will cover tax issues relating to individuals, including new court decisions, recent IRS publications, and the latest tax legislation.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.   **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.

We all are busy, pressed for time and we strive to do as much as we can – as fast as we can. This is our world.  However, there are times when we should stop and think. When we do not analyze (one of our many talents) this inaction causes problems. We will review the penalties of moving too fast. Let’s learn from the mistakes of others.

Are you running around with a fire extinguisher permanently strapped to your back? Do everyday crises run your life, both at work and at home? Do you find yourself consistently taking care of everyone else with no time left to take care of you? In this session, we dive into controlling your chaos and managing your energy. Make no mistake, this isn't your father's time management class. It’s an energy management class developed on behalf of and with tired, frustrated, and burned out HR professionals like yourselves! If you find yourself drained and drinking far too much coffee, this is the session for you!

Emerging from the pandemic is a workplace culture governed by values. Far from a soft approach, it can drive significant business results. Organizations that embrace an empathetic culture increase performance and decrease turnover, while their customers report a more positive experience. Additionally, being more “person-focused” strongly correlates with more effective ethics and compliance programs. These insights can provide a roadmap for the "new normal" as the world emerges from the crisis. How employees and management move forward from this experience will shape the workplace for decades to come.

ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims.   *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****

You may have read all sorts of stories in books about how bad people steal and make their coworkers and organizations miserable.  Come hear veteran Internal Auditor Rob Berry and veteran CFO John L. Daly discuss situations they have seen in the real world.