CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.
CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.
2 Credits
$20
2 CPE credit of Computer Software & Applications for all CPAs
2 CPE credit for Certified Management Accountants (CMA)
2 CPE credit for Certified Internal Auditors (CIA)
2 CPD credit (Verifiable) for Canadian CPAs
2 CPE credit for Certified Fraud Examiners (CFEs)
2 CE credit of Computer Technology for Maryland Tax Preparers
2 General Educational credit for Tax Professionals / Bookkeepers / Accountants
Financial Intelligence for Entrepreneurs, Executives, and Directors
Oct 25, 2021 | 09:00 AM EDT View Details
Are You Ready for a Capital Campaign?
Oct 25, 2021 | 09:00 AM EDT View Details
Differences between IFRS and GAAP
Oct 25, 2021 | 09:30 AM EDT View Details
Corporate External Financial Reporting Decisions
Oct 25, 2021 | 10:00 AM EDT View Details
Everything You Need to Know About Partnerships
Oct 25, 2021 | 10:00 AM EDT View Details
Basis Calculations & Distributions For Pass-thru Entity Owners Schedule K-1 Analysis (Latest)
Oct 25, 2021 | 10:00 AM EDT View Details
Basic Concepts of Fixed Asset Accounting
Oct 25, 2021 | 10:00 AM EDT View Details
Excel Accountant: Internal Control
Oct 25, 2021 | 10:00 AM EDT View Details
Real Estate Tax Strategies: Cost Recovery, Partial Dispositions, Removal Cost, Int. Deductions, Repairs & Capital Improvements
Oct 25, 2021 | 10:00 AM EDT View Details
The Structure and Organization of the IRS
Oct 25, 2021 | 10:00 AM EDT View Details
Federal Tax Update – Individual & Business Current Developments
Oct 25, 2021 | 10:00 AM EDT View Details
IRS Form 1099 Reporting Req. including updates on FORM 1099-NEC (LATEST 2021)
Oct 25, 2021 | 10:00 AM EDT View Details
Money Laundering Risks and Countermeasures for Accountants and Other Professionals
Oct 25, 2021 | 10:30 AM EDT View Details
Quickbooks Online for Accountants Work Centre - Managing your Practice
Oct 25, 2021 | 10:30 AM EDT View Details
Business Killers – 12 Ways to Protect Your Business
Oct 25, 2021 | 10:30 AM EDT View Details
This Course is Also Available in Self Study (On-Demand)
Click HereIdentifying duplicate data and managing it within the spreadsheets has always been a challenge for most of us, especially in spreadsheets which are comparatively complicated in nature. Excel expert David Ringstrom, CPA brings here this presentation educating on how to identify such duplicate data and managing it within the spreadsheets, which will certainly prove beneficial to a huge extent.
In this online CPE course, David has covered a variety of subjects, including identification of duplicate data visually by way of the Conditional Formatting feature, using a pivot table to determine how many duplicates are in a list, and applying worksheet functions like SUMIF or COUNTIF to sum or count instances of duplicates.
David will demonstrate each technique at least twice in this online continuing education course, firstly vide a step-wise Powerpoint presentation and secondly in a subscription-based MS Office 365 version of Excel and also he will draw your attention to differences in the older versions of Excel (i.e. 2019, 2016, 2013, etc)in his online CPE presentation and detailed handouts. He also provides an Excel workbook that includes most of the examples he uses during the webcast.
David brings it to your attention on the subscription-based product 'Office 365' which provides new feature updates as often as monthly as against the perpetual licensed versions of Excel such as Excel 2019, Excel 2016, and so on, which does not update and include the latest features.
This online Excel CPE webinar is recommended for CPAs, CMAs, CIAs, CFEs, and Other Finance & Tax professionals desiring to upgrade their skills in excel.
ADV
I really enjoyed the excel classes, which helped me improve my knowledge. Many practical examples shared by David, that allow me to fully understand the logic behind it.
TH
Very useful information! I learned a lot about how to apply the advanced filter features and the remove duplicates feature
