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 →CONVERT changes units: km to miles, °C to °F, kg to pounds, hours to minutes. Unit codes are case-sensitive.
Read article →Choose exactly the members you need with the Member Selection dialog: hierarchy browsing, search, filters by level and generation, aliases vs member names, and saving selections.
Read article →Navigate cube data with the core ad hoc actions: zoom in and out, pivot dimensions between rows and columns, keep only and remove only, change POV members, and double-click shortcuts.
Read article →ODD rounds away from zero to the next odd integer — for example committee sizes that must avoid tied votes.
Read article →A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before anything moves.
Read article →GCD returns the largest number that divides all inputs — for simplifying ratios and finding pack sizes.
Read article →EVEN rounds away from zero to the next even integer — handy when items come in pairs.
Read article →DAYS returns the number of days between two dates. Subtracting the dates (=B2-A2) gives the same answer.
Read article →LCM finds the smallest number all inputs divide into — when two repeating schedules line up again.
Read article →YEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.
Read article →WORKDAY returns the date that is a number of working days before or after a start date, skipping weekends and holidays.
Read article →NETWORKDAYS counts Monday–Friday working days between two dates, optionally excluding a holiday list. NETWORKDAYS.INTL lets you choose the weekend.
Read article →