CPE Packages (Incl. Ethics) for Multiple States and Qualifications Available. Price $4/credit - CLICK HERE to view.

Excel Accountant - Breaking Down Complicated Formulas

4.6 (12)

David Ringstrom, CPA

Excel Accountant

Thursday, August 06, 2020 | 11:00 AM EDT

  • CPA

2 Credits

$20

Subject Area

Computer Software and Applications

Webinar Qualifies For

2 CPE credit of Computer Software & Applications for all CPAs

2 CE credit of Computer Technology for Maryland Tax Preparers

2 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

employment law in a nutshell – guidance for your business

(1)

Jun 18, 2021 | 09:00 AM EDT View Details

irs tax practice & procedure introduction

Jun 18, 2021 | 09:30 AM EDT View Details

differences between ifrs and gaap

(4)

Jun 18, 2021 | 09:30 AM EDT View Details

addressing single audit quality in a covid-19 era

Jun 18, 2021 | 09:30 AM EDT View Details

advance irs learning: multiyear non-filing, criminal investigation, voluntary disclosure, whistleblower claims etc.

(2)

Jun 18, 2021 | 10:00 AM EDT View Details

tax strategies for real estate: crucial insights: acquisition and depreciation strategies

(5)

Jun 18, 2021 | 10:00 AM EDT View Details

keys to maintaining an effective and strong internal audit department

(1)

Jun 18, 2021 | 10:00 AM EDT View Details

best tax return workshop on s corporation (1120s) - latest

(3)

Jun 18, 2021 | 10:00 AM EDT View Details

are you creating legal liability when you hire or recruit online? - covid -19 special

(37)

Jun 18, 2021 | 10:00 AM EDT View Details

annual federal tax update - c & s corporations, partnerships & llcs (forms 1120, 1120s & 1065)

Jun 18, 2021 | 10:00 AM EDT View Details

yellow book boot camp - nfp and governmental accounting & auditing update

(1)

Jun 18, 2021 | 10:00 AM EDT View Details

partnership preparation, basis calculations & distributions–form 1065 schedule k & k-1 analysis

Jun 18, 2021 | 08:00 AM PDT View Details

comprehensive tax strategies & insights on real estate

(3)

Jun 18, 2021 | 08:00 AM PDT View Details

internal controls for businesses

(2)

Jun 18, 2021 | 08:00 AM PDT View Details

maximizing home office deduction (covid special - latest)

(7)

Jun 18, 2021 | 11:30 AM EDT View Details

Course Description

In this comprehensive presentation, Excel expert David H. Ringstrom, CPA, has shown various ways of using complicated formulas. Sometimes such formulas can grow out of control or more likely, you inherit spreadsheets from others that you’re to take ownership of. By the end of this webcast, you’ll have many tricks at your disposal to quickly decipher even the most complex Excel formulas.

Each technique is demonstrated at least twice by David, firstly by means of a PowerPoint slide with numbered steps and secondly in a subscription-based MS Office 365 version of Excel. David also draws your attention to differences in the older versions of Excel (i.e. 2019, 2016, 2013, etc)in his presentation and detailed handouts. He also has shared an Excel workbook that includes most of the examples used during the webcast.

David explains about the new feature updates in the subscription-based product 'Office 365' that are provided as often as on monthly basis as against the perpetual licensed versions of Excel such as Excel 2019, Excel 2016, and so on, which does not update and include latest features.

Learning Objectives

  • Applying Excel’s IFERROR function to compensate for temporary situations where a formula may return an error.
  • List the benefits of using range names.
  • Recognize the use of Formula with help of Macro.
  • Identify usage of ISNUMBER / ISTEXT / ISERROR functions.
  • Define how to display all formulas in a worksheet at once with the Show Formulas feature.

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Accounting Practice Owners
  • Bookkeeper
  • CFO/Controller
  • Chief Accounting Officer
  • CPA (Industry)
  • CPA - Large Firm
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial CPA
  • Outsourced CFO
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • Tax Firm
  • Tax Managers
  • Tax Practitioners
  • Tax Preparer
  • Tax Pros
  • VP Accounts
  • VP Finance
  • Young CPA

Testimonial

Array
(
    [no_of_record] => 12
    [average] => 4.5833
)
 

4.6

(12)
75%
17%
0%
8%
0%