On Demand
Excel® – Advanced Formatting to Improve Your Spreadsheets
- Online
- Event Code: ODX02725
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Advanced Spreadsheet Troubleshooting Techniques
- Online
- Event Code: ODX00825
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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? ... More Info
On Demand
Excel® – Auditing Your Spreadsheets for Maximum Accuracy
- Online
- Event Code: ODX00525
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Building Powerful Lookup & Reference Formulas
- Online
- Event Code: ODX01025
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Create KPI Dashboards for Maximum Impact
- Online
- Event Code: ODX00625
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Feature Review in 100 minutes
- Online
- Event Code: ODX00325
- CPE Credits: 2
- Legacy Level:Overview
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Formatting Spreadsheets for Beginners
- Online
- Event Code: ODX02525
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – From a Blank Sheet to a Finished Workbook
- Online
- Event Code: ODX00225
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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? ... More Info
On Demand
Excel® – Functions & Formula Shootout
- Online
- Event Code: ODX00125
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Fundamentals, Data Entry & Basic Formulas
- Online
- Event Code: ODX02625
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – New Features That Benefit Excel® 2019 & O365 Users
- Online
- Event Code: ODX02325
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Two Must Know Features; Defined Name & Tables
- Online
- Event Code: ODX01225
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Using Charts for a Non-Financial Audience
- Online
- Event Code: ODX00725
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Using PivotTables for Data Analysis
- Online
- Event Code: ODX00425
- CPE Credits: 4
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Excel® – Working With Text, Date & Time Functions & Formulas
- Online
- Event Code: ODX01125
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Computer Software & Applications
- NCACPA On Demand 365
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 ... More Info
On Demand
Exploring Internal Controls: That Could Have Prevented Frauds
- Online
- Event Code: ODX12625
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Auditing
- NCACPA On Demand 365
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. Required Knowledge: Basic working knowledge of auditing techniques Advanced Preparation: None Who Should Attend: Accounting ... More Info
On Demand
Finding Errors in Excel® Spreadsheets
- Online
- Event Code: ODX12025
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Auditing
- NCACPA On Demand 365
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants ... More Info
On Demand
Fraud & Embezzlement; Case Studies from the Trenches
- Online
- Event Code: ODX03225
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Regulatory Ethics
- NCACPA On Demand 365
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 ... More Info
On Demand
Fraud Trends – Applying Real-life Lessons to Small- & Mid-Size Entities
- Online
- Event Code: ODX09025
- CPE Credits: 2
- Legacy Level:Intermediate
- Fields of Study: Auditing
- NCACPA On Demand 365
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 ... More Info
On Demand
Fundamentals of Income Taxation
- Online
- Event Code: ODX03625
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Taxes
- NCACPA On Demand 365
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. Required ... More Info
On Demand
GASB 87: Are you ready?
- Online
- Event Code: ODX07525
- CPE Credits: 1.5
- Legacy Level:Basic
- Fields of Study: Accounting (Governmental)
- NCACPA On Demand 365
Government leases are getting an overhaul. GASB Statement 87 was issued in 2017 and provides an update on the proper accounting for leases from both the lessee and lessor points-of-view. Required Knowledge: None Advanced Preparation: None Who Should Attend: Practitioners and members in industry responsible for accounting and financial reporting ... More Info
On Demand
Guide Strategy, Attract Investments with Financial Forecasts
- Online
- Event Code: ODX12825
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Finance
- NCACPA On Demand 365
Financial statement forecasting is essential for predicting a company’s future financial health, guiding strategic decisions, and attracting investments. By analyzing historical data, market trends, and assumptions, businesses can anticipate risks and opportunities, enabling effective planning, resource allocation, and long-term stability and growth. Required Knowledge: None Advanced Preparation: None Who Should ... More Info
On Demand
History of Investing
- Online
- Event Code: ODX02925
- CPE Credits: 1.5
- Legacy Level:Overview
- Fields of Study: Finance
- NCACPA On Demand 365
You hear it all the time. Financial products are becoming more complex. Diversification has changed. Our approach to investing has changed. What does all this mean? In this course, we will explore how investment theory has changed over time from Markowitz to Factor Investing. Using examples and practical applications, we ... More Info
On Demand
Hold Your Horses! How Landmark Fraud May Have Been Avoided
- Online
- Event Code: ODX09525
- CPE Credits: 2
- Legacy Level:Basic
- Fields of Study: Auditing
- NCACPA On Demand 365
What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and ... More Info
On Demand
How AI Is Automating Internal Control
- Online
- Event Code: ODX11625
- CPE Credits: 4
- Legacy Level:Basic
- Fields of Study: Accounting
- NCACPA On Demand 365
The term “artificial intelligence” (AI) has become mainstream and while most have a layperson’s understanding of AI, few know the depth and breadth of this technology’s capability. AI is affecting just about everything in business and in people’s personal lives. The operation of an internal control system is also changing ... More Info