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 »

Tagged with:

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 …

Excel: how to type a forward slash, Excel 2016 Read more »

Tagged with:

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 …

Excel: Conditional Formatting, part II Read more »

Tagged with: ,

Tutoring financial math, loan payments are calculated. The tutor mentions how Excel handles payments at period beginning, as opposed to period end. In my post of October 5, I show how to find the monthly payment of a loan using …

Excel: finding loan payment at the beginning of the month Read more »

Tagged with: ,

Tutoring financial math, spreadsheets might be used. The tutor shows how to find the monthly payment on a loan using Excel. In yesterday’s post I tell how to find the amount against the principal that a certain payment removes, using …

Spreadsheets: Excel: finding the monthly loan payment Read more »

Tagged with: ,