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

8 Automation Techniques in Microsoft Excel

  • CPA (CA)
  • CPA/CITP
  • CMA
  • CPA (US)
  • Tax Preparer
  • CFE
8 Automation Techniques in Microsoft Excel

1.5 Credits

FREE

Subject Area

Computer Software and Applications

Webinar Qualifies For

1.5 CPE credit of Computer Software & Applications for all CPAs

1.5 CPD credit (Verifiable) for Canadian CPAs

1.5 CPE credit for Certified Fraud Examiners (CFEs)

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

1.5 CE credit of Computer Technology for Maryland Tax Preparers

1.5 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

QBO Complete Comprehensive Overview - Latest

(23)

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

Understanding, Detecting & Preventing Cash, Credit Card, Inventory and Payroll Fraud

(6)

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

Qualified Business Income (QBI) Deduction (IRC §199A) Detailed Study, Analysis,Calculations,Case Studies, Ins & Outs (Latest)

(28)

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

Raising Money for Your Non-profit Organization

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

Dealing With IRS Collections Division (Part II)

(253)

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

The Principles of Ethical Leadership

(10)

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

Best Tax Return Workshop - Partnerships & LLCS (Form 1065) Latest

(98)

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

Quickbooks for Desktop PC Exploring the Interface - For Beginners

(15)

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

Excel Accountant: Intro to Spreadsheets In-Depth

(6)

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

IRA Contributions 2020 and 2021

(314)

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

How Non-profit Endowment Funds Work: Donor Interest, Organizational Policies and Trends

(61)

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

Accounting & Tax Implications of Accounting Changes & Errors

(2)

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

The Number 1 Tax Strategy for the Small Business Owner: Setting up an S Corporation step by step.

(15)

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

Corporate Accounting & Auditing Best Practices

(32)

Oct 26, 2021 | 11:00 AM EDT View Details

Segregation of duties, Documentation and other essentials for Management of Internal Controls

(8)

Oct 26, 2021 | 11:00 AM EDT View Details

Course Description

In this engaging Online Webinar, Excel expert David H. Ringstrom, CPA covers 8 different ways that you can automate repetitive work in Excel. Automation can be as simple as turning part of your spreadsheet into a table, or more complex such as recording macros or using Power Query. You’ll also see techniques such as Flash Fill and Text to Columns, as well as the often overlooked Custom Lists feature. 

This online CPE webinar covers following key topics:

  • Comparing Center Across Selection to Merged cells for centering text across two or more columns.
  • Eliminating the need to manually resize charts when data is added—automate this with tables instead.
  • Exploring the pros and cons of merging cells in spreadsheets.
  • Linking chart titles to worksheet cells as a step toward a self-updating chart title.
  • Managing data security prompts that may appear when you link external data into Excel spreadsheets.
  • Recording a macro to automate using Center Across Selection.
  • Separating first/last names into two columns without using formulas or retyping.
  • Streamlining repetitive tasks by way of Excel’s Quick Access Toolbar.
  • Streamlining the process of resizing charts after you manually add data.
  • Understanding how the Table feature automates formula management within lists.
  • Using Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns.

Learning Objectives

  • To compare Center Across Selection to Merged cells for centering text across two or more
  • To streamline the process of resizing charts after you manually add data.
  • To separate first/last names into two columns without using formulas or retyping.

Who Should Attend?

  • Accountant
  • Accounting Managers
  • Accounting Practice Owners
  • Accounts Director
  • Bookkeepers & Accountants & Tax Preparers
  • Bookkeepers & Accountants & Tax Preparers
  • Certified Fraud Examiner
  • Certified Information Technology Professionals
  • Certified Public Accountant
  • Cloud Accountants
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial Accountant
  • Entrepreneurial CPA
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • VP Accounts
  • Young CPA

Testimonial

4.6

(562)
65%
30%
4%
1%
0%

JATE

A webinar that helps you save time by being more efficient at what you do with Excel. Liked the presentation of David. The platform was very user friendly and the webinar went on without any glitches. Would highly recommend David and myCPE platform.

DN

One thing that no one can disagree with is the sheer knowledge of Excel that David has. Learnt some great tips and tricks. Thanks David and myCPE.

YQ

I am glad I attended this webinar. The knowledge I gained will surely help me a lot in my professional life.

ML

Thank you David and myCPE for bringing to us this wonderful webinar. It has some great automation techniques which are surely going to help me in various facets of life.

DA

To say that the webinar was insightful would be an understatement. To be honest, I did not expect much from the presenter or the platform, but I am glad I was proven wrong.

JR

The way David taught Macros was great and very easy to grasp.