Excel Is Fun

Excel Magic Trick 1181

Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT DESCRIPTION See how to: (00:08) Count numbers with 4 or more characters using COUNTIFS function. See that COUNTIFS requires Comparative Operators in Double [Read More >>>]

Excel Is Fun

Excel Magic Trick 1179

Calculate Mean, Median and Mode From Data Set DESCRIPTION See how to: (00:30) Mean using AVERAGE function (02:15) Median using MEDIAN function (03:17) Mode using MODE.MULT, SMALL and IFERROR functions

Excel Is Fun

Excel Magic Trick 1178

Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA? DESCRIPTION From Survey Results, see examples of how to calculate the percentage of No responses given that the response was from a Full Time Faculty in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1177

Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter DESCRIPTION See examples of how to use CONVERT function to convert from one unit to another unit. (00:12) Flash Fill from [Read More >>>]

Excel Is Fun

Excel Magic Trick 1176

CONVERT Function to convert units in Excel DESCRIPTION See examples of how to use CONVERT function to convert from one unit to another unit. (00:11) CONVERT function (00:54) Use drop down list to select from_unit [Read More >>>]

Excel Is Fun

Excel Magic Trick 1175

Decaying Average in Standards-Based Grading in Excel DESCRIPTION See (00:10) How Decaying Average in Standards-Based Grading works (02:00) Calculating in Excel Method 1: Two formulas that use IF function and Absolute Cell References (04:02) Explaining [Read More >>>]

Excel Is Fun

Excel Magic Trick 1174

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values [Read More >>>]

Excel Is Fun

Excel Magic Trick 1173

Conditional Format Dates When they are 90 Days of Set Expiration Date DESCRIPTION See how to use Logical Formula to Conditionally Format Dates When they are 90 Days of Set Expiration Date

Excel Is Fun

Excel Magic Trick 1172

Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT DESCRIPTION See how to: (00:38) INDEX and MATCH functions to lookup a column (00:50) Highlight non-contiguous ranges using Ctrl (03:13) Enter Formula into non-contiguous ranges using [Read More >>>]

Excel Is Fun

Excel Magic Trick 1171

SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead DESCRIPTION See how to add for Text Number Criteria such as 0500 and 00500 using SUMPRODUCT rather than SUMIFS or SUMIF: (00:08) Problem [Read More >>>]