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

Excel Accountant - Benefits Risks of Office 365

  • CPA (CA)
  • CFE
  • CIA
  • CMA
  • CPA (US)
  • Tax Preparer
Excel Accountant - Benefits Risks of Office 365

2 Credits

$20

Subject Area

Computer Software and Applications

Webinar Qualifies For

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

Upcoming Webinars

Why Client Experience Matters in Every Accounting Firm

(202)

Oct 19, 2021 | 03:00 PM EDT View Details

Forensic Accounting: Fraud Investigation Engagements

Oct 19, 2021 | 03:00 PM EDT View Details

IRS Representation Series - Reducing IRS Assessments for Interest & Penalties

(1)

Oct 19, 2021 | 03:00 PM EDT View Details

Sales Tax Liabilities Of Manufacturers And Other Service Providers

(173)

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

President Biden's Tax Proposals: A First Look At The Pending Storm

(202)

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

SOX Internal Controls For Accounts Payable, Receivable & Inventory

(13)

Oct 20, 2021 | 09:00 AM EDT View Details

S-Corp Preparation, Basis Calculations & Distributions – Form 1120S Schedule K & K-1 Analysis

(119)

Oct 20, 2021 | 09:00 AM EDT View Details

Is It Time for a Development Audit?

(1)

Oct 20, 2021 | 09:00 AM EDT View Details

IFRS Fixed Assets (Property, Plant & Equipment)

(6)

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

QBO: Build Right Chart of Accounts - Base for Accounting and Reading Financial Statement

(5)

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

How to deal effectively with IRS Examinations and Criminal Investigations?

(21)

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

SOX Overview

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

Excel Accountant: Dynamic Arrays

(2)

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

Avoid Liabilities-Perfect your Understanding of Payroll Tax Withholding

(2)

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

Proper Preparation Submission & Negotiation - Offers in compromise(OIC)

(206)

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

Course Description

Learn from Excel expert David Ringstrom, CPA, how the Office 365 version of Excel 2016 differs from previous versions and perpetually licensed versions of Excel 2016. Historically, each version of Excel has been identical for all users, but that’s no longer the case. In this comprehensive course, David discusses updated features and worksheet functions available in the Office 365 version of Excel 2016, shows you step-by-step how to use them, and shares helpful keyboard shortcuts and tips. 

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.

Learning Objectives

  • Recall the benefits and risks of sharing workbooks via OneDrive in Office 365.
  • Identify the menu where the Recommended PivotTables feature appears in Excel 2013 and later.
  • Describe the MAXIFS function that’s available in certain versions of Excel 2016.

Who Should Attend?

  • Accountant
  • Certified Fraud Examiner
  • Certified Management Accountant
  • Cloud Accountants
  • CPA (Industry)
  • CPA - Large Firm
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial Accountant
  • Entrepreneurial CPA
  • Maryland Tax Preparers
  • Senior Accountant
  • Tax Accountant (Industry)
  • Young CPA

Testimonial

5

(10)
100%
0%
0%
0%
0%

DB

I would suggest this webinar to all those people who are using an older version and are about to or thinking of upgrading to the latest Office 365 suite. The webinar covers a wide range of topics. The user experience was pleasing and so were the presenting skills of David. Thank you myCPE and David

KD

I am very satisfied with the webinar. David is very thorough with Excel and that was very evident in the presentation. Highly recommended

KA

Got to know so many nuances about the changes that have been made in the latest Office Suite compared to the older versions. Have been planning to make the shift since quite some time and this webinar is definitely going to help me take that call. Thanks David and myCPE.

CL

When it comes to Excel no one can beat David. The knowledge and the way he presents is so fluid and easy to grasp. I am very happy with the webinar. Thanks David.

JOL

David had so much knowledge that can be shared. The webinar was crisp, well laid out and to the point. A package that was presented all too well. Highly recommended.

ET

The way David explained the changes, the benefits and the downsides of upgrading to Office 365 is commendable. It has helped me in taking a call about the shift that I was planning.