Author : | Lenny Wu, CPA, CGA, MBA |
Course Length : | Pages: 17 ||| 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 |
Technical Designation: | NonTechnical |
Primary Subject-Field Of Study: | Computer Software & Applications - Computer Software & Applications for Course Id 2213 |
Description : | First, brief introduction to Microsoft Power Query and discuss reasons it has become very popular in Finance and Accounting:
Second part of this course is to demonstrate 6 basic skills in data transformation with Power Query:
Third, we will accelerate our learning with 3 bonus functions that will dramatically increase our productivity. They are:
Last, the course will culminate through the concept of “Instant Consolidation”, which has never been around in MS Excel until Power Query. The instant consolidation is prevalent in cloud-based accounting software. |
Usage Rank : | 12500 |
Release : | 2023 |
Version : | 1.0 |
Prerequisites : | |
Experience Level : | Overview |
Additional Contents : | Complete, no additional material needed. |
Additional Links : |
The Importance of Excel in Business
|
Advance Preparation : | |
Delivery Method : | QAS Self Study |
Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
Revision Date : | 08-Jan-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 : | Video - NASBA QAS - NASBA Registry - 2213 |
Keywords : | Computer Software & Applications, Power, Query, Ultimate, Data, Transformation, Video, cpe, cpa, online course |
Learning Objectives : |
Course Learning Objectives After this course, you will be able to:
|
Course Contents : | Chapter 1 - Power Query: Ultimate Data Transformation Chapter 1 Review Questions Glossary/Index |