REPT Function in Excel: Repeat Text (In-Cell Bar Charts)
REPT repeats text a number of times — best known for quick bar charts inside cells.
Read article →WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday = 7, the easiest for weekend…
Read article →DATE Function in Excel: Build a Date From Year, Month and Day
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 →WEEKNUM Function in Excel: Week Number of the Year
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 →TEXT Function in Excel: Format Numbers and Dates as Text
TEXT Function in Excel: Format Numbers and Dates as Text
TEXT converts a number or date into text using a format code — needed when you join values into labels.
Read article →CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT Function in Excel: Join Text From Cells and Ranges
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 →GROWTH Function in Excel: Extend an Exponential Trend
GROWTH Function in Excel: Extend an Exponential Trend
GROWTH is TREND for things that grow by a percentage — sign-ups, compounding balances — rather than by a fixed amount.
Read article →TREND Function in Excel: Extend a Straight-Line Trend
TREND Function in Excel: Extend a Straight-Line Trend
TREND fits a straight line and returns values on it, for existing points or new ones. In Excel 365 it spills several forecasts at…
Read article →Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Build a complete loan schedule in Excel: EMI with PMT, month-by-month interest and principal with IPMT/PPMT or simple formulas, prepayments, and total interest —…
Read article →RSQ Function in Excel: How Well a Line Fits
RSQ Function in Excel: How Well a Line Fits
RSQ returns R², between 0 and 1. Near 1 means a straight line explains the data well; near 0 means your trend forecast is…
Read article →Power BI Desktop: Build Your First Report From an Excel File
Power BI Desktop: Build Your First Report From an Excel File
A beginner walkthrough of Power BI Desktop: import an Excel sheet, clean it in Power Query, add measures, build four visuals with slicers, and…
Read article →INTERCEPT Function in Excel: Where the Trend Line Starts
INTERCEPT Function in Excel: Where the Trend Line Starts
INTERCEPT gives the y-value of the trend line when x is 0. With SLOPE you have the full equation y = intercept + slope…
Read article →