Excellent		0 Reviews
Good		0 Reviews
medium		0 Reviews
Acceptable		0 Reviews
Not Good		0 Reviews

VLOOKUP MAP LAMBDA functions to spill a Two Way Lookup Formula Excel Magic Trick 1760

LET Function for Dynamic Reporting in Single Cell Excel Magic Trick 1673

Single Cell Spilled Reports with Dynamic Total Row Formatting Excel Magic Trick 1703

LAMBDA Excel Function LET LAMBDA together to make Single Cell Reports Excel Magic Trick 1706

LET Function Advanced Array Formula for Dynamic Cross Tabulated Report Excel Magic Trick 1681

Sorted Frequency Distribution with the LET Function Excel Magic Trick 1675

FREQUENCY Array Function for Quantitative Data LET function to create full report EMT 1693

Single Cell Yearly Sales Report Formula 4 Examples New LET Function Excel Magic Trick 1652

Excel Dynamic Arrays Cross Tabulated Report Totals Top Left MMULT Array Function EMT 1526

Excel Dynamic Arrays Fully Dynamic Cross Tabulated Reports With Totals EMT 1528

Excel Dynamic Arrays Fully Dynamic Cross Tabulated Reports Unbelievable EMT 1520

Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports EMT 1518

7 LAMBDA Helper Functions MAP SCAN BYCOL BYROW REDUCE ISOMITTED MAKEARRAY EMT 1749

Spilled Array Formulas Make Excel Life Easy Compare Two Lists Extract Items Excel Magic Trick 1750

VLOOKUP MAP LAMBDA functions to spill a Two Way Lookup Formula Excel Magic Trick 1760

INDEX XMATCH functions to spill a Two Way Lookup Formula Excel Magic Trick 1760 Part 2

Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS LAMBDA Excel Magic Trick 1763

Excel PivotTable or Formula to Count Unique Dates for Each New Item 4 Examples EMT 1767

Mode for Categorical Data LET Function to Dynamically List all Modes with Category Labels EMT 1770

FILTER LET TRANSPOSE and Other Excel Functions Mode Calculation for each Quartile EMT 1771

HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row Excel Magic Trick 1780

HSTACK and VSTACK Functions Create Cross Tabulated Report With Total Rows Excel Magic Trick 1781

14 New Excel Worksheet Functions That Will Blow Your Mind Excel Magic Trick 1782

Combine All Tables in Excel Workbook VSTACK or Excel CurrentWorkbook Function EMT 1783

WRAPCOL SORTBY Array Functions to Pivot A Table Robustify your formulas Excel Magic Trick 1784

TOCOL DROP EXPAND Array Functions to UnPivot Data into Proper Table Excel Magic Trick 1785

VSTACK 3 D References Combine Worksheet Data into One Table Excel Magic Trick 1786

Single Cell Excel Reporting with LET LAMBDA VSTACK SUMIFS More Complete Lesson EMT 1787

DROP TAKE VSTACK How They Are Useful Spilled Frequency Distribution with Total Row EMT 1788

Unique List of Case Sensitive Items Expandable Range in Spilled Array Formula EMT 1792

UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula EMT 1805

GROUPBY Excel Worksheet Function Single Cell Reports Made Easy 11 Examples EMT 1844

2 Different Functions in GROUPBY PIVOTBY Functions Excel Magic Trick 1844 Part 2

Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports EMT 1845

ETA LAMBDAs for BYROW BYCOL SCAN to Make Spilling Row Totals Running Totals Easy EMT 1846

Append Tables in Excel Excel Magic Trick 1852

Formula for Sales Rep by Month Report The Amazing GROUPBY Function Excel Magic Trick 1853

PIVOTBY GROUPBY to Create Year by Month Sales Report Grouping Trick Excel Magic Trick 1859

Grouping in GROUPBY PIVOTBY Functions Yes Frequency Distribution with GROUPBY EMT 1858

GROUPBY Function to Group Transactions with No Transaction Number EMT 1855

Excel Power Query

Excel VBA

Excel Dashboard

Excel Course Basic to Advanced

Excel Functions

Excel Charting

Microsoft Access

Microsoft PowerPoint

Microsoft Word

Microsoft Excel

Digital Media Literacy

Google Classroom

Google Slides

Google Sheets Full data

Google Docs

Google Drive