1374 Events Found.
On Demand
Accessing & Cleaning Data with Excel®, Power Query, & Power BI®
- 12:00 am–11:59 pm ET
- Event Code: OD009719
- CPE Credits: 2
Available with CPE Select
While there are a wide range of ways to analyze data, one must first retrieve, scrub, and organize data effectively before any of those techniques can be used. This session will help users understand and utilize end user data retrieval tools like Microsoft® Power Query as well as content packs ... More Info
On Demand
Advanced Excel® Functions & Formulas
- 12:00 am–11:59 pm ET
- Event Code: OD010819
- CPE Credits: 2
- Available with CPE Select
Excel® has more than 450 functions, many of which are unused by business professionals. This session will put you on a path to improved Excel productivity by introducing you to powerful but little used Excel functions, such as IFS (for nested IF statements), AGGREGATE (best described as SUBTOTAL on steroids), ... More Info
On Demand
Advanced Excel® Reporting: Best Practices, Tools, & Techniques
- 12:00 am–11:59 pm ET
- Event Code: OD008419
- CPE Credits: 4
- Available with CPE Select
If you need to build advanced Excel reports, including reports where the source data resides in your accounting software or another database, then this program should be at the top of your CPE list! In this seminar, you will learn how to use Open Database Connectivity (ODBC) and Online Analytic ... More Info
On Demand
Advanced QuickBooks® Tips & Techniques
- 12:00 am–11:59 pm ET
- Event Code: OD008519
- CPE Credits: 4
- Available with CPE Select
QuickBooks® remains one of the leading accounting solutions for small and growing businesses and Intuit® has added numerous advanced features to the application over the past few releases. In this seminar, you will learn how to take advantage of many of QuickBooks’ new and advanced features to solve important issues. ... More Info
On Demand
Data Analysis with Power Pivot®
- 12:00 am–11:59 pm ET
- Event Code: OD010719
- CPE Credits: 2
- Available with CPE Select
With Power Pivot, your PivotTable reports become even more powerful. Power Pivot can connect directly to many common external data sources or can be used in conjunction with Power Query for superior data import and transformation capability. DAX functions allow users to create sophisticated calculations, both columns and measures, and ... More Info
On Demand
Evaluating Technology Controls
- 12:00 am–11:59 pm ET
- Event Code: OD010019
- CPE Credits: 2
- Available with CPE Select
Technology controls are more important than ever. In the absence of properly-functioning controls, entire systems and the data contained therein can quickly become infected, breached, or simply stop functioning. Auditors, business managers, and consultants all need to know how to evaluate critical technology controls and in this session, you will ... More Info
On Demand
Excel® Data Models, Combinations, & Consolidations
- 12:00 am–11:59 pm ET
- Event Code: OD009319
- CPE Credits: 2
- Available with CPE Select
Combining and linking data from multiple tables, sheets, and workbooks is a daily need for most accountants, yet many do not fully appreciate the breadth of Excel® options available for accomplishing this task. In this session, you will learn about the full range of Excel data consolidation functionality, including simple ... More Info
On Demand
Excel® Financial Modeling Best Practices
- 12:00 am–11:59 pm ET
- Event Code: OD010519
- CPE Credits: 2
- Available with CPE Select
Excel® remains the tool of choice for many accounting and financial professionals when building financial models, including forecasted financial statements and budgets. Yet, many of these same professionals have never received any formal training in the best practices associated with generating these types of spreadsheets. By participating in this session, ... More Info
Also Available As:
On Demand
Tuesday, January 1, 2019 (12:00 am–11:59 pm ET)
Register >>
On Demand
Excel® Financial Modeling Best Practices
- 12:00 am–11:59 pm ET
- Event Code: OD010519
- CPE Credits: 2
- Available with CPE Select
Excel® remains the tool of choice for many accounting and financial professionals when building financial models, including forecasted financial statements and budgets. Yet, many of these same professionals have never received any formal training in the best practices associated with generating these types of spreadsheets. By participating in this session, ... More Info
Also Available As:
On Demand
Tuesday, January 1, 2019 (12:00 am–11:59 pm ET)
Register >>
On Demand
Excel® Tips & Tools for Better Budgets
- 12:00 am–11:59 pm ET
- Event Code: OD010419
- CPE Credits: 2
- Available with CPE Select
Excel® is the de facto budgeting and forecasting tool for most professionals, yet many who use Excel for these tasks do not take advantage of the numerous built-in tools available. Among other topics in this session, you will learn how to work with Excel features such as FORECAST, FORECAST.ETS, TREND, ... More Info
On Demand
Filtering the World: Spam, Virus, & Malware Protection
- 12:00 am–11:59 pm ET
- Event Code: OD010919
- CPE Credits: 2
- Available with CPE Select
Bad actors want inside your systems and want to steal your data. They can attack your systems directly or they can use your email box. This session explains the protection options for spam, virus, and malware. Top tools and techniques will be discussed with multiple solutions discussed in each area. ... More Info
On Demand
Implementing Internal Controls in QuickBooks® Environments
- 12:00 am–11:59 pm ET
- Event Code: OD008619
- CPE Credits: 4
- Available with CPE Select
New Course for 2018! The QuickBooks® ecosystem of accounting tools remains the most widely used set of accounting applications in use by small businesses, yet many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for how you can improve internal controls in ... More Info
On Demand
Implementing Password Management & Data Loss Prevention Tools for Better Security
- 12:00 am–11:59 pm ET
- Event Code: OD010619
- CPE Credits: 2
- Available with CPE Select
Data Loss Prevention (DLP) is a means of creating and enforcing security policies in an organization. For example, with DLP, you can create rules that programmatically block all outbound email messages containing information such as Social Security or credit card numbers. Unfortunately, most business professionals have yet to discover DLP ... More Info
On Demand
Introduction to Excel® Macros
- 12:00 am–11:59 pm ET
- Event Code: OD008719
- CPE Credits: 4
- Available with CPE Select
You have used Excel® for years and Lotus prior to that. During this time, you have said repeatedly, “One day, I’ll learn how to write macros.” Well, that time has arrived because this four-hour program will introduce you to the wide world of macros and Visual Basic for Applications (VBA) ... More Info
On Demand
Mastering the Excel® Data Model
- 12:00 am–11:59 pm ET
- Event Code: OD009819
- CPE Credits: 2
- Available with CPE Select
The Excel® Data Model is an in-memory multi-dimensional (OLAP) data engine available in all versions of Excel 2013 and 2016. The Data Model is the core foundation of Power Pivot. With the Data Model, users can relate multiple Excel tables, build PivotTables on multiple data sources, import data from external ... More Info
On Demand
Microsoft® Outlook®: Organizing the Inbox
- 12:00 am–11:59 pm ET
- Event Code: OD011119
- CPE Credits: 2
- Available with CPE Select
Microsoft® Outlook® is the most utilized business application in the world today, but for many users dealing with Outlook is the most frustrating part of their day. This session is designed to help Outlook users better organize and manage their email communications. It contains coverage on how to reduce email ... More Info
On Demand
Microsoft® Power BI®: Power Reporting for Free!
- 12:00 am–11:59 pm ET
- Event Code: OD010219
- CPE Credits: 2
- Available with CPE Select
Power BI® is available as a free desktop solution and this tool can revolutionize your reporting processes. As a free solution, it is packed full of features found in pay for solutions costing thousands of dollars per year. This session will take you on a guided tour of importing data, ... More Info
On Demand
Microsoft® Word® Tips & Tricks
- 12:00 am–11:59 pm ET
- Event Code: OD009619
- CPE Credits: 2
- Available with CPE Select
Technology controls are more important than ever. In the absence of properly-functioning controls, entire systems and the data contained therein can quickly become infected, breached, or simply stop functioning. Auditors, business managers, and consultants all need to know how to evaluate critical technology controls and in this session, you will ... More Info
Self-Study
NC Accountancy Law: Ethics, Principles, & Professional Responsibilities
- 12:00 am–11:59 pm ET
- Event Code: SS000119
- CPE Credits: 8
North Carolina accountancy rules provide guidance for both new and experienced CPAs in obtaining and maintaining a CPA license, in recognizing the responsibilities of the North Carolina State Board of CPA Examiners, and in how to respond to third-party disputes regarding your CPA license. The NC rules also examine the ... More Info
On Demand
Office 365®: New Tools, New Tricks
- 12:00 am–11:59 pm ET
- Event Code: OD010119
- CPE Credits: 2
- Available with CPE Select
Microsoft®’s Office 365® offering continues to evolve and has likely forever changed how many organizations approach licensing familiar Microsoft Office applications. As part of the ever-changing nature of Office 365, Microsoft has added several new tools—including Flow and PowerApps—to the suite and has also added many new features to Excel, ... More Info
Self-Study
Professional Ethics & Conduct
- 12:00 am–11:59 pm ET
- Event Code: SS000219
- CPE Credits: 2
North Carolina Professional Ethics and Conduct rules are just one subsection of the set of rules and standards governing North Carolina CPAs. However, the importance of professional ethics merits an in-depth study, because making the right decision every time is hard! Without a solid ethical base, the rules are difficult ... More Info
On Demand
Ransomware: Reducing Your Risk
- 12:00 am–11:59 pm ET
- Event Code: OD011019
- CPE Credits: 2
- Available with CPE Select
Ransomware continues to plague individuals and businesses of all sizes and in all industries and represents one of the biggest security threats we face today. Yet few are taking the steps necessary to reduce the risk associated with the potential loss of data associated with ransomware and the risk of ... More Info
On Demand
Securing Your Data: Practical Tools for Protecting Information
- 12:00 am–11:59 pm ET
- Event Code: OD008819
- CPE Credits: 4
- Available with CPE Select
Security is not optional and yesterday’s security techniques are not working to minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. In this program, you will learn about the latest tools and techniques for securing your data, including ... More Info
On Demand
Security: A Practical Guide
- 12:00 am–11:59 pm ET
- Event Code: OD010319
- CPE Credits: 2
- Available with CPE Select
It’s not a matter of if you will have a security incident, but a matter of when. Learn the steps you can take to protect yourself. Everything from end to end will be covered including multifactor authentication, password managers, encryption, mobile device management, anti-virus, firewalls, policies, tools, and other techniques ... More Info
On Demand
Tales of True Tech Crimes: Ripped From the Headlines
- 12:00 am–11:59 pm ET
- Event Code: OD009019
- CPE Credits: 2
- Available with CPE Select
Technology controls are more important than ever. In the absence of properly-functioning controls, entire systems and the data contained therein can quickly become infected, breached, or simply stop functioning. Auditors, business managers, and consultants all need to know how to evaluate critical technology controls and in this session, you will ... More Info