OneNote is rapidly becoming one of the most popular applications in the Microsoft Office and Office 365 product suites. The reason for this becomes pretty evident when you learn about all that you can do with OneNote to record and manage notes, to do lists, meeting agendas and much, much more. This course will provide a thorough review of all of the features of OneNote so you can master them in order to organize all of your activities and communications in one central place. You will be amazed at how powerful and yet simple to use this application is. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The following topics will be covered in this course:

• Navigating the OneNote interface
• Best practices for notebook organization
• Learn how to add pictures, graphic content, tables, file links, email messages, appointment links and more to your notebooks
• Using OneNote with OneDrive to share and collaborate with internal and external users
• Creating and using templates to streamline your notebook management
• Integrating OneNote with your task manager
• Using the power of tags to manage and search your content
• Using OneNote on your tablet and smartphone

Who will benefit:

Anyone who records and keeps notes of any kind

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

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.

The major topics covered in this class include:

• 2021/22 legislative developments, cases and rulings impacting individual taxpayers
• Changes to Form 1040 and other related forms, worksheets and schedules
• Individual income items, itemized deductions and credits
• Updated tax rate schedule and other inflation adjusted items
• Implications for self-employed taxpayers of various legislation
• Section 199A changes, including use of carryforward passive activity and 199A losses
• Capital gains and losses
• Passive activity and hobby loss rules changes

Who will benefit:

CPAs in public practice and industry seeking an update on the latest individual tax developments.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Auditing Contingencies and Going Concern Uncertainty - Testing for Completeness and Proper Disclosure will provide tips and techniques for obtaining sufficient appropriate audit evidence to support conclusions related to contingencies and going concern uncertainty. Financial statements may contain significant uncertainties requiring special audit consideration for evaluating proper accounting and financial reporting treatment. Note:
This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities for evaluating loss contingencies and substantial doubt about going concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

• Overview of contingencies and related disclosures
• Identifying and determining proper accounting treatment for litigation, claims and assessments
• Evaluating the sufficiency of attorney's letter responses for audit evidence
• Evaluating substantial doubt about an entity's ability to continue as a going concern for a reasonable period of time
• Auditing managements assumptions in making the going concern evaluation
• Proper application of the liquidation basis of accounting

Who will benefit:

Accountants responsible for auditing contingencies and going concern uncertainties

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

The work for clients is not as linear as it used to be with the inclusion of more advisory services, more cross functional teams, and due dates moving. Quality client engagements are not just about a solid workflow, we need project management skills. In this session we will discuss how to apply project management techniques to designing a one firm, team approach to serving clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics covered in this course include:

• Clarification between workflow and project management and the use of each
• Leveraging the project charter to establish consistency and collaboration across teams for a quality client experience

Who will benefit:

Partners, directors, managers, and supervisors.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this class include:

• Navigating around worksheets
• Selecting cells and ranges
• How to use custom number formatting
• How to leverage Views
• How to build better formulas with referenced variables and defined names
• Learn to quickly format cells with Cell Styles
• Learn proper worksheet structure

Who will benefit:

Any Excel user that wants to learn the "real" basics of Excel that will increase their productivity.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

NOTE – This ethics course has not been approved by the Accountancy Board of Ohio therefore does not count towards your mandatory 3 Hours of Professional Standards & Responsibilities credit per renewal period. This course does count towards your 120 CPE Hours.

This course provides a concise overview of how the Internal Revenue Service (IRS) thinks. The session reviews how the agency uses behavioral insights -- the study of how people reflect and behave -- to drive compliance, positively impact taxpayer engagement, and reduce taxpayer burden. While the IRS is governed by federal tax law, it's also shaped by social norms. As part of their mission to collect taxes and administer the Internal Revenue Code, the agency utilizes human psychology to achieve their goals. These activities include public identity (using the IRS logo, seal, and symbol), voluntary compliance (using public shaming and the "Wesley Snipes" effect), trust building (using a Taxpayer Bill of Rights), and error reductions (using alerts and reminders to nudge behaviors). The session reveals how to "get into the head" of the agency and better understand the key psychological factors (individual, environmental, social) that drive leading IRS operations and decisions. The course also spotlights the leading issues and pain-points that are currently "top of mind" for the agency and how practitioners can be more mindful in their interactions with the IRS to improve outcomes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

• Behavioral insights (BI) Primer
• How and why BI are used by the IRS
• IRS and individual decision-making
• IRS and environmental and design considerations
• IRS and social norms
• IRS "top of mind" issues
• BI and Implementation of tax reform legislation
• BI and private debt collection
• BI and online taxpayer accounts
• BI and taxpayer rights in "real" vs. "unreal" audits
• BI and the tax-exempt approval process
• BI and passport renewal and revocation
• How to use BI to more mindfully interact with the IRS to improve outcomes

Who will benefit:

Practitioners who want to better understand how behavioral insights impact IRS operations and how this cognitive concept can be used by accountants to improve their interactions with the agency.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics covered in this class include:

• Target profit analysis
• Break-even analysis
• Relevant costs and decision-making
• Standard costs and variances
• Activity-based costing
• Segment reporting and analysis

Who will benefit:

Accountants who have not recently considered managerial accounting techniques and proficient managerial accountants who desire fresh, practical illustrations of managerial accounting analysis and related decisions.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing, and reporting information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics covered in this class include:

• Using formulas to manipulate and transform data
• Using formulas and reference formulas such as =VLOOKUP
• Using pivot tables
• Understanding Solver to perform multivariate analysis

Who will benefit:

Practitioners, members in industry and other accounting professionals seeking a broader understanding of Microsoft Excel.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this class include:

• Excel Tables:
  Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.
• Custom Sorting:
  Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.
• XLOOKUP:
  Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.
• SUBTOTAL:
  Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.
• SUMIF(S):
  Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.
• Array Formulas:
  Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.
• Data Validations:
  Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.
• Slicers:
  Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.
• Conditional Formatting:
  Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.
• PivotTables:
  An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.

Who will benefit:

This course is ideal for accounting professionals at all levels who have a basic understanding of Excel and are looking to advance their skills to streamline their accounting practices and financial analysis.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

When a purchaser buys an existing partner’s partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser’s partnership interest (outside basis). If the partnership’s assets have appreciated sufficiently, the difference between the new partner’s inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.

Learning Objectives

• Determine the amount of a Section 754 basis step-up

• Know how to allocate the basis step-up to the partnership's assets

• Know how a partnership makes a Section 754 election and reports it to the IRS

Major Topics

• How and why a partnership makes a 754 election

• The effect of the 754 election when an interest in a partnership is sold or inherited

• How the 754 election applies when a partnership makes a distribution of property to one or more of its partners

• How to make the 754 basis adjustment

Designed For

Any Accounting and Finance Professional who wishes to understand the tax rules and economic opportunities associated with having a partnership make a Section 754 election

This virtual seminar is being offered through our partnership with Midwest State CPA Societies. You will launch from your MyOSCPA learning center day of and be prompted to enter in name and state society at time of entering.