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 Accounting for all CPAs
2 CPE credit for Certified Management Accountants (CMA)
2 CPD credit (Verifiable) for Canadian CPAs
2 CPD credit (Verifiable) for Certified Valuation Analyst (CVA)
2 CE credit of Computer Technology for Maryland Tax Preparers
2 General Educational credit for Tax Professionals / Bookkeepers / Accountants
Adventures in Excel
Sep 28, 2021 | 04:00 PM EDT View Details
ReNew Your Accounting Firm: Less Burden in Tax Season, More Profits, and Better Clients
Sep 28, 2021 | 04:00 PM EDT View Details
Mastering IRS Representation
Sep 29, 2021 | 09:00 AM EDT View Details
Best Workshop on Partnership & LLC (Form 1065) Tax Return Review & Case Study (NEW)
Sep 29, 2021 | 09:00 AM EDT View Details
Introduction to the Estate Tax
Sep 29, 2021 | 09:30 AM EDT View Details
Excel Accountant: Payroll Analysis
Sep 29, 2021 | 10:00 AM EDT View Details
Quickbooks Online (QBO) Mobile Application for Accountants
Sep 29, 2021 | 10:00 AM EDT View Details
Ethics For Tax Professionals (Latest 2021)
Sep 29, 2021 | 10:00 AM EDT View Details
SOX Internal Controls For Accounts Payable, Receivable & Inventory
Sep 29, 2021 | 10:00 AM EDT View Details
S-Corp Preparation, Basis Calculations & Distributions – Form 1120S Schedule K & K-1 Analysis
Sep 29, 2021 | 10:00 AM EDT View Details
IFRS 9: Financial Instruments
Sep 29, 2021 | 10:00 AM EDT View Details
Fundamentals of Defined Benefit Plans
Sep 29, 2021 | 10:00 AM EDT View Details
Introduction To Use Tax
Sep 29, 2021 | 10:30 AM EDT View Details
Top 10 Things All CPAs Need to Know About IRS Representation
Sep 29, 2021 | 10:30 AM EDT View Details
How to deal effectively with IRS Examinations and Criminal Investigations?
Sep 29, 2021 | 11:00 AM EDT View Details
Excel expert David Ringstrom, CPA, will teach you how to create dynamic financial reports—for any month of the year—on a single worksheet. Many Excel users build a worksheet for each month of the year, which can be inconvenient and tiresome to revise. Rather than using such a cumbersome method, David demonstrates how to apply the VLOOKUP, OFFSET, and SUM functions to quickly create accounting reports that allow you to toggle to any reporting period with just a couple of mouse clicks. In addition, David shares effective ways to export data from your accounting package so you can create a “set-and-forget” link to your accounting data in Excel.
In this Online Excel CPE Webinar, David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Office 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
This Online Excel CPE course for CPAs is recommended for CMAs, CVAs, Tax Preparers, Accounting, and Finance Professionals and Practitioners who are seeking to build financial statements in excel that can be easily updated and supporting calculations are easy to follow.
Array
(
[average] => 4.1111
[no_of_record] => 9
)
DH
Great course to show the power of Excel data connections. If you can't get an ODBC to the source data tables, use the tools shown in this webinar to get you going in the right direction.
GW
There was some thunder-like sounds coming across the microphone. Possibly too close to the mic. There were also gaps in sound where the system went silent and picked up a word or two later.
JLS
This program is complex and geared toward experts.
