DATE Function in Excel: Build a Date From Year, Month and Day
DATE creates a real date from separate year, month and day numbers — the reliable way to put dates in formulas.
Read article →DATE creates a real date from separate year, month and day numbers — the reliable way to put dates in formulas.
Read article →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 still calculate, but Microsoft recommends STDEV.P for new work. Both give the same result.
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 POI, Spring).
Read article →Handle errors with try/catch/finally, throw meaningful exceptions, and read and write text files with java.nio.file.Files.
Read article →