0
| Author : | David Ringstrom, CPA |
| Course Length : | Pages: 3 ||| Review Questions: 6 ||| Final Exam Questions: 10 |
| CPE Credits : | 2.0 |
| IRS Credits : | 0 |
| Price : | $29.95 |
| Passing Score : | 70% |
| Course Type: | Video - NASBA QAS - NASBA Registry |
| Primary Subject-Field Of Study: | Computer Software & Applications - Computer Software & Applications for Course Id 1439 |
| Description : |
Payroll related tasks in Excel are often repetitive in nature, and spreadsheet errors can personally affect someone's pay. In this presentation, Excel expert David Ringstrom, CPA, shows how to save time calculating hours and payroll taxes, working with dates/times in Excel, color-coding subsets of data with conditional formatting, password protecting payroll files and worksheets, and using pivot tables to summarize payroll data. You'll even see how to randomly select employees for drug testing or other purposes.
|
| Usage Rank : | 0 |
| Release : | 2018 |
| Version : | 1.0 |
| Prerequisites : | Experience with Excel. |
| Experience Level : | Overview |
| Additional Contents : | Complete, no additional material needed. |
| Additional Links : |
How To: Analyze payroll data using Excel’s SUMIFS function
|
| Advance Preparation : | None. |
| Delivery Method : | QAS Self Study |
| Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
| Revision Date : | 30-May-2021 |
| NASBA Course Declaration : | Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam. |
| Approved Audience : | Video - NASBA QAS - NASBA Registry - 1439 |
| Keywords : | Computer Software & Applications, Agile, Excel, Payroll, Analysis, Video, cpe, cpa, online course |
| Learning Objectives : |
Course Learning Objectives |
| Course Contents : | Chapter 1 - Agile Excel: Payroll Analysis Chapter 1 Review Questions Glossary - Key Terms |
Login/Register