0
| Author : | Patricia McCarthy, MBA |
| Course Length : | Pages: 29 ||| Word Count: 10,419 ||| Review Questions: 6 ||| Final Exam Questions: 8 |
| CPE Credits : | 1.5 |
| IRS Credits : | 0 |
| Price : | $13.45 |
| 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 2428 |
| Description : |
Power Query is an Excel feature available within the newest versions of Excel. It used to be an add-in feature called Power Query. Microsoft calls it Power Query as well as Get and Transform and it is a business intelligence tool that allows you to retrieve data from a variety of sources, clean it and then transform or refine the data as needed. For example, you can import a database file, parse data, split or combine columns, change data types, group data and more. You can then take that transformed data back into Excel and analyze it using your preferred methods. What makes this feature exciting is that Excel records all your steps so the data in the file can automatically be refreshed with Excel retrieving the source data, applying the same steps and updating the file for you. This is a huge time saver and will also reduce errors. Version: **This feature is only available in Excel versions starting with Excel 2016. To, see if you have this feature, simply click on the Data tab in Excel. You should see a section of the ribbon called Get & Transform. If you do not see this section, then you do not have the Get & Transform Data feature and will not be able to do any of the exercises in this eBook. If you have the older add-in feature called Power Query you should be able to follow along just fine. You can also download an add-in version if you have an earlier Excel version. Update: This course is based upon Microsoft 365 and updates through November 5, 2024. Depending upon your version, some of the screenshots and commands may differ. |
| Usage Rank : | 35000 |
| Release : | 2024 |
| Version : | 1.0 |
| Prerequisites : | Intermediate to Advanced Knowledge in Excel.
An understanding of how databases work would be very helpful but not necessary. |
| 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 : | 18-Dec-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 - 2428 |
| Keywords : | Computer Software & Applications, Power, Query, Excel, Get, Transform, Data, cpe, cpa, online course |
| Learning Objectives : |
Course Learning Objectives
|
| Course Contents : | Chapter 1 - Power Query in Excel: Get and Transform Data Course Learning Objectives Overview Versions Get & Transform Data Connect Transform Combine Manage Review Questions Importing Data Basics Importing a Text File & Transforming It Clean and Transform Data Clean Data Transform Data Data Type Column Headings Split Columns Group Data Sort Data Review Questions Query Settings Exercise - On Your Own Review Questions More Importing – TRY IT! Close and Load Combining Files Merging Data Optional Exercise – On Your Own Adding a 3rd table Joins Join Example Review Questions Appending Data Unpivot Summary Links for Spreadsheets Glossary |
Login/Register