WEEKNUM Function in Excel: Week Number of the Year
WEEKNUM returns the week of the year. ISOWEEKNUM follows the ISO standard (weeks start Monday, week 1 contains the first Thursday).
Read article →Excel, SAP, Oracle & automation tips — plus wacky facts
WEEKNUM returns the week of the year. ISOWEEKNUM follows the ISO standard (weeks start Monday, week 1 contains the first Thursday).
Read article →TEXT converts a number or date into text using a format code — needed when you join values into labels.
Read article →StatisticsLevel: ExpertAvailable in: Excel 2007+FISHERINV reverses FISHER, turning z back into a correlation.Syntax=FISHERINV(y)ArgumentWhat it.
Read article →CONCAT joins text from several cells or whole ranges. It replaces the older CONCATENATE. The & operator does the same for a few cells.
Read article →FISHER transforms a correlation coefficient so it is roughly normal, which lets you build confidence intervals and compare correlations.
Read article →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 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 →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 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 →Bring it together: an Invoice class with validated lines, GST calculation, item summaries with a Map and formatted output, plus next steps (Maven, Apache…
Read article →Handle errors with try/catch/finally, throw meaningful exceptions, and read and write text files with java.nio.file.Files.
Read article →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 →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.