FISHER Function in Excel: Fisher Transformation of a Correlation
FISHER transforms a correlation coefficient so it is roughly normal, which lets you build confidence intervals and compare correlations.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
VARA Function in Excel: Sample Variance Counting Text and TRUE/FALSE
VARA Function in Excel: Sample Variance Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+VARA is VAR.S that counts text as 0 and TRUE as 1.Syntax=VARA(value1, [value2], ...)ArgumentWhat it.
Read article →STDEVP Function in Excel: Population Standard Deviation (Older Name)
STDEVP Function in Excel: Population Standard Deviation (Older Name)
STDEVP gives the standard deviation of a whole population. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier…
Read article →Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Calculate depreciation in Excel with SLN, DB and custom formulas: straight-line (Companies Act), written-down value, the 180-day half-rate rule, and a complete fixed-asset schedule.
Read article →VAR.S Function in Excel: Variance of a Sample
VAR.S Function in Excel: Variance of a Sample
VAR.S is the square of STDEV.S. You rarely report it directly, but it turns up in forecasting, portfolio risk and quality-control formulas.
Read article →STDEV.P Function in Excel: Standard Deviation of a Whole Population
STDEV.P Function in Excel: Standard Deviation of a Whole Population
STDEV.P measures spread when your data is the entire group, not a sample. The P version divides by n instead of n−1, so it…
Read article →QUARTILE Function in Excel: Quartiles (Older Name)
QUARTILE Function in Excel: Quartiles (Older Name)
QUARTILE returns the quartile of a data set. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →VBA Dictionary: Fast Lookups and Unique Lists in Your Macros
VBA Dictionary: Fast Lookups and Unique Lists in Your Macros
Use the Scripting.Dictionary in Excel VBA: create one, add and update keys, count and total by key, get unique lists, compare text case-insensitively, early…
Read article →QUARTILE.INC Function in Excel: Split Data Into Quarters
QUARTILE.INC Function in Excel: Split Data Into Quarters
QUARTILE.INC returns the minimum, the 25th, 50th or 75th percentile, or the maximum. It is the fastest way to see whether a salary band…
Read article →Power BI Lesson 10: Publish, Refresh and Share (Project)
Power BI Lesson 10: Publish, Refresh and Share (Project)
Finish and share the course project: build a one-page sales dashboard, publish to the Power BI service, schedule refresh with a gateway, share via…
Read article →Power BI Lesson 9: Slicers, Drill-Down, Tooltips and Bookmarks
Power BI Lesson 9: Slicers, Drill-Down, Tooltips and Bookmarks
Make reports interactive: slicers and sync across pages, cross-filtering and edit interactions, drill-down hierarchies, drill-through detail pages, report-page tooltips and bookmarks for saved views.
Read article →Power BI Lesson 8: Visuals That Communicate
Power BI Lesson 8: Visuals That Communicate
Choose and format Power BI visuals: cards and KPIs, bar vs column vs line, tables and matrices, maps, conditional formatting, consistent themes and page…
Read article →