CPE Catalog & Events

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.

In this course, participants will learn about the five principals of COSO's Fraud Risk Management Guide and the linkages each principal has to the use of forensic data analytics to measurably demonstrate effectiveness and ROI.  We will also explore key elements to a successful program that is sustainable as well as pitfalls to avoid. Finally, we will cover several case studies that demonstrate the key concepts discussed. 

Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!

This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits as well as the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits.

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.

*** Save 15% on this event when you use the code FALL24 at checkout *** This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively.You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation.Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.

How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. 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.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

Accounting and financial reporting for construction contractors may be the most difficult area to be in compliance with the various standards. Also, construction engagements are, in many instances, more "dangerous" than most lines of business due to the many users of the financial statements (especially considering the impact of COVID-19). In this course, we will discuss why construction accounting and financial reporting are so complex and discuss the relationship between the contractor and the surety, both from an underwriting and claims perspective. We will also explore what the surety looks for in order to maximize potential bond credit.

Section 199A is still the hottest tax topic related to the Tax Cuts and Jobs Act of 2017. The Act created new reporting requirements for relevant pass-through entities (RPEs). Each RPE is required to report the relevant data needed to calculate the 199A deduction to each recipient of Schedule K-1. Your clients will trust you to ensure that the relevant data is properly reported. The IRS has added disclosure lines to Schedules K-1 for S corporations, partnerships, and trusts. This course will cover the new reporting requirements on those forms and discuss uncertainties that still exist related to the reporting requirements. The course includes examples and case studies relevant to the new disclosure lines of Schedules K-1. This program will include the latest relevant IRS guidance.

Think about how much time you spend reviewing and creating PDF files. This course teaches you how to take advantage of a multitude of features and functions available in Adobe Acrobat to create, review, organize, edit and secure your PDF files more effectively and efficiently. Like many personal productivity software applications, it is very likely that you are using only a fraction of the potential of Adobe Acrobat when working with your PDF files. For many CPAs, a PDF file is the final presentation of your work product, whether it is a tax return, financial statement, audit report or other financial reports. This course will teach you how improve the quality of those report presentations. The tips you learn in this course will save you time on a daily basis. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We all want to be successful and deeply fulfilled, but most of us have not learned what really leads to a life of abundance, happiness, purpose, and great relationships.  In this seminar, you will learn the most effective methods for creating the life you really want.  In his interviews with such people as Oprah, the Dalai Lama, Deepak Chopra, Tony Robbins, Ted Turner, and dozens of others, Jonathan has learned what really works and what does not.  In this seminar you’ll learn the best personal and professional growth techniques he’s acquired over his career.  Once you know these great ideas and methods, you'll be able to take your life and career to a whole new level. 

Save time and keep current on the latest tax developments. This comprehensive course covers all legislative, judicial, and IRS developments of the past year with a focus on implementation and compliance. Discover how to effectively and confidently complete tax planning and compliance engagements. Cover current developments affecting individuals (including those regarding income, deductions and losses, tax calculations, individual credits, filing matters), business entities (including those regarding S corporations and their shareholders, C corporations, partnerships), estates and trusts, retirement plans, and more.

Position your business for success with effective risk management (bold) Future of finance and other research continues to validate data points that risk management and planning are core skillsets that organizations need to fine-tune for business resilience. Research shows that a comprehensive risk management strategy best positions companies for success. This webcast provides a framework of a variety of prominent risks which, if on your radar, will help you plan for those which could impact your business in unpredictable ways.

As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

It's been said that you cannot fit a square peg into a round hole. The same principle holds true for audits of not-for-profit entities. You cannot simply apply a standard commercial audit approach to the audit of a not-for-profit entity and expect a good fit. Skilled auditors will instead adjust the audit approach to fit the not-for-profit entity. This course is designed to help you do just. It will equip you with the superior skills needed to excel in auditing not-for-profit entities. The course materials utilize a highly illustrative and innovative format. Over 25 focused exercises are included to provide an enhanced working knowledge of auditing not-for-profit entities.

In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.