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…
Oracle Tutoring, Campbell River, BC
(250) 203-6544 (text) or (250) 830-0295 (talk)
Category: spreadsheets
Spreadsheets: Excel: how to write text across multiple columns
Tagged with: how to extend text across multiple columns in Excel
Spreadsheets: Excel: the pi() function
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…
Tagged with: pi() function in Excel
Excel: how to type a forward slash, Excel 2016
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…
Tagged with: how to type a forward slash as a character in Excel
Excel: Analysis ToolPak
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…
Excel: Conditional Formatting, part II
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 2016: formula not calculating
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…
Tagged with: excel: formula not calculating in a cell
Excel: finding loan payment at the beginning of the month
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…
Spreadsheets: Excel: finding the monthly loan payment
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…
Excel: payment against principal
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…
Math: Excel: entering complex numbers
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…
Tagged with: entering complex numbers on Excel
Top