excelisfun | Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851 @excelisfun | Uploaded 7 months ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1851.xlsx
Celebrate Mike Girvins excelisfun 16 Years at YouTube Birthday Party!!! Learn Power Query M Code tricks too.
Topics:
1. (00:00) Introduction
2. (00:01) Thanks you for 16 years!!!!
3. (00:25) Alphanumeric Min and Max. List.Min on Text items, Words!?!?! Yes!
4. (01:37) Group By Can Insensitive!?!? Yes!!! With Table.GroupBy function
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #powerquery, #mcode
Comparer.Ordinal, Comparer.OrdinalIgnoreCase

Microsoft 365 Excel Complete Class: free from excelisfun at YouTube - 365 MECS 00

Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions

GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863

Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819

Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18

Text Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 06

Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818

TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789

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

Create Sequence of Time Values in Excel for Stock Market Price Data Excel Magic Trick 1798

VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786

Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851 @excelisfun