Excel Is Fun

Excel Magic Trick 1480

DESCRIPTION In this video learn how to do a two-way lookup to get the correct Price based on Quantity Discount & Product Name. Learn how to use the VLOOKUP and MATCH Functions. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1479

DESCRIPTION In this video learn the Basics of VLOOKUP to looks up a price based on a Bulk Quantity Discount. Also learn about the MATCH Function to automatically pick out the correct Column Number for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1478

DESCRIPTION In this video learn how to use Conditional Formatting to format the row in a data set and how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver [Read More >>>]

Excel Is Fun

Excel Magic Trick 1477

DESCRIPTION In this video learn how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver a TRUE when the Event Key is a Duplicate AND the Task Column equals [Read More >>>]

Excel Is Fun

Excel Magic Trick 1476

DESCRIPTION In this video learn how to use the SUMIFS function to add Expenses for a specified Date Range. This is an example of using SUMIFS to add with three conditions or criteria. See how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1475

DESCRIPTION In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1474

DESCRIPTION Learn about how to create a Twinkling Christmas Tree with a Star on Top in Excel using the RAND and CHAR functions, the Conditional Formatting Scales and Conditional Formatting Icons. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1473

DESCRIPTION Learn about how to create a formula to create a product code where the middle part of the code must increment as it is copied down a column. See the Functions ROWS and TEXT. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1472

DESCRIPTION Learn about how to Topics: (00:11) Introduction (01:58) Ex 1: Between Upper & Lower Limits: =COUNTIFS Function (04:45) Ex 2: Between Upper & Lower Limits: =DCOUNT Function (07:00) Ex 3: Between Upper & Lower [Read More >>>]

Excel Is Fun

Excel Magic Trick 1471

DESCRIPTION In this video learn how to use Array Formulas to automate the reporting process for Rain Totals where the staring time for a day period changes. Topics: (00:01) Introduction and description of reporting requirements [Read More >>>]