CPE Catalog & Events

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.

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.

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.

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.

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.

Are you self-taught on Excel?Have you ever wondered if you really know how to use Excel?Do you want to build a great foundation for using Excel?Are you new to using Excel?If you answered YES to any of these questions, this is for you.This course is designed to start with the basics of using Excel from the interface to the structure to data entry to formula basics. Whether you're a beginner or an intermediate user, you will gain valuable foundational knowledge for using Excel.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.

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.

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.

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.

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.

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.

This CPE course is included in the comprehensive Not-for-Profit Certificate I Program. It can also be purchased individually or as a part of the Not-for-Profit Accounting and Financial Reporting track. To achieve financial sustainability, NFPs diversify their revenue streams. Funding sources may include a mix of contributions, grants, awards and sponsorships, and earned income from the sale of goods or services. Under GAAP, these transactions are classified as contributions or exchange transactions, or a combination of both. Some exchange transactions take the form of agency arrangements when the NFP has little discretion over the use of the assets that it receives. Your ability to differentiate between these types of transactions is vital to successful preparation of financial statements in the NFP reporting environment. This on-demand, nteractive CPE course provides real-world examples to help you understand how to distinguish contributions from exchange transactions. You will also learn about basic financial statement presentation and disclosures related to these transactions. Note: As of August 1, 2018, the content of this course has been significantly updated to reflect implementation of FASB Accounting Standards Updates (ASUs) effective for most not-for-profit entities for their next financial reporting period, including those related to financial statement presentation (ASU 2016-14) and revenue recognition (ASU 2014-09 and ASU 2018-08). f you started Not-for-Profit Certificate I prior to July 31, but did not complete it, click here to find out how this and related course updates affect you. If you completed the program prior to July 31 and would like to retake only those courses with significant updates for new standards, click here to learn about the Certificate I Update Pack.

This CPE course can be purchased individually or as part of the Risk Management and Insurance Planning Certificate Program. Executive and equity compensation plans generally form the foundation of the personal financial plans of executives and key employees. A true specialty for the personal financial planner, executive compensation planning requires a mastery of several subject areas, allowing the executive to navigate through a myriad of compensation options, including: Traditional bonuses Supplemental retirement plans Stocks Other pseudo ownership incentives In this audiovisual CPE course, Tom Tillery will explain the various types of employment agreements and compensation arrangements, as well as their income tax implications, for your clients. This course explores these compensation choices and reviews how each option can affect the client's personal financial plan. Finally, this course looks at deferred compensation, a challenging area of personal financial planning. Once you complete this course, you will have an awareness of the regulatory doctrines and prohibitions to provide your clients with reasoned advice in this critical planning area.

This CPE course can be purchased individually, or as a part of the Audit Staff Essentials - Experienced In-Charge/Senior training bundle. Deferred income taxes can be difficult because of the client estimates and management assumptions involved. Many staff members shy away from these tasks, but this course will help. Learn how to plan and perform test work surrounding deferred income taxes, tax provisions, and valuation allowances.

This CPE course can be purchased individually, or as a part of the Audit Staff Essentials - Experienced In-Charge/Senior training bundle. Foundations Gain a foundation for properly addressing auditing estimates and fair values. Understand some of the important requirements and perspectives in these challenging areas. Special topics Analyze special topics regarding estimates and fair value measurements, such as credentials of specialists, written representations, disclosures, and estimates in revenue recognition. Finally, obtain an understanding of the importance of considering estimates in revenue recognition

This CPE course can be purchased individually, or as a part of the Audit Staff Essentials - Experienced In-Charge/Senior training bundle. Gather components Review the necessary components of financial statements prepared under generally accepted accounting principles (GAAP), including disclosures, preparation systems, adequate segregation of duties, and a review process. Understand the risk assessment process as it applies to financial statement presentation and disclosure. Types of controls Explore the types of controls that you might encounter when the client self-prepares the financial statement or when the financial statements are prepared by the auditor. Understand the effect of special purpose frameworks when encountered.

This CPE course can be purchased individually, or as a part of the Audit Staff Essentials - Experienced In-Charge/Senior training bundle. Understand risk assessment. Review the key concept of risk assessment, with a focus on internal controls. Understand identification and testing of automated and information technology general controls. Internal control. Consider deficiencies in internal control, including deficiencies in automated controls and information technology general controls. Understand the concept of severity and steps taken for aggregating found deficiencies, as well as the impact of compensating and monitoring controls. Consider common peer review and inspection findings with regard to internal control to prevent them from recurring.

This CPE course can be purchased individually, or as a part of the Audit Staff Essentials - Experienced In-Charge/Senior training bundle. The work of specialists Understand your responsibilities when your client engages a service organization or when you engage a specialist to help you with complex or unfamiliar areas in certain engagements. Understand how and when to refer to both areas, as well as the related performance and documentation requirements in each. Privacy concerns Learn also about SOC2r reports regarding privacy.

This CPE course can be purchased individually or as part of the Audit Staff Essentials - Experienced Staff/New In-Charge staff training bundle. Understand the purpose and importance of inherent risk and control risk assessment tasks, with an emphasis on what these tasks seek to accomplish and how they drive the overall audit process. Recall the importance of setting a materiality target for the engagement, including materiality when executing a group audit, and how the audit strategy - executed by account and relevant assertion - relates to the fundamental inherent and control risk assessments. Explore the risk assessment, including brainstorming for fraud and additional risks, emphasizing and distinguishing entity and auditor tasks and how to properly support with documentation these risk assessments that will drive further audit procedures. Understand the COSO framework, which is the basis for most systems of internal control assessments. Explore how audit data analytics can be used in the risk assessment process.

This CPE course can be purchased individually or as part of the Audit Staff Essentials - Experienced Staff/New In-Charge staff training bundle. Understand how a comprehensive framework includes concepts such as the presumption of a going concern and fair presentation, and recognize what disclosures need to be present. Look beyond the figures and facts to consider not only the current accounting for the transaction, but also the future implications, such as the entity's ability to continue as a going concern, as well as commitments and contingencies - including the auditor's responsibility related to litigation claims assessment. Consider the procedures and documentation required as well as the liquidation basis of accounting.