Author : | Joseph P Helstrom, CPA |
Course Length : | Pages: 22 ||| Review Questions: 8 ||| Final Exam Questions: 10 |
CPE Credits : | 2.0 |
IRS Credits : | 0 |
Price : | $17.95 |
Passing Score : | 70% |
Course Type: | NASBA QAS - Text - NASBA Registry |
Technical Designation: | NonTechnical |
Primary Subject-Field Of Study: | Computer Software & Applications - Computer Software & Applications for Course Id 1197 |
Description : |
Remember when you went to update last year’s budget projections and you wondered why certain formulas were there? |
Usage Rank : | 26875 |
Release : | 2020 |
Version : | 1.0 |
Prerequisites : | None. |
Experience Level : | Overview |
Additional Contents : | Complete, no additional material needed. |
Additional Links : |
The Importance of Excel in Business
|
Advance Preparation : | None. |
Delivery Method : | QAS Self Study |
Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
Revision Date : | 01-Mar-2024 |
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 : | NASBA QAS - Text - NASBA Registry - 1197 |
Keywords : | Computer Software & Applications, excel, worksheets, best, practices, cpe, cpa, online course |
Learning Objectives : |
Course Learning Objectives Upon completion of this course, you should be able to:
|
Course Contents : | Chapter 1 - Excel Worksheets - Best Practices Course Overview Worksheet Layout Name the Worksheet Use Headings Use Descriptive Column and Row Headings Segregate Data, Assumptions and Calculations Absolute Cell References Named Ranges Document Data Sources and Key Calculations Using Comments Multiple Worksheet Workbooks Headers and Footers Print Titles Worksheet Design Input Data Check Totals Formulas Require Cell References Rather Than Numbers Use Constraints in Calculations Use Comments to Explain Calculations Review Questions Worksheet Audit and Other Tools to Ensure Accuracy Data Validation Cell Protection and Worksheet Protection Workbook Passwords Highlighting all cells containing formulas Trace Precedent and Dependent Cells Error Checking Watch Window Review Questions Glossary |