Excel Is Fun

Excel Magic Trick 1347

DESCRIPTION See how to create a Power Query (Get & Transform) Custom Function with a parameter in order to create five Sub Tables, one for each product, each on a new sheet, from a Master [Read More >>>]

Excel Is Fun

Excel Magic Trick 1346

DESCRIPTION See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: (00:17) Introduction. Look at Dynamic End Result Solution. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1345

DESCRIPTION See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods: (00:11) Introduction to Using Logical Formulas to Apply Conditional [Read More >>>]

Excel Is Fun

Excel Magic Trick 1344

DESCRIPTION See how to use a formula to apply Conditional Formatting to apply formatting to an entire row based on a condition in an Excel Table. This video shows the Excel Table Feature which allows [Read More >>>]

Excel Is Fun

Excel Magic Trick 1343

DESCRIPTION See Three methods for creating Chart Labels that have two lines: (00:10) Introduction (00:48) Basics of Text Formula and Join Operator, Ampersand. (01:35) Access Select Data dialog box to edit references in an Excel [Read More >>>]

Excel Is Fun

Excel Magic Trick 1342

DESCRIPTION See how to add a column of numbers that contains errors using SUMIF and the AGGREGATE function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1341

DESCRIPTION See how to use Power Query, a PivotTable and an Excel Formulas to calculate to calculating Average and Standard Deviation with Criteria: (00:14) Introduction & Setup (01:28) Array Formula for calculating Average and Standard [Read More >>>]

Excel Is Fun

Excel Magic Trick 1340

DESCRIPTION See how to create expandable range in an Excel Table as part of a COUNTIFS formula that calculates a running count of names as there are entered into the table: (00:12) Introduction (00:35) Example [Read More >>>]

Excel Is Fun

Excel Magic Trick 1339

DESCRIPTION See how to use a Formula, Power Query, or Custom List to create the Alphabet A – Z: (00:14) Introduction (00:26) What are ASCII Characters? (00:26) Formula with ROWS and CHAR functions, and ASCII [Read More >>>]

Excel Is Fun

Excel Magic Trick 1338

DESCRIPTION See 2 Examples of how to use Power Query to Convert 12 Individual Cross Tabulated Tables into One Proper Data Set: (00:15) Introduction (01:14) Example 1: Start with 12 Cross Tabulated Excel Tables (Tables [Read More >>>]