0
| Author : | Lenny Wu, CPA, CGA, MBA |
| Course Length : | Pages: 26 ||| Review Questions: 5 ||| Final Exam Questions: 8 |
| CPE Credits : | 1.5 |
| IRS Credits : | 0 |
| Price : | $21.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 1779 |
| Description : | The course is presented in five parts. First, the course reveals the fact Excel has as many as 7 languages that are needed for proper modeling! Next, the course shows as many as 4 types of formulas in Excel. They are:
Third, we explain in details how to decipher the custom formatting language, and proper ways of displaying in thousands, in color, or hidden in its entirety. Fourth, we review the formulas of calculated fields and calculated items used in Pivot tables. Also, we demonstrate ways to build a dynamic named range for easy reference. Last, we explore basic VBA codes, the M language and the DAX language in Excel. They include:
Please Note: This course’s author is working on the providing transcripts, PDFs, and slides where applicable. Unfortunately until then we will not be able to offer them with the course but felt the course was valuable enough as it is so have chosen to include it on our site. Our sincere apologies for any inconvenience and please let us know any question using the support bubble on the bottom right of all pages on our site. |
| Usage Rank : | 0 |
| Release : | 2021 |
| Version : | 1.0 |
| Prerequisites : | |
| Experience Level : | Overview |
| Additional Contents : | Complete, no additional material needed. |
| Additional Links : |
The 7 Best Online Excel Classes of 2021
|
| Advance Preparation : |
Course Learning Objectives After this course, you will be able to:
|
| Delivery Method : | QAS Self Study |
| Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
| Revision Date : | 23-Jan-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 - 1779 |
| Keywords : | Computer Software & Applications, Excel, Magic, Part6, Speaking, 7Languages, Excel, Video, cpe, cpa, online course |
| Learning Objectives : |
Course Learning Objectives After this course, you will be able to:
|
| Course Contents : | Chapter 1 - Excel Magic (Part 6): Speaking the 7 Languages in Excel Chapter 1 Review Questions Glossary |
Login/Register