## Excel: get the set of unique values in a cell range

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: the hazard of Delete

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 …

## 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 …

## 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 …

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