Excel Is Fun

Excel Magic Trick 1241

DESCRIPTION Keyboard To Copy Formula Next To Data Set Down A Column Learn how to use Keyboard Copy Formula Down When Formula Is Not Directly Next To Data Set. Keyboard: 1. Ctrl + C 2. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1240

DESCRIPTION Double Click To Copy Formula Down When Formula Is Not Next To Data Set Learn how to Double Click To Copy Formula Down When Formula Is Not Next To Data Set by highlighting empty [Read More >>>]

Excel Is Fun

Excel Magic Trick 1239

DESCRIPTION Formula To Indicate a Date is in Leap Year Learn how to create a Logical Formula that will deliver a TRUE or FALSE To Indicate a Date is in Leap Year. See the functions: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1238

DESCRIPTION Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples Learn how to check whether the content of multiple cells is the same for each cell: (00:11) Problem Introduction (00:40) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1237

DESCRIPTION Add with “Contains Criteria” or Partial Text Criteria: SUMIFS & Wildcard Learn how to add with “Contains Criteria” or Partial Text Criteria using the: SUMIFS function and the Wildcard, Asterisk, which stands for zero [Read More >>>]

Excel Is Fun

Excel Magic Trick 1236

DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1235

DESCRIPTION 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP Learn how to do a two way lookup to retrieve the conversion rate for currencies: (00:11) Two-Way Lookup for Currency Conversion Problem [Read More >>>]

Excel Is Fun

Excel Magic Trick 1234

DESCRIPTION VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range Learn how to use a helper column formula to lookup a discount rate in 36 different tables: (00:11) Introduction to problem we [Read More >>>]

Excel Is Fun

Excel Magic Trick 1233

DESCRIPTION VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function Learn how to do a VLOOKUP to 36 Different Dynamic Tables (will have records added and removed over time) using the Excel Table [Read More >>>]

Excel Is Fun

Excel Magic Trick 1232

DESCRIPTION VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1 Learn how to use Power Query transform 36 Lookup Tables Into 1 Lookup Table for VLOOKUP Formula. (00:10) Introduction to problem we [Read More >>>]