Self-tutoring about Excel: the tutor mentions another interesting function. In Excel, the t function seems to return the contents of a cell if the cell contains text, but an empty string, aka “”, otherwise. Then, what might qualify as text? …
Self-tutoring about Excel: the tutor mentions another neat function from it, this time about depreciation. Let’s imagine one wants to calculate declining-balance depreciation for the following case: Purchase price of 10000, salvage of 1000, useful life of ten years: what …
Self-tutoring about Excel: the tutor mentions its days function. As I understand, =days(later_date, earlier_date) will yield the days between those two dates, inclusive of one. For instance, =days(“05-april-2025″,”04-april-2025”) returns 1. For another example, =days(“08-may-2025″,”11-oct-2024”) returns 209. Such is my experience, …
Excel: function to calculate days between two dates Read more »
Self-tutoring about Excel: the tutor mentions pduration. To my understanding, Excel’s pduration(the_rate, amount1, amount2) function calculates the number of periods for an investment of amount1 to be worth amount2 at the_rate per period, compounded. For instance, let’s imagine an investment …
Self-tutoring about Excel: the tutor mentions its base() function. Let’s imagine needing to write a number in a different base; for example, needing to write 1005 in base 7. Excel has a function for that: =base(1005, 7). Apparently the answer …
Self-tutoring about Excel: the tutor mentions converting from Roman numerals to Arabic. Imagine you want to know what DXCIV is in Arabic numerals. Well, one might open up Excel and key in =Arabic(“DXCIV”). (Apparently, the answer is 594.)
Self-tutoring about Excel: the tutor mentions a fun function. Suppose you don’t know what 588 is in Roman numerals. In Excel, you could just enter =Roman(588) in a cell, and receive the satisfying answer DLXXXVIII. The =Roman() function is one …
Self-tutoring about Excel: the tutor mentions a technique. If you’ve a cell range from which you want to know the unique values, you’re wise to make a copy of it first, then paste that copy some safe place, away from …
Excel: get the set of unique values in a cell range Read more »
Self-tutoring about Excel: the tutor makes an observation. The other day, in a mad hurry, I was working on a spreadsheet. As so often happens, I needed more columns between two I’d made. No problem: right click, then Insert, which …
Self-tutoring with Excel: the tutor shares a tip about extending text over multiple columns. Let’s imagine you want to title a spreadsheet. You probably want to center the title at the top: likely it will run across more than one …
Spreadsheets: Excel: how to write text across multiple columns Read more »