Excel: the t function
Self-tutoring about Excel: the tutor mentions another interesting function. In Excel, the t function seems to …
Excel
Excel: depreciation: db function
Self-tutoring about Excel: the tutor mentions another neat function from it, this time about depreciation. Let’s …
Excel: function to calculate days between two dates
Self-tutoring about Excel: the tutor mentions its days function. As I understand, =days(later_date, earlier_date) will yield …
Excel: function to calculate days between two dates Read more →
Excel: pduration function
Self-tutoring about Excel: the tutor mentions pduration. To my understanding, Excel’s pduration(the_rate, amount1, amount2) function calculates …
Excel: writing a number in a different base
Self-tutoring about Excel: the tutor mentions its base() function. Let’s imagine needing to write a number …
Excel: Roman numerals to Arabic
Self-tutoring about Excel: the tutor mentions converting from Roman numerals to Arabic. Imagine you want to …
Excel: translate to Roman numerals
Self-tutoring about Excel: the tutor mentions a fun function. Suppose you don’t know what 588 is …
Excel: get the set of unique values in a cell range
Self-tutoring about Excel: the tutor mentions a technique. If you’ve a cell range from which you …
Excel: get the set of unique values in a cell range Read more →
Excel: the hazard of Delete
Self-tutoring about Excel: the tutor makes an observation. The other day, in a mad hurry, I …
Spreadsheets: Excel: how to write text across multiple columns
Self-tutoring with Excel: the tutor shares a tip about extending text over multiple columns. Let’s imagine …
Spreadsheets: Excel: how to write text across multiple columns Read more →