Excel Is Fun

Excel Magic Trick 1330

October 6, 2017 0

DESCRIPTION See how to use the Power Query Function Excel.CurrentWorkbook function to get all Tables in an Excel Workbook into a Single Table (How To Append All Tables in Current Workbook): (00:20) Introduction to Excel.CurrentWorkbook […]

Excel Is Fun

Excel Magic Trick 1329

October 5, 2017 0

DESCRIPTION See how to Clean a data set and then add with two criteria using SUMIFS function and Wildcards with the criteria or Power Query and Group By feature: (00:14) Introduction (01:44) SUMIFS function and […]

Excel Is Fun

Excel Magic Trick 1328

October 4, 2017 0

DESCRIPTION See how to: (00:17) Introduction to Formulas for Counting and Adding with Case Sensitive Criteria (00:55) Power Query (Get & Transform) and Converting Proper Data Set to an Excel Table (01:38) Excel Filtering is […]

Excel Is Fun

Excel Magic Trick 1327

October 3, 2017 0

DESCRIPTION See how to create a Formula to Count Words in a Column with Mixed Data: Not COUNTA, but with COUNTIFS with the criteria “*?” (Count Text with One or More Characters) and NOT a […]

Excel Is Fun

Excel Magic Trick 1326

October 2, 2017 0

DESCRIPTION See how to Conditionally Format Text Modes with: PivotTable, Array Formula or Power Query: (00:17) Introduction (01:52) PivotTable & MATCH formula. (08:23) Array Formula with the functions: MATCH, IF, ISTEXT, MODE.MULT, N, N(IF,1 formula […]

Excel Is Fun

Excel Magic Trick 1325

September 29, 2017 0

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array […]

Excel Is Fun

Excel Magic Trick 1324

September 28, 2017 0

DESCRIPTION See how to extract records with a formula: (00:17) Problem Introduction (01:23) Use ROWS as the Number Incrementor in a Data Extraction Formula when the criteria does not change as the formula is copied. […]

Excel Is Fun

Excel Magic Trick 1323

September 27, 2017 0

DESCRIPTION See how to use the CALCULATE function and a Table from the Many Side of a One-To-Many Relationship to allow criteria (filter) to flow from the Many Side to an aggregate calculation on the […]

Excel Is Fun

Excel Magic Trick 1322

September 26, 2017 0

DESCRIPTION See how to use Excel, DAX, Power Query or SQL to Calculate Average GPA with one condition when the formulas need to ework backwards across a One To Many Relationship between Two Tables: (00:16) […]

Excel Is Fun

Excel Magic Trick 1321

September 25, 2017 0

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER […]