Power Query Lesson 1: What Power Query Is and Your First Query
Meet Power Query in Excel: import a CSV with Get Data, the Power Query Editor, Applied Steps, setting data types (including dd-mm-yyyy dates), Close…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time error 1004 is Excel VBA’s catch-all error. Here are the 7 causes I see most often — with the exact fix for each.
Read article →GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST Function in Excel: Gamma Distribution (Older Name)
GAMMADIST returns the gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS Function in Excel: Fold a List Into Columns
WRAPCOLS takes a long list and wraps it into columns of a fixed height — printable labels, seating plans.
Read article →TTEST Function in Excel: t-Test (Older Name)
TTEST Function in Excel: t-Test (Older Name)
TTEST returns the p-value of a t-test between two samples. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS Function in Excel: Reshape a List Into a Grid
WRAPROWS reshapes a single column into rows of a fixed width — e.g. a pasted list where every 3 lines are one record.
Read article →ERF.PRECISE Function in Excel: Error Function (2010+ Version)
ERF.PRECISE Function in Excel: Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERF.PRECISE is the 2010 version of ERF with one argument.Syntax=ERF.PRECISE(x)ArgumentWhat it.
Read article →GAMMA.INV Function in Excel: Value for a Gamma Probability
GAMMA.INV Function in Excel: Value for a Gamma Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+GAMMA.INV returns the value at a given gamma probability.Syntax=GAMMA.INV(probability, alpha.
Read article →ERFC.PRECISE Function in Excel: Complementary Error Function (2010+ Version)
ERFC.PRECISE Function in Excel: Complementary Error Function (2010+ Version)
EngineeringLevel: ExpertAvailable in: Excel 2010+ERFC.PRECISE is the 2010 version of ERFC.Syntax=ERFC.PRECISE(x)ArgumentWhat it meansxValueExamplesExample.
Read article →5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
Five ways to find the last used row in Excel VBA — End(xlUp), UsedRange, Find, CurrentRegion and ListObject — with the traps each one…
Read article →BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE Function in Excel: Probability of Successes in a Range
BINOM.DIST.RANGE gives the chance of getting between s and s2 successes in n trials, e.g. 3 to 5 sales from 20 calls.
Read article →GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST Function in Excel: Gamma Distribution
GAMMA.DIST models waiting times and amounts that are always positive and skewed, like claim sizes or repair times.
Read article →