{"product_id":"data-analytics-with-power-query","title":"AICPA Power Query Course for Accountants | 4 CPE","description":"\u003cstyle\u003e\n  .ey-product {\n    max-width: 1120px;\n    margin: 0 auto;\n    font-family: Inter, system-ui, -apple-system, BlinkMacSystemFont, \"Segoe UI\", sans-serif;\n    color: #1f2933;\n    line-height: 1.65;\n  }\n\n  .ey-product * {\n    box-sizing: border-box;\n  }\n\n  .ey-product a {\n    color: #075985;\n    text-decoration: underline;\n    text-underline-offset: 3px;\n  }\n\n  .ey-hero {\n    background: linear-gradient(135deg, #eff6ff 0%, #f8fafc 52%, #ecfeff 100%);\n    border: 1px solid #dbeafe;\n    border-radius: 22px;\n    padding: 34px 28px;\n    margin: 18px 0 28px;\n  }\n\n  .ey-kicker {\n    display: inline-block;\n    background: #dbeafe;\n    color: #1e3a8a;\n    font-weight: 800;\n    font-size: 13px;\n    letter-spacing: .02em;\n    padding: 6px 10px;\n    border-radius: 999px;\n    margin-bottom: 14px;\n  }\n\n  .ey-hero h1 {\n    font-size: clamp(30px, 5vw, 48px);\n    line-height: 1.08;\n    margin: 0 0 16px;\n    color: #0f172a;\n  }\n\n  .ey-lede {\n    font-size: 18px;\n    color: #334155;\n    max-width: 870px;\n    margin: 0 0 20px;\n  }\n\n  .ey-grid {\n    display: grid;\n    grid-template-columns: repeat(4, minmax(0, 1fr));\n    gap: 14px;\n    margin: 24px 0;\n  }\n\n  .ey-card {\n    background: #ffffff;\n    border: 1px solid #e2e8f0;\n    border-radius: 16px;\n    padding: 18px;\n    box-shadow: 0 8px 22px rgba(15, 23, 42, 0.04);\n  }\n\n  .ey-card strong {\n    display: block;\n    color: #0f172a;\n    font-size: 15px;\n    margin-bottom: 4px;\n  }\n\n  .ey-card span {\n    color: #475569;\n    font-size: 14px;\n  }\n\n  .ey-cta-row {\n    display: flex;\n    flex-wrap: wrap;\n    gap: 12px;\n    margin-top: 22px;\n  }\n\n  .ey-btn {\n    display: inline-flex;\n    align-items: center;\n    justify-content: center;\n    padding: 13px 18px;\n    border-radius: 12px;\n    font-weight: 800;\n    text-decoration: none !important;\n  }\n\n  .ey-btn-primary {\n    background: #0f766e;\n    color: #ffffff !important;\n  }\n\n  .ey-btn-secondary {\n    background: #ffffff;\n    color: #0f172a !important;\n    border: 1px solid #cbd5e1;\n  }\n\n  .ey-box {\n    background: #f8fafc;\n    border: 1px solid #e2e8f0;\n    border-radius: 18px;\n    padding: 22px;\n    margin: 24px 0;\n  }\n\n  .ey-note {\n    background: #fffbeb;\n    border: 1px solid #fde68a;\n    border-radius: 16px;\n    padding: 18px;\n    margin: 22px 0;\n  }\n\n  .ey-success {\n    background: #ecfdf5;\n    border: 1px solid #bbf7d0;\n    border-radius: 16px;\n    padding: 18px;\n    margin: 22px 0;\n  }\n\n  .ey-product h2 {\n    font-size: clamp(24px, 3vw, 34px);\n    line-height: 1.18;\n    color: #0f172a;\n    margin: 38px 0 12px;\n  }\n\n  .ey-product h3 {\n    font-size: 21px;\n    line-height: 1.25;\n    color: #1e293b;\n    margin: 26px 0 10px;\n  }\n\n  .ey-product p {\n    margin: 0 0 14px;\n  }\n\n  .ey-product ul,\n  .ey-product ol {\n    margin: 10px 0 18px 22px;\n    padding: 0;\n  }\n\n  .ey-product li {\n    margin: 7px 0;\n  }\n\n  .ey-toc {\n    background: #ffffff;\n    border: 1px solid #cbd5e1;\n    border-radius: 18px;\n    padding: 20px;\n    margin: 24px 0;\n  }\n\n  .ey-toc h2 {\n    margin-top: 0;\n    font-size: 22px;\n  }\n\n  .ey-toc ul {\n    columns: 2;\n    margin-bottom: 0;\n  }\n\n  .ey-table-wrap {\n    overflow-x: auto;\n    border: 1px solid #e2e8f0;\n    border-radius: 16px;\n    margin: 18px 0 26px;\n  }\n\n  .ey-product table {\n    width: 100%;\n    border-collapse: collapse;\n    min-width: 720px;\n    background: #ffffff;\n  }\n\n  .ey-product th {\n    background: #0f172a;\n    color: #ffffff;\n    text-align: left;\n    padding: 14px;\n    font-size: 14px;\n  }\n\n  .ey-product td {\n    border-top: 1px solid #e2e8f0;\n    padding: 14px;\n    vertical-align: top;\n    color: #334155;\n  }\n\n  .ey-faq details {\n    border: 1px solid #e2e8f0;\n    border-radius: 14px;\n    padding: 15px 17px;\n    margin: 12px 0;\n    background: #ffffff;\n  }\n\n  .ey-faq summary {\n    cursor: pointer;\n    font-weight: 800;\n    color: #0f172a;\n  }\n\n  .ey-small {\n    font-size: 13px;\n    color: #64748b;\n  }\n\n  @media (max-width: 840px) {\n    .ey-grid {\n      grid-template-columns: repeat(2, minmax(0, 1fr));\n    }\n\n    .ey-toc ul {\n      columns: 1;\n    }\n  }\n\n  @media (max-width: 520px) {\n    .ey-grid {\n      grid-template-columns: 1fr;\n    }\n\n    .ey-hero {\n      padding: 26px 18px;\n    }\n  }\n\u003c\/style\u003e\n\u003cdiv class=\"ey-product\"\u003e\n\u003csection class=\"ey-hero\"\u003e\u003cspan class=\"ey-kicker\"\u003eAICPA \u0026amp; CIMA course | SKU BLI509919 | 4 CPE\u003c\/span\u003e\n\u003ch2\u003eAICPA Power Query Course for Accountants and Finance Professionals\u003c\/h2\u003e\n\u003cp class=\"ey-lede\"\u003eIntroduction to Data Analytics with Power Query (Get and Transform) is an AICPA \u0026amp; CIMA online course for finance professionals who want to clean, combine and prepare data faster in Excel. It is especially useful if your monthly work still includes copy-paste reporting, manual data cleanup, repeated GL exports or messy spreadsheet consolidation.\u003c\/p\u003e\n\u003cdiv class=\"ey-grid\"\u003e\n\u003cdiv class=\"ey-card\"\u003e\n\u003cstrong\u003e4 CPE credits\u003c\/strong\u003e \u003cspan\u003eAICPA lists the course under Information Technology.\u003c\/span\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"ey-card\"\u003e\n\u003cstrong\u003eAdvanced level\u003c\/strong\u003e \u003cspan\u003eBest for confident Excel users who work with business data.\u003c\/span\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"ey-card\"\u003e\n\u003cstrong\u003e1-year availability\u003c\/strong\u003e \u003cspan\u003eThe official AICPA listing shows 1 year of access.\u003c\/span\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"ey-card\"\u003e\n\u003cstrong\u003eSKU BLI509919\u003c\/strong\u003e \u003cspan\u003eProduct number confirmed from the official course listing.\u003c\/span\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"ey-cta-row\"\u003e\n\u003ca title=\"Buy AICPA Power Query course through Eduyush\" href=\"#buy-through-eduyush\" class=\"ey-btn ey-btn-primary\"\u003eBuy through Eduyush\u003c\/a\u003e \u003ca title=\"View AICPA Power Query course facts\" href=\"#course-facts\" class=\"ey-btn ey-btn-secondary\"\u003eView course facts\u003c\/a\u003e\n\u003c\/div\u003e\n\u003c\/section\u003e\n\u003csection class=\"ey-box\"\u003e\n\u003ch2 style=\"margin-top: 0;\"\u003eKey takeaways for quick decision-making\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003eThis course is best for accountants, auditors, FP\u0026amp;A analysts and finance managers who use Excel and want faster data preparation workflows.\u003c\/li\u003e\n\u003cli\u003eAICPA lists the official title as Introduction to Data Analytics with Power Query (Get and Transform), with product number BLI509919.\u003c\/li\u003e\n\u003cli\u003eThe official course page lists 4 CPE credits, online format, Information Technology field of study, advanced level and 1-year availability.\u003c\/li\u003e\n\u003cli\u003ePower Query is useful for repeatable finance tasks such as importing data, transforming columns, combining files, loading to Excel or the Data Model, and refreshing queries.\u003c\/li\u003e\n\u003cli\u003eThe official AICPA page does not state a digital badge for this SKU, so learners wanting a badge may also consider the \u003ca title=\"View AICPA Data Analytics Core Concepts Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/aicpa-certification-data-analytics-core-concepts-certificate\" target=\"_blank\"\u003eData Analytics Core Concepts Certificate\u003c\/a\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/section\u003e\n\u003cnav aria-label=\"Table of contents\" class=\"ey-toc\"\u003e\n\u003ch2\u003eQuick navigation\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca title=\"What is Power Query for accountants\" href=\"#what-is-power-query\"\u003eWhat is Power Query?\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Official AICPA Power Query course facts\" href=\"#course-facts\"\u003eOfficial course facts\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Who should take Power Query course\" href=\"#who-should-take\"\u003eWho should take it?\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"What you learn in AICPA Power Query course\" href=\"#what-you-learn\"\u003eWhat you learn\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Power Query finance use cases\" href=\"#finance-use-cases\"\u003eFinance use cases\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"AICPA data analytics learning pathway\" href=\"#learning-pathway\"\u003eLearning pathway\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Why buy through Eduyush\" href=\"#buy-through-eduyush\"\u003eWhy Eduyush\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Power Query course FAQs\" href=\"#faq\"\u003eFAQs\u003c\/a\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/nav\u003e\n\u003csection id=\"what-is-power-query\"\u003e\n\u003ch2\u003eWhat is Power Query in Excel for accountants?\u003c\/h2\u003e\n\u003cp\u003ePower Query, also called Get \u0026amp; Transform in Excel, helps users connect to external data, shape it, combine it and load it into Excel for reporting. Microsoft describes the four main phases as Connect, Transform, Combine and Load, which matches how accountants usually prepare data before analysis.\u003c\/p\u003e\n\u003cp\u003eMicrosoft also explains that Power Query records transformation steps and runs them automatically when a query is refreshed. That makes it useful for recurring finance work where the source file changes each month but the cleanup steps stay mostly the same.\u003c\/p\u003e\n\u003cdiv class=\"ey-table-wrap\"\u003e\n\u003ctable\u003e\n\u003cthead\u003e\n\u003ctr\u003e\n\u003cth\u003ePower Query step\u003c\/th\u003e\n\u003cth\u003eWhat it means in finance work\u003c\/th\u003e\n\u003cth\u003eSimple example\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eConnect\u003c\/td\u003e\n\u003ctd\u003eBring data into Excel from files, databases, web sources or other supported sources.\u003c\/td\u003e\n\u003ctd\u003eConnect to monthly sales files saved in a folder.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTransform\u003c\/td\u003e\n\u003ctd\u003eClean and reshape data without changing the original source.\u003c\/td\u003e\n\u003ctd\u003eRemove blank rows, fix date formats and split account codes.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eCombine\u003c\/td\u003e\n\u003ctd\u003eAppend or merge multiple tables into a cleaner analysis view.\u003c\/td\u003e\n\u003ctd\u003eCombine twelve monthly GL exports into one table.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eLoad\u003c\/td\u003e\n\u003ctd\u003eSend prepared data to a worksheet or the Excel Data Model.\u003c\/td\u003e\n\u003ctd\u003eLoad cleaned data into a management report model.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/div\u003e\n\u003cp class=\"ey-small\"\u003eExternal source: \u003ca title=\"Microsoft guide to Power Query in Excel\" rel=\"noopener\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a\" target=\"_blank\"\u003eMicrosoft guide to Power Query in Excel\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/section\u003e\n\u003csection id=\"course-facts\"\u003e\n\u003ch2\u003eAICPA Introduction to Data Analytics with Power Query official course facts\u003c\/h2\u003e\n\u003cp\u003eThe official AICPA \u0026amp; CIMA listing describes this course as an online advanced-level Information Technology course with 4 CPE credits. The page states that Power Query is used for extracting, transforming and preparing data for analysis.\u003c\/p\u003e\n\u003cdiv class=\"ey-table-wrap\"\u003e\n\u003ctable\u003e\n\u003cthead\u003e\n\u003ctr\u003e\n\u003cth\u003eCourse detail\u003c\/th\u003e\n\u003cth\u003eOfficial information\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eOfficial title\u003c\/td\u003e\n\u003ctd\u003eIntroduction to Data Analytics with Power Query (Get and Transform)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eProduct number \/ SKU\u003c\/td\u003e\n\u003ctd\u003eBLI509919\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eFormat\u003c\/td\u003e\n\u003ctd\u003eOnline\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eCPE credits\u003c\/td\u003e\n\u003ctd\u003e4\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eNASBA field of study\u003c\/td\u003e\n\u003ctd\u003eInformation Technology\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eLevel\u003c\/td\u003e\n\u003ctd\u003eAdvanced\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eAvailability\u003c\/td\u003e\n\u003ctd\u003e1 year\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eAuthor\u003c\/td\u003e\n\u003ctd\u003eDonald Tomoff\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eWho benefits\u003c\/td\u003e\n\u003ctd\u003eAny business professional responsible for managing and working with data\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eDigital badge\u003c\/td\u003e\n\u003ctd\u003eNot stated on the official product page for this SKU\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eOfficial source\u003c\/td\u003e\n\u003ctd\u003e\u003ca title=\"Official AICPA Introduction to Data Analytics with Power Query course page\" rel=\"noopener\" href=\"https:\/\/www.aicpa-cima.com\/cpe-learning\/course\/introduction-to-data-analytics-with-power-query--get-and-transform-in-excel-2016-BLI\" target=\"_blank\"\u003eAICPA \u0026amp; CIMA course page\u003c\/a\u003e\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/div\u003e\n\u003cp class=\"ey-small\"\u003eLast verified: May 13, 2026. Product facts, access terms and pricing can change, so check the official AICPA \u0026amp; CIMA page before publishing time-sensitive details.\u003c\/p\u003e\n\u003c\/section\u003e\n\u003csection id=\"who-should-take\"\u003e\n\u003ch2\u003eWho should take the AICPA Power Query course for accountants?\u003c\/h2\u003e\n\u003cp\u003eThis course fits professionals who already work with Excel data and want to reduce repetitive preparation work. It is not a beginner Excel course. It is better for users who understand tables, reports and finance data, and now want to make their preparation steps more repeatable.\u003c\/p\u003e\n\u003cdiv class=\"ey-table-wrap\"\u003e\n\u003ctable\u003e\n\u003cthead\u003e\n\u003ctr\u003e\n\u003cth\u003eLearner profile\u003c\/th\u003e\n\u003cth\u003eWhy Power Query helps\u003c\/th\u003e\n\u003cth\u003eTypical task improved\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eAccountant or senior accountant\u003c\/td\u003e\n\u003ctd\u003eMonth-end files often need the same cleanup every period.\u003c\/td\u003e\n\u003ctd\u003eStandardising trial balance, GL and expense exports.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eAuditor\u003c\/td\u003e\n\u003ctd\u003eClient data usually arrives in different formats and needs cleaning before testing.\u003c\/td\u003e\n\u003ctd\u003ePreparing transaction files for sampling or exception review.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eFP\u0026amp;A analyst\u003c\/td\u003e\n\u003ctd\u003eForecasts and management reports often pull from several files.\u003c\/td\u003e\n\u003ctd\u003eCombining actuals, budgets and revised forecasts.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eController\u003c\/td\u003e\n\u003ctd\u003eReporting packs become easier when recurring transformations are saved.\u003c\/td\u003e\n\u003ctd\u003eRefreshing monthly dashboards from updated source data.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eFinance manager\u003c\/td\u003e\n\u003ctd\u003ePower Query helps check and reshape data before analysis.\u003c\/td\u003e\n\u003ctd\u003ePreparing sales, margin and working capital data for review.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/div\u003e\n\u003c\/section\u003e\n\u003csection id=\"what-you-learn\"\u003e\n\u003ch2\u003eWhat will you learn in Introduction to Data Analytics with Power Query?\u003c\/h2\u003e\n\u003cp\u003eYou will learn how to import data into Excel, transform it, choose between loading to a worksheet or the Data Model, and add fields that make analysis more flexible. The course is practical because it focuses on data preparation, which is usually the first step before reporting or analytics.\u003c\/p\u003e\n\u003ch3\u003eOfficial major topics\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003ePower Query, also known in Excel 2016 as Get and Transform.\u003c\/li\u003e\n\u003cli\u003eExtracting and transforming data as the first step to data analysis and reporting.\u003c\/li\u003e\n\u003cli\u003eTop features most important to accountants, including data source flexibility, appending queries and unpivoting.\u003c\/li\u003e\n\u003cli\u003eReal Power Query use cases that accountants can apply in work.\u003c\/li\u003e\n\u003cli\u003eExcel workbooks for participant practice, as stated on the AICPA listing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eOfficial learning objectives\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eImport and transform basic data into Excel using Power Query.\u003c\/li\u003e\n\u003cli\u003eUnderstand and apply the data load capabilities of loading into Excel versus loading into the Data Model, and why it matters.\u003c\/li\u003e\n\u003cli\u003eTransform data and add extra fields to the data set to improve flexibility for analysis.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cdiv class=\"ey-note\"\u003e\n\u003cstrong\u003ePractical note:\u003c\/strong\u003e This is a short 4 CPE course, so it should be treated as a focused introduction to Power Query for finance work. If you want a wider certificate with a digital badge, compare it with the \u003ca title=\"View AICPA Data Processing and Analysis Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/data-processing-and-analysis-certificate\" target=\"_blank\"\u003eData Processing and Analysis Certificate\u003c\/a\u003e.\u003c\/div\u003e\n\u003c\/section\u003e\n\u003csection id=\"finance-use-cases\"\u003e\n\u003ch2\u003ePower Query use cases for accounting, audit and FP\u0026amp;A teams\u003c\/h2\u003e\n\u003cp\u003ePower Query is valuable when the same messy data problem repeats every week or month. The tool records the preparation steps, so a finance professional can refresh the query when the next file arrives instead of rebuilding the cleanup manually.\u003c\/p\u003e\n\u003cdiv class=\"ey-table-wrap\"\u003e\n\u003ctable\u003e\n\u003cthead\u003e\n\u003ctr\u003e\n\u003cth\u003eManual finance problem\u003c\/th\u003e\n\u003cth\u003ePower Query workflow\u003c\/th\u003e\n\u003cth\u003eWhy it matters\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eMonthly GL exports arrive with extra rows and inconsistent headings.\u003c\/td\u003e\n\u003ctd\u003eRemove rows, rename columns, set data types and save the query steps.\u003c\/td\u003e\n\u003ctd\u003eThe trainee does not need to repeat the same cleanup from memory next month.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eSales data is split across twelve monthly files.\u003c\/td\u003e\n\u003ctd\u003eAppend files into one combined query.\u003c\/td\u003e\n\u003ctd\u003eThe CFO gets one clean sales table instead of a folder full of separate files.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eCustomer names differ between billing and collection reports.\u003c\/td\u003e\n\u003ctd\u003eMerge datasets using a common key where available.\u003c\/td\u003e\n\u003ctd\u003eReceivables review becomes easier because data sources can be compared in one place.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eA trial balance export has columns that need to become rows.\u003c\/td\u003e\n\u003ctd\u003eUse unpivoting to reshape the table.\u003c\/td\u003e\n\u003ctd\u003eThe data becomes suitable for pivot tables, dashboards and analysis.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eA report must be rebuilt every month from the newest source file.\u003c\/td\u003e\n\u003ctd\u003eRefresh the query after replacing or updating the source file.\u003c\/td\u003e\n\u003ctd\u003eReporting becomes less dependent on manual copy-paste steps.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/div\u003e\n\u003ch3\u003eA small month-end example\u003c\/h3\u003e\n\u003cp\u003eA finance trainee receives a 60,000-line expense export every month. In April, she manually deletes unused columns, filters blank rows, fixes department names and adds a cost centre category. In May, Power Query can repeat those recorded steps after she refreshes the query. The work still needs review, but the boring part becomes much less fragile.\u003c\/p\u003e\n\u003c\/section\u003e\n\u003csection id=\"learning-pathway\"\u003e\n\u003ch2\u003eWhere does Power Query fit in the AICPA data analytics learning pathway?\u003c\/h2\u003e\n\u003cp\u003ePower Query is the practical Excel tool layer of the data analytics journey. The AICPA data analytics certificate page lists certificates for accounting and finance professionals that cover foundational concepts, data processing techniques, visualization skills and communication of insights.\u003c\/p\u003e\n\u003cdiv class=\"ey-table-wrap\"\u003e\n\u003ctable\u003e\n\u003cthead\u003e\n\u003ctr\u003e\n\u003cth\u003eLearning need\u003c\/th\u003e\n\u003cth\u003eRecommended Eduyush page\u003c\/th\u003e\n\u003cth\u003eHow it connects\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eI need the foundation first\u003c\/td\u003e\n\u003ctd\u003e\u003ca title=\"View AICPA Data Analytics Core Concepts Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/aicpa-certification-data-analytics-core-concepts-certificate\" target=\"_blank\"\u003eData Analytics Core Concepts\u003c\/a\u003e\u003c\/td\u003e\n\u003ctd\u003eStart here if you want the language and mindset of analytics.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eI want to prepare and analyze data more deeply\u003c\/td\u003e\n\u003ctd\u003e\u003ca title=\"View AICPA Data Processing and Analysis Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/data-processing-and-analysis-certificate\" target=\"_blank\"\u003eData Processing and Analysis\u003c\/a\u003e\u003c\/td\u003e\n\u003ctd\u003eMove here for broader data preparation and analysis concepts.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eI want to present insights better\u003c\/td\u003e\n\u003ctd\u003e\u003ca title=\"View AICPA Data Visualization and Communication Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/data-visualization-and-communication-certificate\" target=\"_blank\"\u003eData Visualization and Communication\u003c\/a\u003e\u003c\/td\u003e\n\u003ctd\u003eUse this when the challenge is charts, storytelling and stakeholder communication.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eI want hands-on Excel automation\u003c\/td\u003e\n\u003ctd\u003e\u003ca title=\"View AICPA Power Query course on Eduyush\" href=\"https:\/\/eduyush.com\/products\/data-analytics-with-power-query\" target=\"_blank\"\u003ePower Query course\u003c\/a\u003e\u003c\/td\u003e\n\u003ctd\u003eUse this course to apply data preparation ideas inside Excel.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eI want to compare all data courses\u003c\/td\u003e\n\u003ctd\u003e\u003ca title=\"Browse AICPA data analytics courses on Eduyush\" href=\"https:\/\/eduyush.com\/en-us\/collections\/data-analytics\" target=\"_blank\"\u003eData analytics collection\u003c\/a\u003e\u003c\/td\u003e\n\u003ctd\u003eCompare AICPA \u0026amp; CIMA data analytics options in one place.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/div\u003e\n\u003cp class=\"ey-small\"\u003eOfficial pathway source: \u003ca title=\"Official AICPA data analytics certificates page\" rel=\"noopener\" href=\"https:\/\/www.aicpa-cima.com\/resources\/landing\/data-analytics-certificates\" target=\"_blank\"\u003eAICPA \u0026amp; CIMA Data Analytics Certificates\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/section\u003e\n\u003csection id=\"buy-through-eduyush\"\u003e\n\u003ch2\u003eWhy buy the AICPA Power Query course through Eduyush?\u003c\/h2\u003e\n\u003cp\u003eEduyush supports eligible learners with regional purchase guidance, local payment convenience and activation help for AICPA \u0026amp; CIMA learning products. This is useful when you want to choose between a short Power Query course and a broader AICPA data analytics certificate.\u003c\/p\u003e\n\u003cdiv class=\"ey-table-wrap\"\u003e\n\u003ctable\u003e\n\u003cthead\u003e\n\u003ctr\u003e\n\u003cth\u003eWhat you may need\u003c\/th\u003e\n\u003cth\u003eHow Eduyush helps\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eCourse selection\u003c\/td\u003e\n\u003ctd\u003eGuidance on whether this 4 CPE Power Query course is enough or whether a certificate pathway is better.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eRegional purchase support\u003c\/td\u003e\n\u003ctd\u003eLocal purchase experience and regional pricing where available on Eduyush.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eActivation support\u003c\/td\u003e\n\u003ctd\u003ePost-purchase help for access and activation queries.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eRelated learning path\u003c\/td\u003e\n\u003ctd\u003eContext across \u003ca title=\"Browse AICPA certificate programs on Eduyush\" href=\"https:\/\/eduyush.com\/collections\/aicpa-certifications\" target=\"_blank\"\u003eAICPA certificate programs\u003c\/a\u003e, data analytics and finance upskilling pages.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"ey-success\"\u003e\n\u003cstrong\u003eBest fit:\u003c\/strong\u003e Buy this course if you already use Excel regularly and want to learn how Power Query can reduce repeated data preparation work. If you want a credential with a digital badge, check the AICPA data analytics certificate pages before choosing.\u003c\/div\u003e\n\u003c\/section\u003e\n\u003csection\u003e\n\u003ch2\u003eHow to complete the AICPA Power Query course\u003c\/h2\u003e\n\u003cp\u003eSince this is a focused 4 CPE course, most learners should treat it as a practical Excel skill sprint. Keep one messy finance file ready while studying so the concepts connect to your actual work.\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003ePurchase the course through Eduyush.\u003c\/li\u003e\n\u003cli\u003eComplete activation and access the online course.\u003c\/li\u003e\n\u003cli\u003eWork through the Power Query examples and practice files where provided.\u003c\/li\u003e\n\u003cli\u003eTry one real finance use case from your own work, such as cleaning a GL export or combining monthly reports.\u003c\/li\u003e\n\u003cli\u003eRecord the 4 CPE credits according to your professional body or state board requirements.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003c\/section\u003e\n\u003csection class=\"ey-faq\" id=\"faq\"\u003e\n\u003ch2\u003eFAQs on the AICPA Power Query course for accountants\u003c\/h2\u003e\n\u003cdetails\u003e\n\u003csummary\u003eWhat is the official title of this Power Query course?\u003c\/summary\u003e\n\u003cp\u003eThe official AICPA \u0026amp; CIMA title is Introduction to Data Analytics with Power Query (Get and Transform). The product number or SKU is BLI509919.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n\u003csummary\u003eHow many CPE credits does the course provide?\u003c\/summary\u003e\n\u003cp\u003eThe official AICPA \u0026amp; CIMA listing shows 4 CPE credits. The NASBA field of study shown on the course page is Information Technology.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n\u003csummary\u003eIs the course beginner level?\u003c\/summary\u003e\n\u003cp\u003eNo. The official AICPA \u0026amp; CIMA listing shows the level as Advanced. It is best for users who are comfortable working with Excel data and want to learn Power Query for cleaner, repeatable data preparation.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n\u003csummary\u003eDoes this Power Query course include a digital badge?\u003c\/summary\u003e\n\u003cp\u003eThe official AICPA product page for SKU BLI509919 does not state a digital badge. If you need a badge, compare the AICPA data analytics certificate products on Eduyush before purchasing.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n\u003csummary\u003eIs Power Query useful for accountants?\u003c\/summary\u003e\n\u003cp\u003eYes. Power Query is useful for accountants because many finance tasks involve importing, cleaning, combining and refreshing data. It is especially helpful for monthly reports, GL exports, sales files, budget files and recurring analysis packs.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n\u003csummary\u003eIs Power Query the same as Get and Transform?\u003c\/summary\u003e\n\u003cp\u003eMicrosoft describes Power Query as known as Get \u0026amp; Transform in Excel. It helps users connect, transform, combine and load data for reporting and analysis.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n\u003csummary\u003eShould I take Data Analytics Core Concepts before this course?\u003c\/summary\u003e\n\u003cp\u003eIt depends on your confidence. If you understand the basics of analytics and want hands-on Excel automation, this Power Query course can be a good fit. If you are new to analytics language and project framing, start with Data Analytics Core Concepts first.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003c\/section\u003e\n\u003csection class=\"ey-box\"\u003e\n\u003ch2 style=\"margin-top: 0;\"\u003eOfficial sources and related Eduyush pages\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca title=\"Official AICPA Power Query course page\" rel=\"noopener\" href=\"https:\/\/www.aicpa-cima.com\/cpe-learning\/course\/introduction-to-data-analytics-with-power-query--get-and-transform-in-excel-2016-BLI\" target=\"_blank\"\u003eOfficial AICPA Power Query course page\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Microsoft Power Query in Excel guide\" rel=\"noopener\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a\" target=\"_blank\"\u003eMicrosoft Power Query guide\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Official AICPA data analytics certificates pathway\" rel=\"noopener\" href=\"https:\/\/www.aicpa-cima.com\/resources\/landing\/data-analytics-certificates\" target=\"_blank\"\u003eOfficial AICPA data analytics certificates page\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Browse AICPA data analytics courses on Eduyush\" href=\"https:\/\/eduyush.com\/en-us\/collections\/data-analytics\" target=\"_blank\"\u003eEduyush data analytics collection\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"View AICPA Data Analytics Core Concepts Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/aicpa-certification-data-analytics-core-concepts-certificate\" target=\"_blank\"\u003eData Analytics Core Concepts Certificate\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"View Data Processing and Analysis Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/data-processing-and-analysis-certificate\" target=\"_blank\"\u003eData Processing and Analysis Certificate\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"View Data Visualization and Communication Certificate on Eduyush\" href=\"https:\/\/eduyush.com\/products\/data-visualization-and-communication-certificate\" target=\"_blank\"\u003eData Visualization and Communication Certificate\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca title=\"Browse AICPA certificate programs on Eduyush\" href=\"https:\/\/eduyush.com\/collections\/aicpa-certifications\" target=\"_blank\"\u003eAICPA certificate programs on Eduyush\u003c\/a\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/section\u003e\n\u003cscript type=\"application\/ld+json\"\u003e\n  {\n    \"@context\": \"https:\/\/schema.org\",\n    \"@type\": \"Course\",\n    \"name\": \"Introduction to Data Analytics with Power Query (Get and Transform)\",\n    \"description\": \"AICPA \u0026 CIMA online course for accounting and finance professionals who want to learn Power Query for importing, transforming and preparing data in Excel.\",\n    \"courseCode\": \"BLI509919\",\n    \"provider\": {\n      \"@type\": \"Organization\",\n      \"name\": \"AICPA \u0026 CIMA\",\n      \"url\": \"https:\/\/www.aicpa-cima.com\/cpe-learning\/course\/introduction-to-data-analytics-with-power-query--get-and-transform-in-excel-2016-BLI\"\n    },\n    \"educationalLevel\": \"Advanced\",\n    \"courseMode\": \"Online\",\n    \"teaches\": [\n      \"Power Query in Excel\",\n      \"Importing and transforming data\",\n      \"Loading data into Excel and the Data Model\",\n      \"Appending queries\",\n      \"Unpivoting data\",\n      \"Finance data preparation\"\n    ],\n    \"offers\": {\n      \"@type\": \"Offer\",\n      \"url\": \"https:\/\/eduyush.com\/products\/data-analytics-with-power-query\",\n      \"availability\": \"https:\/\/schema.org\/InStock\",\n      \"category\": \"Professional CPE course\"\n    }\n  }\n  \u003c\/script\u003e \u003cscript type=\"application\/ld+json\"\u003e\n  {\n    \"@context\": \"https:\/\/schema.org\",\n    \"@type\": \"Product\",\n    \"name\": \"Introduction to Data Analytics with Power Query (Get and Transform)\",\n    \"sku\": \"BLI509919\",\n    \"brand\": {\n      \"@type\": \"Brand\",\n      \"name\": \"AICPA \u0026 CIMA\"\n    },\n    \"description\": \"Online AICPA \u0026 CIMA Power Query course for accountants and finance professionals. Includes 4 CPE credits and 1-year availability.\",\n    \"offers\": {\n      \"@type\": \"Offer\",\n      \"url\": \"https:\/\/eduyush.com\/products\/data-analytics-with-power-query\",\n      \"availability\": \"https:\/\/schema.org\/InStock\"\n    }\n  }\n  \u003c\/script\u003e \u003cscript type=\"application\/ld+json\"\u003e\n  {\n    \"@context\": \"https:\/\/schema.org\",\n    \"@type\": \"FAQPage\",\n    \"mainEntity\": [\n      {\n        \"@type\": \"Question\",\n        \"name\": \"What is the official title of this Power Query course?\",\n        \"acceptedAnswer\": {\n          \"@type\": \"Answer\",\n          \"text\": \"The official AICPA \u0026 CIMA title is Introduction to Data Analytics with Power Query (Get and Transform). The product number or SKU is BLI509919.\"\n        }\n      },\n      {\n        \"@type\": \"Question\",\n        \"name\": \"How many CPE credits does the course provide?\",\n        \"acceptedAnswer\": {\n          \"@type\": \"Answer\",\n          \"text\": \"The official AICPA \u0026 CIMA listing shows 4 CPE credits. The NASBA field of study shown on the course page is Information Technology.\"\n        }\n      },\n      {\n        \"@type\": \"Question\",\n        \"name\": \"Does this Power Query course include a digital badge?\",\n        \"acceptedAnswer\": {\n          \"@type\": \"Answer\",\n          \"text\": \"The official AICPA product page for SKU BLI509919 does not state a digital badge. Learners who need a badge should compare the AICPA data analytics certificate products before purchasing.\"\n        }\n      },\n      {\n        \"@type\": \"Question\",\n        \"name\": \"Is Power Query useful for accountants?\",\n        \"acceptedAnswer\": {\n          \"@type\": \"Answer\",\n          \"text\": \"Yes. Power Query is useful for accountants because many finance tasks involve importing, cleaning, combining and refreshing data for reports, reconciliations and analysis.\"\n        }\n      }\n    ]\n  }\n  \u003c\/script\u003e\n\u003c\/div\u003e","brand":"AICPA","offers":[{"title":"Default Title","offer_id":47299254386924,"sku":"BLI509919","price":52.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0250\/2072\/7343\/files\/PQ.webp?v=1773879966","url":"https:\/\/eduyush.com\/en-us\/products\/data-analytics-with-power-query","provider":"Eduyush","version":"1.0","type":"link"}