Excel has three random functions: RAND for decimals between 0 and 1, RANDBETWEEN for whole numbers in a range, and RANDARRAY for a whole grid at once. With them you can make random decimals, dates, picks from a list and numbers that never repeat. Decimal 0 to 1=RAND() Whole number=RANDBETWEEN(1,100) A grid (365)=RANDARRAY(5,3) Watch the … Read more
Excel stores time as a fraction of a day, so 12:00 PM is 0.5. That makes time maths simple once you know the formats: subtract for the difference, use MOD for overnight shifts, multiply by 24 for decimal hours, and MROUND to round. Difference=C5-B5, formatted [h]:mm Overnight=MOD(C5-B5,1) Decimal hours=(C5-B5)*24 Watch the short video: Calculate time … Read more
Google Sheets has no built-in function to spell out numbers. You can add one in two minutes: a free add-on, or a short Apps Script custom function that writes rupees in lakh and crore. Built-in functionNone Option 1NumberText add-on Option 2Your own RUPEES function (Apps Script) Option 1: NumberText add-on The NumberText add-on by Alexander … Read more
The 5×5 rule says each slide should have no more than 5 lines, and each line no more than 5 words. It forces you to put the detail in what you say, not on the screen. Lines per slide5 or fewer Words per line5 or fewer Variant5×5×5: no more than 5 text slides in a … Read more
To put a list or table in random order, for quiz questions, a random draw or a fair rota, use =SORTBY(A2:C20,RANDARRAY(ROWS(A2:C20))) in Excel 365. In any version, a RAND helper column and a sort does the same. Excel 365SORTBY + RANDARRAY Any versionRAND column + Sort New orderPress F9 Watch the short video: Randomly sort … Read more
To get the day of the week for a date, such as Tuesday for 28-Dec-1937, use =TEXT(B3,”dddd”). Here are four ways: two formulas, a number format that shows the day without changing the date, and Power Query, plus day names in Malayalam and Hindi. Watch the short video: Excel formula to get the Day name … Read more
A linked picture is a live image of a range. When the cells change, the picture changes too. Use it to show numbers from other sheets on a dashboard, side by side, at any size. FastestPaste Special → Linked Picture Hidden toolCamera (Quick Access Toolbar) UpdatesLive, as the source cells change Why use one Here … Read more
Excel drops leading zeros from numbers, so 00125 becomes 125. To keep or add them for IDs, PIN codes or invoice numbers, use a number format, the TEXT function, REPT for text, or Power Query. Display onlyCustom format 00000 As textTEXT or REPT TypingStart with an apostrophe: ‘00125 Watch the short video: Pad Numbers with … Read more
Following are 4 different methods that can be used to Jump to the First or Last sheet of an Excel Workbook. Method 1 Holding the Ctrl key, left-click on the small right arrow present in the bottom left corner of the workbook. You will land on the last worksheet of the active workbook. Similarly, to select the … Read more
Excel can fade a picture so text or data shows through, which is useful for watermarks and dashboard backgrounds. Use the Transparency presets, or set an exact percentage in the Format Picture pane. WherePicture Format → Transparency Exact valueFormat Picture pane Works inMicrosoft 365, Excel 2021 and later Method 1: Transparency presets Select the picture … Read more