Content Provider
Excel u logo

Middlebanner tr10312023
Lenning qas ss

EXCEL: 3 SIMPLE WAYS TO IMPROVE RELIABILITY

CPE Processing Fee$10.00
Webinar TranscriptionN/A
Presentation Length Hour(s)1.0 hour
CPE Credits 1.0 hour
Subject Area 1.0 - Other
CE Credits 0.0 hours
Course LevelBasic
Instructional MethodQAS Self-Study
PrerequisitesNone
Advance PreparationNone
Recorded DateFebruary 8, 2017
Date OfferedNovember 19, 2015
Expiration DateNovember 19, 2016
Course Description

Let me ask you a question…what is your #1 most used Excel function of all time? Is it…the SUM function? It shouldn’t be. Well, it shouldn’t be if your goal is to reduce errors in your recurring-use workbooks. We’ll explore a powerful alternative to the SUM function that allows us to perform better summing.

Let me ask you another question. When you insert new data rows, are they automatically included in your formulas? If not, then you probably have errors in your workbook because the formulas don’t include everything they should.

Anticipating how your workbooks may change over time and addressing the related risks up front can help reduce errors in your workbook. In this webinar, we’ll explore three simple ways to improve the reliability of your recurring-use workbooks.

Self-Study Course Instructions:

FOR DOCUMENT-BASED COURSES

Download the course document(s) (below) and follow prompts contained in the document.



FOR RECORDED COURSES WITH VIDEO

Download any course document(s) (below) which may include handouts, glossary, transcripts, etc. Follow any prompts contained in the documents to help you complete the course. Most documents are searchable.

Play the recording, noting the sectional guides indicating where topics on the agenda are covered and the prompts to pause video playback to respond to a review question (located below the video playback area). The timestamps for review questions are also noted below.

Upon completing the video and successfully answering all review questions, you will then take the final exam.

Not logged
Handout Materials
Presentation Slides
Additional Materials
Excel University
Online training
Book
Blog
Author
Review Questions
Review Questions
QUESTION 1: 16 minutes
QUESTION 2: 32 minutes
QUESTION 3: 43 minutes
Frequently Asked Questions
  • CPAacademy self-study courses are online.
  • The self-study format allows you to a) access the material online 24/7 and b) study at your own pace.
  • Per NASBA guidelines, you have one year from date of purchase to complete each program.
  • Complete your final exam at any time and get graded instantly. You can retake the exam at no additional charge (unlimited attempts).
  • Print your own certificate of completion on the spot upon passing the exam.
  • Grading policies: a) courses have a minimum passing score 70% b) test takers will not be provided feedback on failed exams.
  • Upon achieving a passing score, test takers will be notified of the correct answers to the questions missed.

Loading ...

Loading ...
Linkedin

Jeff Lenning, CPA, CITP

Excel University
Author of Excel University
jeff@excelu.com
(949) 200-7688

Excel u logo

Award-winning instructor Jeff Lenning has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient.

User-added image

Nasba
Logo qas

NASBA Approved

CPAacademy.org (Sponsor Id#: 111889) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

CPAacademy.org 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222

About Our Presenter

Excel u logo
If you could learn Excel simply and easily at your pace and could learn the features and functions that are relevant and practical to accounting professionals – would you want to? If you are an accounting professional and have taken Excel classes before, you know the pace can be too fast or too slow, and the content may not be relevant to your work. Excel University explores relevant features that allow you to get your work done quicker, in a self-paced, fun, and engaging way. Become more efficient, streamline processes, and save time with Jeff Lenning’s Excel University. Designed by a CPA for CPAs and accounting professionals, this series covers functions you need, and skips those you don’t. The content has been written from scratch integrating everything Jeff knows about Excel training learned over the past decade of providing continuing professional education.