Oracle Tutoring, Campbell River, BC
(250) 203-6544 (text) or (250) 830-0295 (talk)
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 …
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 »
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 »