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

Excel Accountant - Charts

4.5 (10)

David Ringstrom, CPA

Excel Accountant

Wednesday, August 19, 2020 | 09:00 AM EDT

  • CPA Canada
  • CPA/CITP
  • CPA
  • CVA
  • Tax Preparer
  • CFE
  • CMA

2 Credits

$20

Subject Area

Computer Software and Applications

Upcoming Webinars

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

  • Recall the menu in Excel where the Table feature resides.
  • Identifying how to insert clipart and templates to a chart.
  • Identify how to create self-expanding charts by way of Excel’s Table feature.
  • Recognize how to Create thermometer and Pivot chart and Managing it.
  • 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
  • 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
  • Others
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • Tax Firm
  • Tax Managers
  • Tax Practitioners
  • Tax Preparer
  • Tax Pros
  • Young CPA

Testimonial

Array
(
    [no_of_record] => 10
    [average] => 4.5000
)
 

4.5

(10)
70%
10%
20%
0%
0%

AT

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.