Oracle Tutoring, Campbell River, BC
(250) 203-6544 (text) or (250) 830-0295 (talk)
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 »
Tutoring financial math, amortization arises. The tutor mentions the Excel function for it. Example: For a 25-year loan of $100,000 at 4%, compounded monthly with monthly payments, what is the amount against the principal of the 101st payment? Solution: Using …
Tutoring differential equations or complex variables, you might use a spreadsheet sometimes. The tutor gives a hint about entering complex numbers on Excel. Excel does, indeed, handle complex numbers. Formulas for them are among the Engineering ones. Apparently, to enter …