CPE + Events Catalog

It is virtually impossible to pick up the daily newspaper and not find an article on some type of fraudulent event. In the wake of the “Era of Fraud, Waste and Excess,” one might suspect that potential fraudsters would think twice before committing illegal acts. However, just the opposite seems to be the case.  Is there really more fraud or is there simply more fraud awareness?  The harsh reality is that it is a little bit of each.  Not only has fraud worldwide reached a level of over $7.0 billion in lost  revenue but savvy C-level executives now realize that it could happen to their companies—very easily. When you put these facts together, it adds up to a completely new era of vigilance.

Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams.  In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss!

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

A chain is only as strong as its weakest link.  The same theory applies to departmental performance—the overall result is only as strong as its weakest contributor.  Leave our interactive and entertaining session with insight for developing and sustaining the best team you can possibly assemble.  The four elements in this process are (1) development, (2) leadership, (3) hiring and (4) environment.  Discuss how to effectively use these elements in your creation of an outstanding organization. Discover the power of the 10 Attributes for Leadership Success and the negative impact of Leadership’s Fatal 13. Above all, learn how to combine these four elements as a successful catalyst for sustained high-quality output and results.  

Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.

The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments.  This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals.  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.

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

Strategic Planning for SMEs

This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

A multitude of tax changes have are currently taking place, challenging tax practitioner to stay well-informed. This 4 hour program will cover tax developments specific to business, including new court decisions, recent IRS publications, and the latest tax legislation that will impact individuals.  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.  

Enterprise Risk Management for SMEs

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.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

Now more than ever, navigating loss, grief and crisis in the workplace is a skillset that leaders must possess. Keeping the heart in human resources is so important, especially in this post-pandemic state we are living in. We will explore ways that you can show empathy to your employees while also balancing your business needs. 

LinkedIn is considered by many to be one of the most impressive growth stories in the history of technology companies in Silicon Valley. In just 16 years it grew from nothing into a game changing company in a new industry and the performance of the company and the stock broke all kinds of records. The untold story of LinkeIn's success is that they grew a world class company and a world class team in the midst of a massive war for talent where their competitors for talent (Google, Facebook, Apple and more) could out pay and out perk and out benefit them. They grew a company when all the leaders had never built a company before. Despite the odds the leadership team succeeded and built a company and a culture that many still consider the gold standard. Steve Cadigan was at the epicenter of this growth as the first Chief HR Officer of LinkeIn and he delivers a front row seat to the wild and crazy and amazing ride that took LinkedIn from an unknown career destination into one of the top places to work in the world! Steve delivers a first hand account of lessons learned, mistakes made and what it was like to be facing a situation he had never faced before - hypergrowth. Wherever you are in your learning journey you will enjoy this class.

Award winning discussion leader, former state accountancy board chair, and lifelong tax practitioner Mark Hugh will review ethics for tax professionals: the AICPA Code of Professional Conduct and interpretations; the Statements on Standards for Tax Services; tax preparer standards in the Internal Revenue Code; the rules for practice with and before the IRS, including IRS Circular 230; new developments; and discuss examples of best practices and case studies.