CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.

Excel Accountant - Charts

  • CPA (CA)
  • CFE
  • CMA
  • CPA (US)
  • CVA
  • CFA
  • Tax Preparer
Interactive Charts in Excel CPE Webinar

2 Credits

$20

Subject Area

Computer Software and Applications

Webinar Qualifies For

2 CPE credit of Computer Software & Applications for all CPAs

2 CPD credit (Verifiable) for Canadian CPAs

2 CPE credit for Certified Fraud Examiners (CFEs)

2 CPD credit (Verifiable) for Certified Information Technology Professionals (CITP)

2 CE credit of Computer Technology for Maryland Tax Preparers

2 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

Cyber Incident & Response–An Interview with former United States Attorney Jay Town

(20)

Oct 22, 2021 | 04:00 PM EDT View Details

Best investments and investment strategies

(99)

Oct 22, 2021 | 04:00 PM EDT View Details

Financial Intelligence for Entrepreneurs, Executives, and Directors

(1)

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

(16)

Oct 25, 2021 | 09:30 AM EDT View Details

Corporate External Financial Reporting Decisions

(17)

Oct 25, 2021 | 10:00 AM EDT View Details

Everything You Need to Know About Partnerships

(13)

Oct 25, 2021 | 10:00 AM EDT View Details

Basis Calculations & Distributions For Pass-thru Entity Owners Schedule K-1 Analysis (Latest)

(122)

Oct 25, 2021 | 10:00 AM EDT View Details

Basic Concepts of Fixed Asset Accounting

(4)

Oct 25, 2021 | 10:00 AM EDT View Details

Excel Accountant: Internal Control

(6)

Oct 25, 2021 | 10:00 AM EDT View Details

Real Estate Tax Strategies: Cost Recovery, Partial Dispositions, Removal Cost, Int. Deductions, Repairs & Capital Improvements

(20)

Oct 25, 2021 | 10:00 AM EDT View Details

The Structure and Organization of the IRS

(745)

Oct 25, 2021 | 10:00 AM EDT View Details

Federal Tax Update – Individual & Business Current Developments

(10)

Oct 25, 2021 | 10:00 AM EDT View Details

IRS Form 1099 Reporting Req. including updates on FORM 1099-NEC (LATEST 2021)

(272)

Oct 25, 2021 | 10:00 AM EDT View Details

Money Laundering Risks and Countermeasures for Accountants and Other Professionals

(9)

Oct 25, 2021 | 10:30 AM EDT View Details

This Course is Also Available in Self Study (On-Demand)

Click Here

Course Description

Creating Dynamic Excel Charts makes it easy in providing calculative charts in your worksheets. Excel Expert, David Ringstrom, CPA, brings here an exclusive presentation on explaining its nitty-gritties. David discusses in detail about several helpful features, including the Recommended Charts, Repetitive formatting, create self-updating chart titles and makes your charts more lively with the usage of clip arts.

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 and 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.

Learning Objectives

  • To recall the menu in Excel where the Table feature resides.
  • To identifying how to insert clipart and templates to a chart.
  • To identify how to create self-expanding charts by way of Excel’s Table feature.
  • To recognize how to Create thermometer and Pivot chart and Managing it.
  • To describe how to create a dynamic chart title that updates from a worksheet cell.

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Accounting Practice Owners
  • Bookkeeper
  • Certified Fraud Examiner
  • Certified Information Technology Professionals
  • CFO/Controller
  • Chief Accounting Officer
  • CPA (Industry)
  • CPA - Large Firm
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial Accountant
  • Entrepreneurial CPA
  • Finance Pros
  • Information Reporting Officers
  • Maryland Tax Preparers
  • Others
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • Tax Firm
  • Tax Managers
  • Tax Practitioners
  • Tax Preparer
  • Tax Pros
  • Young CPA

Testimonial

4.5

(11)
64%
18%
18%
0%
0%

MC

When it comes to the knowledge of Excel, no one comes even close to David. The way he explains and then demonstrates all the tips and tricks, they get imbibed in one's mind. Thank you David.

LT

A tricky topic made easy to grasp by none other than David. Thank you David for this webinar and thank you myCPE for bringing to us this webinar. Looking forward to many more.

JM

Thank you myCPE for bring to us another amazing webinar by David. I have enjoyed every webinar hosted by him and am looking forward to many more. Good going myCPE.

RW

Another gem from the treasure of David. This is going to help me a lot at work. Highly recommended.

VM

I was skeptical about this webinar but upon a recommendation by my friend I signed up for this webinar. I am very that I listened to my friend. The pace and the content are absolutely perfect. David is very thorough with the subject and is evident in the way he teaches. Thank you David.

TH

Good knowledgeable course for understanding how to create self-expanding charts by way of Excel’s Table feature.