In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines
Three ways to show charts inside cells — the REPT formula trick, conditional-formatting Data Bars and Sparklines — for compact dashboards that update automatically.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Excel Shortcut of the Week: Ctrl+E Flash Fill
Excel Shortcut of the Week: Ctrl+E Flash Fill
Flash Fill (Ctrl+E) splits, joins and reformats text by example — no formulas. How to use it, five real examples, and when to use…
Read article →OCT2DEC Function in Excel: Octal to Decimal
OCT2DEC Function in Excel: Octal to Decimal
OCT2DEC converts a octal number to decimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →TINV Function in Excel: Two-Tailed t Critical Value (Older Name)
TINV Function in Excel: Two-Tailed t Critical Value (Older Name)
TINV returns the two-tailed t critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate,…
Read article →Export Tally Data to Excel and Build a Sales Dashboard
Export Tally Data to Excel and Build a Sales Dashboard
Export TallyPrime reports to Excel properly, clean the export, and build a sales dashboard: party-wise and item-wise totals, monthly trend, top customers and a…
Read article →FINV Function in Excel: F Critical Value (Older Name)
FINV Function in Excel: F Critical Value (Older Name)
FINV returns the F critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →T.INV Function in Excel: t Value for a Left-Tail Probability
T.INV Function in Excel: t Value for a Left-Tail Probability
T.INV returns the t value for a left-tail probability; T.INV.2T is the usual critical value.
Read article →F.INV.RT Function in Excel: F Critical Value
F.INV.RT Function in Excel: F Critical Value
StatisticsLevel: ExpertAvailable in: Excel 2010+F.INV.RT gives the critical F value for ANOVA at a chosen significance level.Syntax=F.INV.RT(probability.
Read article →Combine All Excel Files in a Folder with Power Query (No VBA, No Copy-Paste)
Combine All Excel Files in a Folder with Power Query (No VBA, No Copy-Paste)
Use Excel’s Power Query “From Folder” to merge every workbook or CSV in a folder into one table that refreshes with one click —…
Read article →F.DIST.RT Function in Excel: F Test p-Value (Right Tail)
F.DIST.RT Function in Excel: F Test p-Value (Right Tail)
StatisticsLevel: ExpertAvailable in: Excel 2010+F.DIST.RT turns an F statistic (from ANOVA or a variance ratio) into a p-value.Syntax=F.DIST.RT(x.
Read article →T.INV.2T Function in Excel: Critical t Value
T.INV.2T Function in Excel: Critical t Value
T.INV.2T returns the t value for a two-tailed test — the multiplier for a confidence interval on a small sample.
Read article →Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
A gentle first step from Excel to Python: load a spreadsheet with pandas, clean it, build a pivot table and save the result —…
Read article →