CPE Catalog & Events

The title of this webinar is NOT a joke. If you consistently apply the five principles of ethical intelligence that Forbes Contributor Bruce Weinstein, The Ethics Guy, presents, your business will prosper, you will take better care of yourself and lose that weight, and either find or keep the love of your life. However, you are the one that will have to do the work, day in and day out. All Bruce can do is show you the way. If you are willing to commit (or renew your commitment) to leading your business and your personal life with ethical intelligence, this is the perfect webinar for you. The work you put in during and after the webinar will help to make you a better CPA and a better person.

Can you afford to hire a single dishonest person? Of course not. But what are you doing to ensure that you hire and promote only honest, accountable people? One of the most common complaints in business is, "I can't find and keep good people on my team." This distinctive, results-focused webinar will show you the four things you must do to hire and retain the very best employees at every level of your organization. This one-hour presentation in behavioral ethics disguised as one of the most practical, revenue-building webinars you'll take this year.

The walking dead aren't the only threat to your business. So are several dangerous, even terrifying myths about what ethical leadership is and is not. This fun and distinctive webinar will present what Forbes contributor Bruce Weinstein, The Ethics Guy, calls "zombie ethics"-myths about accounting that hinder your ability to serve your clients and enjoy a thriving business. Taking a page from Nobel laureate Paul Krugman's recent work, zombie ethics are ideas about ethical leadership that deserve to remain buried but keep resurfacing from time to time. They walk the earth and wreak havoc. In this engaging webinar, The Ethics Guy will show you how to send them back to the cemetery for good. You can then fearlessly bring in new business--and watch your practice soar!

How did the world's superstars build such powerful businesses? What lessons from the biggest musicians, movie stars, athletes, and innovators will help you become more successful? We'll explore how the principles of ethics and the traits of high-character leaders have made your favorite celebrities who they are and how you can follow in their footsteps. This webinar is based on presenter Bruce Weinstein, The Ethics Guy's popular Forbes.com columns, "Lead Like..." It's an ethics presentation disguised as a fun, engaging, and entertaining journey into what makes superstars so influential and how they are able to sustain their stellar success.

" It is essential for CPAs to have an understanding of the ethical problems and principles that impact their daily interactions with clients, employers, and regulatory authorities. This course reviews the frameworks provided in the Florida Statutes, the Rules of the Florida Board of Accountancy, and the AICPA Code of Professional Conduct that determine the expectations for your behavior as a Florida CPA. Through an interactive and engaging dialogue, we will focus on the application of specific rules and requirements within that framework and recent trends in business and professional ethics. The course fulfills the biennial ethics requirement for Florida CPAs. This course is QAS self-study and must be completed by one year of purchase. This course is included in the 24/7 Learning Library."

While ethics training is required by many professions, the true value of the CPA license is in understanding how critically important ethical conduct is to one another and the public. This course will focus on tax-specific ethics issues, with a special focus on recent tax cases, as well as a CPA's responsibilities as defined in the AICPA Code of Professional Conduct and IRS Circular 230.

This CPE course can be purchased individually or as part of the Core Forensic Accounting Certificate. Factual evidence is the bedrock of a forensic accountant's case. Gaining this evidence efficiently and properly is important to the forensic engagement. Through narration by an industry subject matter expert and application exercises, this CPE course describes topics such as types of evidence, the process to find the evidence, reviewing and analyzing documents, as well as finding and verifying electronic evidence.

Adapt and evolve. The business ecosystem will adapt and evolve in response to changes in the wider environment. As the business environment has become more competitive, dynamic, and complex, the focus has shifted to not only identifying customers' needs and wants, but also to creating customer wants where they did not exist before. In this course, you will learn how evolving can change the business ecosystem and how to analyse customers to support your organisation's strategy. Gain experience with detailed exercises. Using case studies, real-life scenarios, and exercises, this course will give you the necessary tools to identify drivers for change in the business ecosystem and how to analyse your customer base to boost your overall success. This is a standalone course but if you're interested in more of this type of learning while earning a designation, explore the CGMAr Finance Leadership Program. Key topics Ecosystems and strategy formulation The business ecosystem Understanding customers

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.

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.

In the "Excel - Formatting Spreadsheets for Beginners" class, you learned basic formatting of a spreadsheet. In this class, we take you to the next level by teaching you how to customize many of the formatting options.Learn to customize cell styles and how to use these styles in other workbooks. Most Excel users know how to select number formats but this class shows how to leverage the Custom Number Formatting option to create special formatting options.Many of the formatting options are applied manually, cell-by-cell or by range. This can be tedious if there is a condition by which you want to apply a format. You will learn to use Conditional Formatting to format based upon a criteria.Have you ever finalized a spreadsheet, only to accidently make changes over the top? This action is something that is very easy to do. This class demonstrates various options to prevent this from happening and will look at various security options within 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.

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.

Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this course, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. 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 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.

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.