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

Excel Speed Loop: Systematically Improve Efficiency and Accuracy

4.6 (1856)

Jeff Lenning, CPA

Excel University, Inc.

Tuesday, May 26, 2020 | 12:00 PM EDT

  • CPA

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 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

ias 1 financial statement presentation- ifrs

(1)

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

s-corp preparation, basis calculations & distributions – form 1120s schedule k & k-1 analysis

(4)

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

ethics for tax professionals (latest 2021)

(170)

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

practical guide to fraud including cash, inventory & general frauds (latest)

(1)

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

how to deal effectively with irs examinations and criminal investigations?

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

tips on engaging employees in the midst of crisis

(1)

Jun 23, 2021 | 10:30 AM EDT View Details

quickbooks online for accountants work centre - managing you practice

(2)

Jun 23, 2021 | 10:30 AM EDT View Details

best workshop on partnership & llc (form 1065) tax return review & case study (new)

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

annual federal tax update - individuals (form 1040)

(3)

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

mastering irs representation

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

sox internal controls for accounts payable, receivable & inventory

(2)

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

14 ways to minimize data entry in excel

(153)

Jun 23, 2021 | 12:00 PM EDT View Details

regulatory ethics – data

Jun 23, 2021 | 12:00 PM EDT View Details

controller confidential: 4 ways automation powers accounts payable efficiency

Jun 23, 2021 | 12:00 PM EDT View Details

understanding, detecting and preventing payroll fraud

(1)

Jun 23, 2021 | 12:30 PM EDT View Details

Course Description

The Speed Loop is the method that helps to reduce the time to update Excel workbooks from 2 weeks/month to 2 days/month.

The Speed Loop process provides a systematic approach for optimizing your workbooks for efficiency and accuracy. If you feel like improving your workbooks, but aren't sure where to start or which specific steps to take, this webinar is for you. Excel is a big place with many features and functions. This can feel overwhelming and like there is no organized process for workbook improvement. There is, and it is called the Speed Loop. 

With the help of speed loop there is significant time saving, and I share that same process through this free CPE webinar so you can get your work done faster as well. To get your work done fast in Excel requires two things: process & skills. In this webinar, I focus on the Speed Loop process. Excel skills are the features and functions you need to automate manual tasks. To illustrate the Speed Loop process, we'll cover some very important skills including Power Query, PivotTables, Tables, MAX, and more.

We look forward to sharing the Speed Loop with you, and We hope it can help you get your work done faster as well. Recommended for Accounting and Tax Professionals who can benefit by learning a variety of techniques and shortcuts that will speed up their work in Excel

Learning Objectives

  • To recall the 7 steps of the Speed Loop process
  • To identify how to use Power Query to import a CSV file
  • To recall the arguments of MAX
  • To identify one benefit of using Pivot Tables compared to formulas

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Accounting Practice Owners
  • Accounts Director
  • Auditors
  • Bookkeeper
  • Business Owner
  • CFO/Controller
  • Chief Accounting Officer
  • Cloud Accountants
  • Cloud Firms
  • Compliance Officers
  • CPA (Industry)
  • CPA - Large Firm
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Entrepreneurial Accountant
  • Entrepreneurial CPA
  • Finance Director
  • Finance Pros
  • Innovation Manager/Director
  • Legal Professionals
  • Non Profit Pros
  • QB Pro Advisor
  • Senior Accountant
  • Staff of Accounting Firm
  • Young CPA

Testimonial

Array
(
    [no_of_record] => 1856
    [average] => 4.5921
)
 

4.6

(1856)
67%
26%
5%
1%
0%

MLC

Jeff took time to describe each function in depth and step by step walk through showing you exactly how to execute.. Very good, would recommend. Thank you myCPE.

KW

Extremely Great Presentation. Nice learning experience on speed loop process. Presenter explained it step by step process of the excel functions to automate the task. Thanks Jeff for wonderful presentation.

JR

Jeff explained it very clearly about the speed loop function to optimized the workbook. I have attended a lot of training in the past. This was one of the better ones I've been to.

VS

As someone getting back up to speed in Excel, after many years of only needing basic functionality, I learned so many time-saving tips in this webinar. Jeff's enthusiasm is infectious and I found myself wanting to go directly to the Excel University website and sign up when the webinar completed.

CW

Jeff is an EXCELLENT instructor; you can tell he loves his subject and is excited to share his knowledge to make your work easier. If you're not particularly an Excel person but like to learn new things beware, his enthusiasm will change your viewpoint. I'll look forward to taking ANY class he teaches, even with my busy schedule. Definitely a don't miss an appointment!

NP

testing review added by nikunj patel.