AAA Excel’s Power

PP08: Time intelligence functions “PART III” - Running Total - "DATESMTD - DATESQTD - DATESYTD"

Excel Dynamic Array Functions - Video#14: Dynamic Array + Pivot Table (VSTACK x 2)

APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table

Excel Dynamic Array Functions Video #2: Unique & Sort Functions with 8 practical examples

PP01: Introduction to Power Pivot. What is it? Why you should use? and how to activate? Incl Example

PQB11: PowerQueryBasics: Merge Queries - Left Outer (Replace V-Lookup): Solve duplicate issues

PQB14: Power Query Basics - Excel.CurrentWorkbook() to extract data & Group by to Summarize data

PP07: Time intelligence functions “PART II” shift dates backward using DAX (DATEADD function)

PT04: Excel Pivot Tables Calculated Fields & Items Insert formula inside the Pivot Table

APQ01: Advanced Power Query Video #1 - Custom Functions

PQB02: Power Query Basics-Extract data from current workbook, and creat dynamic unique list

أسرع طريقة لتجميع أكثر من اكسيل شيت داخل مجموعة ملفات اكسيل داخل مجلد | دوال متخصصة | باور كويري

تمارين باور كويري: التحدي السادس -إضافة عمود ديناميكي لتحديد أقل سعر- دوال السجلات (الصفوف) (PQC06)

APQ05: Advanced Power Query Video #5 - M-CODE - Compare 3 Tables - List Functions

APQ00: Advanced Power Query - “M Language” STEP BY STEP - Beginners Guide (PART I)

تمارين باور كويري | حل التحدي التاسع | الفلتر المرن | Flex Filter | (PQC09)

ترجمة فورية باستخدام اكسيل | دالة جديدة من دوال أوفيس 365 | Translate

Replace VLOOKUP With Power Query: learn Merge, Append & Group By techniques

APQ07:Deal with Errors - IFERROR in POWER QUERY (try..otherwise and if..then..else)

Video#7:Power Query basics: get, transform, and load data from Table/Range

Excel Dynamic array Video#8:Get top N values, dynamic range & draw dynamic chart - Filter Function

PP04: Power Pivot Tutorial - 3 ways to create CALENDAR TABLES, Why Calendar Table in a Data Model?

APQ0.1:Advanced Power Query (List-Record-Table) “M language” STEP BY STEP - Beginners Guide (PARTII)

PQB16: Power Query Basics - Manage Queries: Duplicate, Reference or Append

Excel Dynamic Array Functions Video #1: Spill Concept, Sequence & Randarray formulas

APQ09: Advanced Power Query | Exact match lookup in Power Query | No Merge Queries

Excel Dynamic Array Functions - Video #9: Sort Vs SortBy - Sort on more than one column

APQ02: Advanced Power Query Video #2 - Parameters in PQ

Excel Dynamic Array Video#7: FILTER function - Search text in 3 modes: Exact, Contains & Starts with

PQ Solution:Filter by list UI:Merge-Fuzzy Matching&M Functions:Table.SelectRows+List.Contians(PQC03)

Excel Dynamic Array Functions-Office 365-Video #3: Sales report, Unique & Sort with Sumifs & Index

Filter Excel Tables and Charts with Slicers and Create Excel Interactive Dashboards

APQ04: Advanced Power Query Video #4 - M-CODE - Combine Inconsistent Tables

PowerQuery Solution: Running Total 3 ways!! List.FirstN,Table.SelectRows & Custom Functions (PQC02)

Power Query Solution: Dynamic Column for Lowest Price - Record’s Functions & User Interface (PQC06)

Power Query Solution: Find start & end date for each price - Dates Calculation (PQC05)

Excel Dynamic Array Video#4: Pivot table with total row, FILTER, UNIQUE, SORT, SORT & SUMIFS

توزيع الموازنة باستخدام باور كويري | سلسلة باور كويري المتقدمة | APQ10 | Group By All Rows

APQ03: Advanced Power Query Video #3 - M-CODE - TABLE FUNCTIONS: transform data in multiple sheets

PP02: Power Pivot tutorial - Data extraction & modeling

Excel Dynamic Array Functions Video#6: FILTER function easy Explained, 4 concepts in 5 examples

Power Query Challenge: FILTER BY A LIST OF VALUES (ignOre caSe seNsiTiviTy) (PQC03)

Highlight top 3 values on a column chart - LARGE function

PP03: DAX Iterator Functions, Measures vs Added Columns, Filter Context, Internal & external filters