This On-Demand subscription includes more that 100 curated courses covering a wide range of topics in accounting and auditing, tax, technology, and more. Access to the Anytime CPE subscription begins immediately upon purchase and is available for up to one year after purchase. Please review our Anytime CPE FAQs for more information. more info...
Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel?
If these questions perk your interest in becoming an Excel function expert, this course is right up your alley.
This past-paced course digs into some of the most powerful functions in Excel. Although, we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Functions like: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide examples files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level.
This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Apply formula creation best practices when developing spreadsheets
Use Excel functions to create better calculations in your spreadsheets
Select Excel functions to create advanced calculations
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to creating your spreadsheets?
This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function. You will learn to import data instead of manually entering it. Learn that you can use functions and formulas to build calculations that will eliminate the need to manually manipulate your data. Our goal is to make sure you have all the information needed to build reports without having to manually enter it every month.
You will learn techniques to use your data to build your reports. This will include building formulas that are flexible with your changing data. You will learn techniques to validate your report calculations so you can improve the accuracy of your reports. You will also learn how to quickly format reports and techniques that allow you to efficiently change the format. Lastly, you will learn how PivotTables can provide a more dynamic reporting option instead of using pre-defined report formats.
Obviously, we will be covering a lot of ground, so to enhance your learning experience all examples will be provided to each participant along with instructions. This will allow you to follow along and use as you apply your new knowledge to your spreadsheets.
This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Recall best practices when creating reports in Excel
Identify ways to reduce manual entries when creating reports in Excel
Recognize features that are more efficient for creating reports in Excel
Indicate how you can use PivotTables to provide more flexibility in Excel reports
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accurately. However, if you aren't aware of these new features, how can you use them?
This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities.
This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Identify features that allow you to create spreadsheets more efficiently
Select the features that you can use to build better spreadsheets
Recognize features and functions to enhance your spreadsheets
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics.
Objectives:
Be able to differentiate between the different types of business entities
Be able to determine if a business client is using the most tax efficient entity structure based on its business goals.
Surveys show that the average North American company completes its monthly financial statement closing in six days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper.
Objectives:
Gain ideas that will help your organization perform it's month-end closing faster, better and cheaper.
Excel is the #1 data analysis tool for accountants, yet many accountants have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis.This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make analyzing data an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features.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.
Objectives:
Understand the advantages of using PivotTables to analyze data from multiple dimensions.
Create a PivotTable using a step-by-step process that will analyze accounting data.
Use all PivotTable options to maximize your data analysis.
Create PivotCharts to present your data graphically for the most effective analysis.
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards.Most business professionals use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes more difficult to make strategic decisions based on rows and rows and columns and columns of data. You will learn how to add charts and eye-catching visuals with Power View, which will make your dashboards easily understood.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.
Objectives:
Create KPI dashboards
Make strategic decisions based on the dashboards you've created
Use various Excel tools to easily create even more meaningful KPI dashboards
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
This course will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth a thousand words." People tend to better understand the point when visuals are used. We will explore the many capabilities of presenting data without showing rows and rows or columns and columns of data. Help your audience visualize the meaning of the data, whether it is a trend, an exception, a distribution or a good vs. a bad relationship.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.
Objectives:
Create charts with ease
Customize specific elements of your charts
Choose which chart will work best in your situation
Use charting to visually communicate your data
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
In this course, we will focus on debugging and troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn methods to resolve issues when you receive errors. Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using Excel's built-in formulas? Then this class is for you!This session will also discuss Excel's nine built-in error-checking options and then demonstrate different approaches to error resolution. We will also review techniques to resolve rounding errors.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.
Objectives:
Create complex spreadsheets more quickly while maintaining accuracy
Apply advanced skills to build complex formulas
Troubleshoot complex formulas using various methods
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
This program addresses the most recent developments impacting taxpayers incurring research and experimentation costs. Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures.
Objectives:
identify recent changes affecting the deduction of research and experimental expenditures.
In this course, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? You will learn some powerful functions that will take your calculating power to the next level.
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.
Objectives:
Create complex amortization schedules
Use math functions to make SUM functions more accurate
Analyze data using the statistical functions
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
In this course, we will focus on the Logical, Information and Lookup and Reference functions. In the Logical function section, you will learn to perform logical tests using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup and Reference section, you will learn to use the various LOOKUP functions and the INDIRECT function. Excel has over 500 functions that are built in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute.
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.
Objectives:
Create complex lookup formulas
Use the INDIRECT function to speed worksheet creation
Use ERROR checking functions in calculations
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
In this course, we will focus on Text functions and Date and Time functions. Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date and Time function section, you will learn how to perform various date and time calculations.
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.
Objectives:
Create complex Text functions to separate text entries
Format cells using Text functions
Perform complex date and time calculations
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
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. 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. 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.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.
Objectives:
Use Defined Names to create formulas more efficiently
Create Excel Tables to improve spreadsheet accuracy
Utilize structured calculations in Excel Tables
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Before you can analyze data, you first must get the data. This course focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform). After this class, you will finally be able to get the data you need to perform data analysis.This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Differentiate between improper and proper data structure
Select the best way to import data into Excel
Identify ways to use Power Query to clean your data
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis.
This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features.
This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Determine the advantages of using PivotTables to analyze data from multiple dimensions
Apply the step-by-step process to create PivotTables
Choose the PivotTable options that best fit your needs
Use PivotCharts to present your data graphically for the most effective analysis
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel.
We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals, in order to make your dashboards easily understood.
This course focuses on using standard Excel features to create visuals. Although we will introduce new tools like Power BI Desktop, this course is NOT about using Power BI to create visuals.
This session is presented using Excel 2019. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Use dashboards to make strategic decisions
Create KPI dashboards that graphically represent your data
Use Excel tools to easily create meaningful KPI dashboards
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Data can be messy! In other words, it is not always clean and neat. Data comes from various sources like text files, Excel spreadsheets, databases, report files, etc. This is how most data analysis projects fail - the inability to get the correct data.
This class focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more.
This session is presented using Excel 2019. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Use Power Query to solve your data clean-up issues
Determine how Power Query allows you to get more data into Excel
Apply a one-click step to refresh your data
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations.When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations.This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Formulate worksheet calculations that use the Power Pivot data model
Create measures that provide a visual of the date of the data
Formulate calculated measures that calculate based upon the date of the filters
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Over the years, Excel has added MANY new features and functionality, yet most people still use it in the same way they first learned. Part of the reason is new features were added when the newest version was announced approximately every 3 years. The list was so extensive, making it difficult to learn what was new. Microsoft attempted to solve this for Office 365 customers by releasing new features more often, making it difficult to pinpoint the latest update.This class focuses on the specific added elements to Excel 2019 plus new functionality available to Office 365 users. Not only is this a great class to learn about what's new, it provides those who have not upgraded an opportunity to determine the value of upgrading or purchasing an Office 365 license.
Objectives:
Identify features that allow you to create spreadsheets more efficiently
Select the features that you can use to build better spreadsheet
Recognize features and functions to enhance your spreadsheets
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
The importance of Defined Names and Excel Tables is detailed in our course "Excel - Two Must Know Features: Defined Names & Tables." Once you understand these two features, how can you use them to build advanced spreadsheets?This course is designed to demonstrate how you can use these features to build better spreadsheets that are easier to read, easier to update and more accurate. Learn about the INDIRECT function and how to use it with Defined Names to build a summary table. You will also learn the importance of Consistent Column Calculations and how tables can help. We will demonstrate the use of Structured Table References, as this is the foundation for using the advanced data analytics.This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Use the INDIRECT function and Defined Names to build a summary table
Determine the importance of having Consistent Column Calculations
Use Excel Tables to build Consistent Column Calculations
Build formulas that use Structured Tables References
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Formatting Excel spreadsheets to look their best can be a tedious task. From deciding which fonts to use to cell formatting to multiple sheets to printing to distribution, these factors can take considerable valuable time. This class is designed to help you efficiently format spreadsheets, so you can spend time on more profitable tasks like analyzing data.Learn to format multiple sheets at the same time as well as use Cell Styles to quickly format cells and ranges. Learn how to create and use templates that are pre-formatted. We will also review print options.This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Objectives:
Identify all the formatting options
Select formatting features / tools that help you format more efficiently
Recognize options that allow you to print your spreadsheets
Identify ways to use templates for create spreadsheets more efficiently
Instructor: Bryan L. Smith, CPA.CITP, CISA
Fields of Study: Computer Software & Applications more info...
Internal controls are applied within an organization to satisfy objectives related to operations, compliance, and financial reporting. This course provides practical analysis and tips for how a reporting entity can manage financial reporting risk in an effective and efficient way. This course also differentiates the auditor's responsibilities for internal controls under Sarbanes Oxley, Government Auditing Standards, and Single Audit requirements.
Objectives:
Discuss the evolution of internal control through the decades
Describe the revamped 2013 COSO Internal Control - Integrated Framework, including how the various components and principles interrelate to form a strong system of internal control over reliable financial reporting
Identify special considerations for internal control in a smaller-entity environment
Explain important varying audit considerations
Who investigates tax crimes and how are tax crimes prosecuted?Considered the "World's Finest Financial Investigators", the IRS-Criminal Investigation (IRS-CI) has sole jurisdiction in tax crimes and boasts a greater than 90% conviction rate. This agency was responsible for Al Capone going to federal prison and 90 years later they continue to investigate tax crimes such as tax evasion, filing false tax returns, and unpaid employment taxes.The course discusses how IRS-CI finds tax cases to prosecute, what happens during the course of the investigation, what techniques are used to prove tax crimes, what federal criminal statutes are commonly used, how IRS-CI evaluates an investigation, and the expected consequences of a successful prosecution.
Objectives:
Understand the role of IRS-Criminal Investigation (IRS-CI) in the IRS mission
Learn how IRS-CI finds and evaluates investigations for prosecution potential
Understand the two ways that IRS-CI can investigate tax crimes
Know the tools that IRS-CI uses in investigating potential criminal violations
Explain the common criminal statutes used to prosecute criminal tax violations
Learn the approval process for a criminal tax investigation
Understand the expected consequences of defendant in a successful criminal tax prosecution
Discuss case studies of various criminal prosecutions
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel.
Objectives:
Define the elements of negligence, the common law cause of action.
Explain what constitutes reasonable practitioner behavior with reference to practice standards and common law.
Ascertain how to avoid common pitfalls that could lead to the practitioner being sued.
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel.
Objectives:
Understand the factors that create an environment for fraud to easily occur.
Identify areas where there could be an inadvertent failure to separate duties.
Ascertain the proper role of an external auditor and identify areas where independence can be compromised.
This course focuses on how to integrate independence and avoid conflicts of interest in situations accounting professionals face daily. Participants will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action. As part of this course, we also walk through real-world examples of individuals and companies faced with these dilemmas.
Objectives:
Have the ability to define independence as promulgated by the AICPA Code of Professional Conduct and understand its importance to the CPA.
Be able to ascertain situations which could threaten a CPA's independence.
Understand how conflicts of interest and the use of contingency fees can subvert independence.
This course focuses on how to integrate integrity and objectivity in situations accounting professionals face daily. The participant will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action! As part of this course, we will also walk through real world examples of individuals and companies faced with these dilemmas.
Objectives:
Define integrity and objectivity as promulgated by the AICPA Code of Professional Conduct and understand its importance to the CPA.
Have the ability to identify situations where the CPA may be susceptible to subordinating his/her judgment to a client or employer.
Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax professionals.
Objectives:
Determine whether a LKE can be used to defer taxes upon the sale of real property.
Know when it is appropriate to use a QI in effecting a LKE.
Define a DST and how it can be used in obtaining replacement property on a timely basis.
Become knowledgeable about ways to appropriately use the LKE structure in unusual situations.
Please join us for a introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. This course is ideal for CPAs, CFPs, EAs and other tax preparers.
Objectives:
Identify how the federal income tax differs from other types of federal taxes.
Determine the steps in computing a taxpayer's federal income tax liability.
Differentiate tax consequences for terms commonly used for the federal income tax, such as "adjusted gross income," "qualifying child," "tax credits," "filing status," and "kiddie tax."
Recognize how an individual's standard deduction is determined.
Explain differences in the tax for ordinary income, capital gains, and qualified dividend income.
Discuss the difference between the cash and accrual method, and the correct period in which taxpayers must recognize income and/or deductions.
Identify deadlines for filing income tax returns and estimated taxes and how to obtain an extension of time for filing a return
Many self-employed or sole proprietors find themselves having to navigate Schedule C in reporting business income. While this attachment to Form 1040 seems straightforward on the surface, there are many traps for the unwary. This course is ideal for CPAs, EAs, or other tax professionals.
Objectives:
Identify the appropriate taxpayers who should be filing Schedule C.
Discuss the difference between the cash and accrual method, and the correct period in which taxpayers must recognize income and/or deductions.
Develop a working knowledge of related issues, such as reporting the deduction of self-employed health insurance, employment taxes, home office deductions, and proper reporting of employee/independent contractor salaries. and retirement contributions.
Discuss types of typical deductions, such as advertising, utilities, supplies, etc.
Determine the methods of deducting the cost of a company car.
Be able to apply the rules, such as Section 179 or bonus depreciation, which permit the immediate expensing of some or all of the cost of certain assets.
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.
Objectives:
Evaluate lesser-known but powerful Excel functions
Categorize your level of intellectual curiosity as you unearth ways to utilize Excel in manners you may not have previously considered
Assess your mindset of professional skepticism that helps you explore the edges of Excel's capabilities
Instructor: Chris Harper, CPA
Fields of Study: Computer Software & Applications more info...
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed.
Objectives:
Apply guidance of the "big picture" of qualified deductible expenses and strategies and guidance on what to do and when to do it
If you have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 10 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help.Once you have studied ethics using real world cases, you'll never want to do it any other way.
Objectives:Prepare for possible ethical conflicts in your career by discussing real life cases.
The AICPA Code of Professional Conduct makes it clear that workplace harassment and discrimination is unacceptable, but gives little further guidance. Other behavior standards can help us fill the gaps. This session will discuss cases involving ethical issues relating to diversity, including age discrimination, ethnicity, sexually hostile work environments, and gender identity.
Objectives:
Understand what the AICPA Code of Professional Conduct has to say about harassment and discrimination and look at real world cases.
In most organizations, strategic planning and budgeting are separate processes, making them out of alignment from their inception. This webinar explores a practical "real world" planning approach that aligns spending to long-term strategy, creates a culture of accountability and responsibility, and might actually be fun when everyone gets on board. The result will create a model for your organization's future growth and profitability.
Objectives:
Make your organization's budgets and strategic plan reflect the same vision of reality
Choose the appropriate model for your organization's future growth and profitability
Instructor: Jay Giannantonio
Fields of Study: Business Management and Organization more info...
Senior management yearns to report positive news and impressive financial results that will please investors, bankers and drive value higher. While most companies act ethically and follow prescribed accounting rules, some take advantage of gray areas in the rules or ignore them altogether in order to portray their financial results in a misleading way.
This session will discuss some common financial statement shenanigans to help prevent them from fooling you.
Objectives:
Identify common ways that financial statement fraud fools users
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message.
Learn to motivate them to action. Come hear a veteran CFO tell you how.
Objectives:
Understand how to connect with your stakeholders who do not have a financial background.
Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove "reasonable cause".
This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face, and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties.
Objectives:
Identify situations where penalties can be imposed
Utilize techniques for preventing or reducing any penalty assessments
Ascertain when the First Time Abatement can be used
Obtain a working knowledge of the procedure governing the request for refund
Unless you expect your organization to be stable in the short, medium and long term, you need to understand how to create long-term balance sheet and cash flow projections. Growing organizations must know whether they will have the resources to execute their business plan. Struggling organizations need to know if they will have the cash to survive. This session will increase your organization's ability to see its future and increase the confidence that your CEO, Board and bank have in you.
Objectives:
Understand how to create a projected Balance Sheet and Statement of Cash Flow
With more than 30 years working with entrepreneurs and their employees, Sherré has been able to identify five wishful thinking mindsets and six fearful thinking mindsets that hold individuals back from reaching their goals and achieving their desired level of success in life and at work.
Based on her nationally acclaimed book, Me, Myself & Inc., DREAM WIDE AWAKE will help you shift your thinking from can't imagine to can-do, inspiring and motivating you to take action and shift from daydreaming to dream doing!
Objectives:
Understand issues that may be limiting your ability to excel and achieve your goals.
Instructor: Sherre L. DeMao, CGS
Fields of Study: Business Management and Organization more info...
A well-organized chart of accounts supports robust responsibility reporting, makes it easy to answer "what if?" questions and helps eliminate data entry errors. However, many organizations cling to the primitive practices of a half-century ago that impose barriers to developing budgets, holding people accountable, gathering useful data and keeping errors from creeping into their financial statements.
Best practices today look little like the examples you may have seen in business school. If you sense that your general ledger could do far more, this session will show you how to fix your problems
Objectives:
Understand current chart of accounts best practices and how to fix the current mess that you may have.
With each new crisis, surviving organizations revise their risk management plans, often modeling situations which look like the one just past. Whatever crisis troubles your organization next, it is not likely to be another pandemic, but may resemble some other crisis from the distant past.
Research shows that top performing organizations do no better than their mediocre-performing peers at predicting the next crisis. However, because they have plans in place to handle one possible risk, they are better prepared when a different crisis happens as a result of having important elements of a solution in place. Often well-prepared organizations actually end up better off because the crisis occurred.
Objectives:
Recall the risk management lessons from the COVID pandemic
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security.
Objectives:Recall the primary methods of online fraud
Identify the types of weaknesses that can be exploited by those undertaking electronically based frauds
Recognize specific internal control measures that can help to reduce these types of fraud activities.
Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization.
Objectives:
Distinguish key internal control concepts, including the four types of internal control: preventive, detective, deterrent and compensating
Determine how each control becomes a piece of an overall internal control structure
Identify both organization-wide measures as well as more segmented controls and how these must co-exist
Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks.
Objectives:
Recognize external fraud
Identify control issues that can give rise to external fraud occurrences
Recall ways to reduce external fraud risk
Fraud in the workplace is not new, however, statistics show that the number of instances of internally actuated fraud schemes is increasing. Additionally, because of all the changes that have come about due to recent upheaval, fraud risk is at an all-time high. This session starts by reviewing the many reasons that fraud occurs; it then looks at ways to detect internal fraud and finally explores control measures that can help to reduce fraud risk. Those that take the class will learn just how invasive and damaging internal fraud can be. They will also know ways to detect and thwart fraudulent activity.
Objectives:
Identify reasons employees and others internal to an organization choose to undertake fraudulent acts
Recall the types of control measures that work best as entities strive to mitigate fraud risk
Recognize specific internal control measures that can help to reduce fraud activities
Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending this session.
Objectives:
Control design basics
Areas or segments of an enterprise to control
Controls to reduce risk
Controls to drive operations
Did you know that simply by utilizing the built-in headings found under Styles in Microsoft Word you can create an automatic table of contents that can be updated in a matter of seconds if the body of the document changes? Did you know that Word can be used to open, edit, and re-save PDF documents? How about the fact that by using the Insert Caption tool in conjunction with the Cross-Reference feature, users can rid themselves of the need to manually renumber figures, tables or illustrations and will not even need to update references to these in the document text? This material shows tools and features that are easy to understand and use, will save time, and add consistency to documents. Participants in this session will come away knowing the power of Microsoft Word; this knowledge will benefit them greatly!
Objectives:
Recognize ways to improve Word documents and presentations
Recall three benefits of using Word Styles in documents
Identify features hidden within the application that people should know about
Instructor: Karl Egnatoff
Fields of Study: Computer Software & Applications more info...
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security.
Objectives:
Identify reasons that employees and others that are internal to an organization choose to undertake fraudulent acts
Recall the factors that make smaller organizations attractive to those considering fraud
Recognize specific internal control measures that can help to reduce fraud activities executed against smaller and medium sized companies
For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world.
Objectives:
Recall the effects of the rapid move to distance employees
Indicate the factors that make supporting and controlling telecommuters challenging, and
Identify the types of controls to consider for the new geographically dispersed work environment
We have all heard the statement that it is the people that work at a company that gives it value. It is, sometimes and unfortunately, also the people that provide fraudsters with an entry point into an organization that can lead to hardship. This is even more true now because cyber-attacks on both organization and individuals have increased notably. Many highly publicized corporate hacking events are successful, at least in part, because an individual was targeted. In this session, we look the types of fraud that take aim at individuals with a special focus on the growth of cyber-attacks. We then discuss measures that can be put forth to help employees protect both themselves and the organization.
Objectives:
Recall fraud methods that affect individuals
Identify how the connection between an employee and an employer can be exploited
Indicate ways to reduce this type of fraud risk.
The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information.
Objectives:
Identify some of the security risks that affect electronic information
Select cloud storage providers by employing vetting process
Recognize the steps to effectively set up and control cloud storage
Recall ways to add security to individual electronic documents as well as to storage areas that must be controlled
Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session.
Objectives:
Identify important components and sub-components of an Internal Control System
Recognize how the control environment can help or hinder the operation of control measures and help or hinder operational effectiveness
Recall important steps that an organization can undertake, specifically related to control development that can drive the methodologies of the entity
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session!
Objectives:
List and use powerful but often hidden tools available in Excel
Discuss some of the new features built into the spreadsheet application
Work in a more efficient manner because of keyboard and ribbon-based tools
Instructor: Karl Egnatoff
Fields of Study: Computer Software & Applications more info...
Everyone knows that Excel is the most widely used spreadsheet application in the world today. However, because it is ever-changing, many users are unable to keep up with the latest features and capabilities of this ubiquitous application. In this session, we look at some of the most helpful new features and tools that have been added to both the Desktop version of Excel and the Web version. Content like this is valuable to anyone that regularly works with Excel - We hope you will attend!
Objectives:
Recall helpful new features that will help users work more efficiently
Recognize how new functions in the Excel Function Library can be beneficial
Instructor: Karl Egnatoff
Fields of Study: Computer Software & Applications more info...
Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise.
Objectives:
Distinguish reasons that employees and others that are internal to an organization choose to undertake fraudulent acts
Determine the ways that fraud activities are changing as business methods change
Differentiate between the types of control measures that work best as entities strive to mitigate fraud risk
Select specific internal control measures that reduce fraud activities
Identify how anti-fraud measures add security to all segments and aspects of a business organization
Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise.
Objectives:
Distinguish reasons that employees and others that are internal to an organization choose to undertake fraudulent acts
Determine the ways that fraud activities are changing as business methods change
Differentiate between the types of control measures that work best as entities strive to mitigate fraud risk
Select specific internal control measures that reduce fraud activities
Identify how anti-fraud measures add security to all segments and aspects of a business organization
Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system.
Objectives:
Determine the steps needed to implement a developed system of internal controls
Apply steps to build control measure schedules that function weekly, monthly, quarterly, and yearly, and that are designed to test and monitor the internal control structure of an organization
Analyze developed control measures to make sure they are working properly
Determine why there is a need to update existing controls to keep them viable as business operations change
Identify methods that can be used to communicate policy and procedure changes to those that are affected by these changes
Many organizations are successful as they create a system of internal controls, however some fail to properly implement the measures that are established. Moreover, entities regularly neglect the important process of testing, monitoring, and updating control procedures, which weakens the entire internal control structure. This session provides an overview of control creation methods and discusses ways to successfully implement policies and procedures. Additionally, it includes an array of control maintenance checklists that participants can take and adapt to their organization as they work to improve policies and procedures. Finally, it provides an understanding of the need for dynamic, fluid controls that adapt to changes in business tools and methods. Participants that take this course will have a strengthened ability to implement and maintain an internal control system.
Objectives:
Determine the steps needed to implement a developed system of internal controls
Apply steps to build control measure schedules that function weekly, monthly, quarterly, and yearly, and that are designed to test and monitor the internal control structure of an organization
Analyze developed control measures to make sure they are working properly
Determine why there is a need to update existing controls to keep them viable as business operations change
Identify methods that can be used to communicate policy and procedure changes to those that are affected by these changes
A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session.
Objectives:
Identify the components of a control system
Identify the ways that risk affects all business activities
Use concepts such as risk appetite and risk tolerance to properly create controls
Apply the concepts set forth in the COSO framework that relate to the control environment
Choose the necessary steps to increase the quality of control development activities
A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session.
Objectives:
Identify the components of a control system
Identify the ways that risk affects all business activities
Use concepts such as risk appetite and risk tolerance to properly create controls
Apply the concepts set forth in the COSO framework that relate to the control environment
Choose the necessary steps to increase the quality of control development activities
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course.
Objectives:
Understand the many keyboard shortcuts that are available to save time and effort
Use Excel Templates, Styles, and Themes to add uniformity to workbooks they design or edit
Design custom number and date formats to meet their specific needs
Add security to the workbooks they use. This includes workbook encryption, and the use of sheet level, range level and cell level security features
Understand formula building conventions such as order of operation
Troubleshoot formulas that are not working properly
Work with functions in the function library to create powerful formulas
Instructor: Karl Egnatoff
Fields of Study: Computer Software & Applications more info...
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course.
Objectives:
Understand the many keyboard shortcuts that are available to save time and effort
Use Excel Templates, Styles, and Themes to add uniformity to workbooks they design or edit
Design custom number and date formats to meet their specific needs
Add security to the workbooks they use. This includes workbook encryption, and the use of sheet level, range level and cell level security features
Understand formula building conventions such as order of operation
Troubleshoot formulas that are not working properly
Work with functions in the function library to create powerful formulas
Instructor: Karl Egnatoff
Fields of Study: Computer Software & Applications more info...
Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types.
Objectives:
Distinguish key internal control concepts, including the four types of internal control: preventive, detective, deterrent and compensating
Identify ways to create strong internal controls
Identify reasons that control measures are required, such as to deter fraud or reduce operational inefficiencies
Determine why the control environment is important as implementation efforts are ongoing
Apply COSO Framework concepts to three segments of an organization's technology infrastructure that must be controlled.
Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types.
Objectives:
Distinguish key internal control concepts, including the four types of internal control: preventive, detective, deterrent and compensating
Identify ways to create strong internal controls
Identify reasons that control measures are required, such as to deter fraud or reduce operational inefficiencies
Determine why the control environment is important as implementation efforts are ongoing
Apply COSO Framework concepts to three segments of an organization's technology infrastructure that must be controlled.
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences.
Objectives:
Develop an outline of presentation topics
Draft talking points for a media interview
Edit your written work for clarity and length
Adapt content depth and delivery as appropriate for the intended audience
Recognize best practices for both written and verbal formats
Avoid plagiarism by providing appropriate credit for sourced material
Enhance audience engagement
Instructor: Chris Harper
Fields of Study: Communications and Marketing more info...
This course will allow you to get reacquainted with the statement of cash flows. We will refresher your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements.
Objectives:
Recall major elements of the statement of cash flows
Identify the two broad methods for preparing the statement of cash flows
Perform certain calculations for preparing both the indirect and direct statements of cash flows
Use the statement of cash flows as part of financial statement analysis
This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts.
Objectives:
Determine what factors allowed certain frauds to occur
Identify what internal controls may have prevented the frauds
Consider application of these lessons to circumstances you encounter in your professional endeavors
Fraud Trends - Applying Real-life Lessons to Small- and Mid-Size Entities will focus on real-life and practical examples of fraud in smaller- and mid-size environments, including nonprofits. Fraud involves an intentional act to deceive, which may result in material misstatement in the financial statements due to fraudulent financial reporting or misappropriation of assets. Management's responsibility is to design, implement, maintain and monitor a system of internal control to prevent, or detect and correct, fraud.
Objectives:
Identify the cause and impact on real-life fraud cases
Determine what to be alert for in an audit to identify fraud potential
Today's CPAs can expect their prospects, clients, referral partners, and candidates to research them on LinkedIn. The good news is that you can leverage LinkedIn to craft a digital presence that demonstrates your expertise, showcases your personal brand, and aligns with your values. Learn how to create a LinkedIn profile that is not just a resume but a valuable marketing tool for your CPA business.
Objectives:
Make immediate improvements to your LinkedIn profile
Position yourself to attract clients, prospects, or candidates (instead of your current resume version)
Showcase your credentials, education, experience, and personal brand
Instructor: Sandra Long
Fields of Study: Communications and Marketing more info...
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.
Objectives:
Make immediate improvements to your LinkedIn profile
Expand and upgrade your career network on LinkedIn
Find and develop new career and leadership opportunities with LinkedIn
Instructor: Sandra Long
Fields of Study: Personal Development more info...
This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing nonaudit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling and single audit reporting.
Objectives:
Identity the conceptual framework for making independence determinations
Identify independence threats related to preparing financial statements and accounting records
Identify specific non-audit services that would and would not impair independence
Complete proper audit documentation to support adequate consideration of auditor independence
Identify what a single audit entails
Identify the basic audit requirements in a Uniform Guidance compliance audit
Identify key auditee and auditor responsibilities in the compliance audit of federal awards
Recognize key consideration related to the auditor's responsibilities regarding testing and reporting on compliance under the Uniform Guidance
Instructor: Adelina Burke, CPA
Fields of Study: Auditing (Governmental) more info...
This course will explore the ethical principles included in the Code of Professional Conduct that address emerging practice issues created by new technologies. Consider the how technologies could impact audit quality and the integrity of the financial systems and whether they create a need for CPAs to change their skill sets to address those challenges. Discuss the changes being proposed by the profession to address emerging ethics challenges. Consider whether there are new ethical challenges created by the data related to privacy, security, and its application.
Objectives:
Recognize the ethical challenges created by emerging technologies such as artificial intelligence and the foundational principles included in the Code of Professional Standards.
Recall the ethical imperative to remain competent in this new environment in order to serve in the public interest.
Consider whether current ethics standards address all of the challenges associated with data privacy and security.
The course will cover the basic requirements for performing preparation, compilation and review engagements under the current SSARS standards including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. The session will highlight common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a firm's peer review. The discussion will highlight the key issues to consider during your upcoming SSARS engagements and will incorporate quality control recommendations and tips for performing high-quality SSARS engagements.
Objectives:
Recognize the foundational principles of SSARS.
Identify the new requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.
Indicate processes to achieve high-quality SSARS engagements.
This comprehensive course will highlight the impact of the current financial reporting environment on financial statement reporting, evaluate recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board, recall other financial reporting frameworks, and key implementation challenges and identify emerging financial reporting trends.
Objectives:
Identify the most recent FASB accounting and financial statement reporting standards.
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients.
Objectives:After attending this presentation, you will be able to...
Identify the basics of ChatGPT and artificial intelligence chatbot technologies
Use ChatGPT to automate tasks and improve efficiency in the accounting profession
Utilize ChatGPT to improve accuracy and reduce the risk of mistakes in financial records
Supply real-time support to clients using ChatGPT
Generate financial reports using ChatGPT
Use ChatGPT to automate tax return preparation and financial planning
Deliver guidance on financial decision making using ChatGPT
Instructor: Garret Wasny, MA, CMC, CITP/FIBP
Fields of Study: Information Technology more info...
This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks.
Objectives:After attending this presentation you will be able to...
Identify the fundamental features and functionalities of ChatGPT in an accounting context.
Apply Custom Instructions to tailor ChatGPT's responses for specific financial scenarios.
Analyze financial statements, news releases, and other relevant data using ChatGPT.
Explore and identify business opportunities using hyper-local and sectoral analysis techniques.
Utilize Advanced Data Analysis for financial comparisons, and capital project evaluations.
Evaluate assets, space, and user interfaces using image analysis with ChatGPT.
Implement voice interaction with ChatGPT to enhance user experience and accessibility in financial tasks.
Instructor: Garrett Wasny, MA, CMC, CITP/FIBP
Fields of Study: Information Technology more info...
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties.
Objectives:After attending this presentation, you will be able to...
Identify the authority of the IRS to assess penalties.
Recognize the common types of penalties that can be abated.
Develop a plan to request penalty abatement.
Review real examples of successful penalty abatement.
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door.
Objectives:After attending this presentation you will be able to...
Identify the authority and regulations of the IRS.
CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations.
Objectives:After attending this presentation you will be able to...
Determine the common weaknesses in a criminal tax investigation.
Identify the key documents to review (In a sea of thousands of documents).
Select questions for your client to use in court proceedings.
Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners.
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance.
Objectives:After attending this presentation, you will be able to...
Utilize vertical analysis by converting each financial statement line item into a percentage of a base figure, facilitating effective comparisons across different companies and identifying significant financial trends.
Calculate horizontal analysis for review of financial data over multiple periods, to identify notable changes and trends that reflect a company's growth and performance trajectory.
Calculate and interpret key financial ratios, assessing aspects such as profitability, liquidity, and solvency. Gain insights into management performance and business viability, leveraging this analysis to make informed decisions based on real-world financial data.
Financial statement forecasting is essential for predicting a company's future financial health, guiding strategic decisions, and attracting investments. By analyzing historical data, market trends, and assumptions, businesses can anticipate risks and opportunities, enabling effective planning, resource allocation, and long-term stability and growth.
Objectives:After attending this presentation, you will be able to...
Formulate the ability to project future income, expenses, and resources using historical data and market trends for strategic planning and investment decisions.
Calculate future earnings and financial positions to evaluate growth potential, solvency, and capital structure for effective budgeting and risk management.
Apply forecasting insights to enhance resource allocation, manage risks, and attract investments, supporting long-term financial stability and growth
Financial statements prepared for stockholders and external users follow Generally Accepted Accounting Principles (GAAP), while tax returns adhere to the Internal Revenue Code (IRC). These frameworks differ in recognizing profitability, influencing reported income significantly. Companies often aim to minimize taxable income within legal bounds, while maintaining compliance with both financial reporting and tax regulations.
Objectives:After attending this presentation, you will be able to...
Recognize variations in income recognition.
Recognize deductible expenses between GAAP and IRC affect reported profitability and tax liabilities.
Compute deferred tax assets and liabilities, learning their impact on financial statements and future tax obligations.
Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts.
Objectives:After attending this presentation, you will be able to...
Identify taxation nuances that are important but difficult for non-tax professionals to understand.
Apply techniques for educating clients regarding taxation.
Distinguish methods for simplifying and communicating complicated tax concepts.
This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control.
Objectives:After attending this presentation, you will be able to...
This course introduces professionals to the fundamentals of individual tax preparation. Participants will learn the essentials of Form 1040, including filing requirements, income reporting, and deductions. The session will also cover preparer responsibilities, due diligence, and taxpayer rights under Circular 230. By the end, attendees will have a solid understanding of the foundation of personal tax returns.
This course provides a focused analysis of the individual and small business provisions in H.R.1, "One Big Beautiful Bill." Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision, to enhanced bonus depreciation - designed to inform planning strategies and compliance for the 2025 tax year and beyond.
This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E, and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities.
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future.
Objectives:After attending this presentation, you will be able to...
Recognize changes that are occurring because of AI.
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future.
Objectives:After attending this presentation, you will be able to...
Recognize changes that are occurring because of AI.
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible.
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles.
Objectives:After attending this presentation, you will be able to...
Apply advanced Excel auditing tools, such as Trace Precedents, Trace Dependents, and the Error Checking feature, to effectively identify and rectify complex errors in financial spreadsheets.
Analyze and interpret common error messages and anomalies in Excel, enabling the ability to diagnose underlying issues in spreadsheet formulas and data inputs.
Distinguish between different types of Excel errors, including formula errors, reference errors, and logical errors, to implement targeted corrective actions for enhanced spreadsheet accuracy and reliability.
U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling.
As the digital asset market continues to mature, more taxpayers may be contemplating blessing their favorite charitable organizations with gifts of cryptocurrency. Beneficiaries unfamiliar with digital assets may find it challenging to properly report any of these types of donations. Likewise, taxpayers will need to ensure that they properly value and substantiate any contributions or potentially risk their charitable deductions being denied. This course will provide a brief overview of digital assets. This will be followed by a discussion of the rules regarding the documentation required when claiming a charitable contribution of digital assets. This course will also cover recent IRS publications and cases discussing taxpayers whose deductions of digital assets charitable gifts was scrutinized.
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations.
Objectives:After attending this presentation, you will be able to...
Identify the top general competencies most valued by hiring executives for CFO positions
Recognize the shift from compliance-focused to forward-looking financial skills in CFO requirements
List specific sub-competencies that rank highest in the research findings
Compare traditional CPA skills with modern CFO competency requirements
Identify actionable steps from the report's recommendations for career development
The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes, and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives, and audit committee chairs, participants will explore how artificial intelligence, blockchain, and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment.
Objectives:After attending this presentation, you will be able to...
Implement AI and blockchain tools to enhance audit quality
Develop talent retention strategies for technology-savvy teams
Navigate regulatory sandboxes for safe technology adoption
Expand services to include ESG and real-time assurance
The accounting profession stands at a critical inflection point where artificial intelligence and emerging technologies are reshaping how firms operate, serve clients, and compete in the marketplace. This course, based on the 2025 CPA Firm Tech Report, provides expert guidance on overcoming the five key challenges that prevent firms from successfully adopting transformative technologies: decision paralysis from overwhelming choices, leadership resistance to change, difficulty proving ROI, growing cybersecurity risks, and critical skills gaps. Through real-world case studies and insights from industry leaders, participants will learn practical strategies for evaluating AI solutions, implementing change management frameworks, and building a technology-forward culture that enhances both efficiency and client value.
Objectives:After attending this presentation, you will be able to...
Identify and address the five key barriers preventing technology adoption in their firm
Apply the CPA Firm Digital Maturity Model to assess their organization's readiness for transformation
Evaluate AI tools and vendors using strategic fit criteria appropriate for their firm size
Implement change management strategies to overcome leadership and staff resistance
Develop metrics beyond traditional ROI to measure technology implementation success
In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it.
Objectives:After attending this presentation, you will be able to...
Identify the top factors that drive retention decisions
The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts.
Objectives:After attending this presentation, you will be able to...
Analyze your firm's current structure against future workforce predictions
Design an inverted pentagon framework tailored to your firm's needs
Implement precision hiring strategies for specialized roles
Develop accelerated training programs to move staff to higher-value work
Create effective knowledge transfer systems including mentorship and rotation
Leverage technology for personalized professional development
Build retention strategies for specialized professionals and lateral hires
Evaluate pricing models that support investment in talent and technology
Identify barriers preventing staff progression and develop solutions
Construct a transformation roadmap with measurable milestones
Instructor: Leeland Rogers
Fields of Study: Business Management and Organization more info...
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House.
Objectives:After attending this presentation, you will be able to...
Analyze recent court cases and Treasury publications affecting individuals and business entities.
Recognize recent changes to IRS procedure.
Identify recently issued tax court opinions and their implications to taxpayers.
Assess the status of upcoming tax legislation and how it might affect clients.
In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort.
Objectives:After attending this presentation, you will be able to...
Identify key features of Copilot in Excel and their applications in data analysis.
Distinguish between traditional Excel workflows and AI-enhanced capabilities.
Select appropriate AI-driven tools within Excel to streamline specific tasks.
Instructor: Bryan Smith
Fields of Study: Computer Software & Applications more info...
There has never been a greater opportunity to leverage technology tools to automate various aspects of 1040 tax preparation. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your core 1040 tax prep software. You will learn how to leverage AI to automate the collection and organization of client source documents, enhance the engagement management process and add value to your 1040 service through AI enhanced 1040 advisory services. This course will separate the hype from reality about AI and how it can be used in 1040 tax preparation.
Objectives:After attending this presentation, you will be able to...
Recognize specific ways to leverage AI technology in your 1040 tax preparation serves.
Identify specific AI tools that can be leveraged to automate and enhance 1040 tax preparation services.
This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Objectives:After attending this presentation you will be able to...
Identify minimum understanding and documentation requirements if the auditor does not intend to rely on internal controls.
Recognize internal controls of less-sophisticated, small-to-medium sized audit clients.
Utilize identified internal controls for an efficient, risk-based approach to audits conducted in accordance with generally accepted auditing standards.
Participants will learn how to interpret the most common IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. It provides professionals with knowledge and strategies needed to handle the most common notices including audit requests, collections & return inquiries as well as error notices. Focusing on best practices to ensure compliance and avoiding penalties or escalation.
Objectives:After attending this presentation, you will be able to...
Identify and interpret the most common IRS letters, including general notices, audit requests, collections, return inquiries, and error notices.
Recall IRS deadlines and the importance of timely and accurate responses.
Apply effective communication strategies when corresponding with the IRS.
Proactively address IRS concerns to avoid escalation and penalties.
Ensure compliance with IRS requirements when responding to correspondence.
Assess common issues that arise from IRS letters and develop resolution strategies.
Advise clients on their rights and responsibilities when dealing with IRS correspondence.
Implement documentation and tracking practices to manage IRS responses effectively.
We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling.
Objectives:After attending this presentation, you will be able to...
Analyze the various ways that data can be misleading.
Recognize that data interpretation is affected by many factors.
Identify how these factors can lead to pitfalls in interpretation.
This workshop, framed through an ethical lens, is offered to empower women who wish to consider the privileges, responsibilities, and challenges of holding leadership positions.
Despite advances, women are significantly underrepresented in the workplace. In addition to external societal barriers for which many women are held back, there are many internal messages that sabotage the move into leadership. We will examine common beliefs ("I should be nice," "I am an imposter", etc.) and behaviors that can hold women back as well as offer suggestions for moving forward.
Objectives:After attending this presentation, you will be able to...
Recognize the relationship of ethics to leadership.
Identify challenges women face and suggestions for minimizing them.
Indicate suggestions for women to overcome beliefs and barriers that are obstacles to leadership.
Recognize skills of assertive communication.
Select ways to give respectful feedback and handle receiving negative feedback.
