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.
