Excel Is Fun

Excel Magic Trick 1327

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1326

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1325

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1324

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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1323

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1322

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) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1321

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 [Read More >>>]

Excel Topics

Excel 2013 Workbooks

Create A New Workbook The following guide will show you how to create a blank workbook. Click the File tab Select New from the left menu Click Blank workbook Add A New Blank Worksheet When [Read More >>>]

Excel Is Fun

Excel Magic Trick 1320

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Power Query. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1319

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Two PivotTables. WORKBOOKS