Author : | Lenny Wu, CPA, CGA, MBA |
Course Length : | Pages: 31 ||| 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 2215 |
Description : | The course is presented in four parts. First, brief introduction to Power Query and discuss reasons it has become very popular in Finance and Accounting:
Second part demonstrates 7 intermediate formulas in data transformation with Power Query:
Third, we accelerate our learning with 6 advanced functions that dramatically increase our productivity. They relate to:
Last, the course culminates through introducing the concept of “Instant Consolidation” and “Self-service Reporting”, and teaches the expert level of automating the whole data refresh cycle through controlled period selection from a Timeline! |
Usage Rank : | 10000 |
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 : | 15-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 - 2215 |
Keywords : | Computer Software & Applications, Power, Query, Part2, Building, Instant, Consolidation, Video, cpe, cpa, online course |
Learning Objectives : |
Course Learning Objectives After this course, you will be able to:
|
Course Contents : | Chapter 1 - Power Query (Part 2): Building an Instant Consolidation Chapter 1 Review Questions Glossary/Index |