SKEW.P Function in Excel: Skewness of a Population
SKEW.P measures lopsidedness of a complete data set; SKEW is the sample version.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
SKEW Function in Excel: Is the Data Lopsided?
SKEW Function in Excel: Is the Data Lopsided?
SKEW is positive when a long tail stretches to the right — typical for salaries and order values, where a few big ones pull…
Read article →COVARIANCE.S Function in Excel: Do Two Series Move Together?
COVARIANCE.S Function in Excel: Do Two Series Move Together?
COVARIANCE.S measures whether two variables rise and fall together. Its size depends on units, so CORREL is easier to read.
Read article →MAXA Function in Excel: Largest Value, Logicals Included
MAXA Function in Excel: Largest Value, Logicals Included
StatisticsLevel: IntermediateAvailable in: Excel 2007+MAXA is MAX that counts TRUE as 1 and text as 0.Syntax=MAXA(value1, [value2], ...)ArgumentWhat it.
Read article →AVERAGEA Function in Excel: Average Counting Text as Zero
AVERAGEA Function in Excel: Average Counting Text as Zero
AVERAGEA treats text as 0 and TRUE as 1. Use it when “absent” should drag the average down rather than be ignored.
Read article →INFO Function in Excel: About Your Excel Environment
INFO Function in Excel: About Your Excel Environment
INFO returns details like the Excel version, operating system or current folder.
Read article →SUMPRODUCT: The Excel Formula That Does (Almost) Everything
SUMPRODUCT: The Excel Formula That Does (Almost) Everything
SUMPRODUCT multiplies arrays and adds the result — which makes it a multi-condition counter, a weighted average, a case-sensitive lookup and more, in every…
Read article →SHEETS Function in Excel: How Many Sheets?
SHEETS Function in Excel: How Many Sheets?
SHEETS counts sheets in a reference or the whole workbook — including hidden ones.
Read article →RTD Function in Excel: Real-Time Data From a COM Server
RTD Function in Excel: Real-Time Data From a COM Server
RTD pulls live values from a real-time data server, e.g. stock prices from a broker's trading terminal add-in. You need the provider's RTD server…
Read article →REGISTER.ID Function in Excel: ID of a Registered DLL Function
REGISTER.ID Function in Excel: ID of a Registered DLL Function
REGISTER.ID returns the register ID of a DLL function for CALL. Same legacy, same security restrictions.
Read article →WEBSERVICE Function in Excel: Read Data From a URL
WEBSERVICE Function in Excel: Read Data From a URL
WEBSERVICE downloads text from a web address (Windows desktop only). Combined with FILTERXML or TEXTAFTER it can read simple APIs.
Read article →SWITCH Function in Excel: Match One Value Against a List
SWITCH Function in Excel: Match One Value Against a List
SWITCH compares one value with a list and returns the matching result — cleaner than nested IFs for exact matches.
Read article →