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 »
Tutoring math, your curiosity naturally extends to spreadsheets. The tutor points out a neat feature of Excel. If you type =pi() in a cell, the value of π will appear. I find that 14 decimal places are available. Source: www.math.com …
Using Excel can mean self-tutoring. The tutor shares an observation about typing the forward slash in Excel 2016. I went to type a forward slash (as a character, not part of a formula) at the lead of a statement in …
Tutoring spreadsheets, you might get asked about add-ins. The tutor mentions the Excel Analysis ToolPak add-in. As I understand, Excel add-ins are extra tools that are available with Excel but not installed unless requested. I installed the Analysis ToolPak add-in …
Tutoring computer use, you might talk about conditional formatting with Excel. The tutor mentions a quick example. You can make up your own condition that causes cells to format specifically. It might be done, more or less, like so: Let’s …
Home computer use can mean self-tutoring. The tutor shares an idea about cell formatting in Excel. Yesterday, using Excel 2016, I began a new spreadsheet and discovered a formula wouldn’t calculate. When I entered, for instance, =6+7, it wouldn’t evaluate …