ISOWEEKNUM Function in Excel: ISO Week Number
ISOWEEKNUM returns the ISO 8601 week (weeks start on Monday; week 1 holds the first Thursday). Use it when European teams or SAP reports…
Read article →CELL Function in Excel: Information About a Cell
CELL Function in Excel: Information About a Cell
CELL reports details such as address, column width, number format or file path. Its best-known use is getting the current sheet name.
Read article →Excel TEXT Function: 20 Format Codes You Will Actually Use
Excel TEXT Function: 20 Format Codes You Will Actually Use
Format numbers and dates inside formulas with TEXT: Indian lakh/crore commas, day names, month names, leading zeros, percentages and joining numbers into sentences.
Read article →Docker for Beginners: Run Any App Without Installing It
Docker for Beginners: Run Any App Without Installing It
What containers are, why “works on my machine” disappears, and your first Docker commands — run a database, a Jupyter notebook and your own…
Read article →DEC2HEX Function in Excel: Decimal to Hexadecimal
DEC2HEX Function in Excel: Decimal to Hexadecimal
DEC2HEX converts numbers to hex — the notation behind web colours and memory addresses.
Read article →BIN2DEC Function in Excel: Binary to Decimal
BIN2DEC Function in Excel: Binary to Decimal
BIN2DEC reads binary text (up to 10 digits) and returns the number.
Read article →DEC2BIN Function in Excel: Decimal to Binary
DEC2BIN Function in Excel: Decimal to Binary
DEC2BIN converts a number to binary text. Good for teaching, flags and subnet masks, but it only handles −512 to 511.
Read article →CONVERT Function in Excel: Convert Units
CONVERT Function in Excel: Convert Units
CONVERT changes units: km to miles, °C to °F, kg to pounds, hours to minutes. Unit codes are case-sensitive.
Read article →PI Function in Excel: The Value of π
PI Function in Excel: The Value of π
PI returns 3.14159265358979, accurate to 15 digits. It takes no arguments but still needs the brackets.
Read article →MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS Function in Excel: Smallest Value Meeting Conditions
MINIFS returns the minimum of values where all conditions are true.
Read article →EXP Function in Excel: e Raised to a Power
EXP Function in Excel: e Raised to a Power
EXP returns e^x and undoes LN. Use it to turn summed log returns back into an ordinary percentage.
Read article →MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →