Category: spreadsheets

Spreadsheets: Excel: how to write text across multiple columns

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

Tagged with:

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:

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:

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

Tagged with: ,

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

Tagged with: ,

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: 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

Tagged with: ,

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

Tagged with: ,

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

Tagged with: ,

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:
Top