Spreadsheets

Spreadsheets Index

Errors and spreadsheets

Spreadsheet basics

Common spreadsheet applications

MS-Excel window

Workbooks and worksheets

Rows, columns, and cells

Cell references

Cell ranges

Cell Contents

Text (digits) or number?

Formulas

Values

Variables and Externalized Variables

Dates

Functions

Operators

Order of precedence (evaluation)

Conditional statements and the IF() function

User interface

Selecting a cell

Selecting, copying, and filling

Eliminating AutoComplete annoyance

Keyboard shortcuts

Slash Commands

MS-Excel Views

Normal view

Formula view

Split Window

Freeze Panes

Color worksheet tabs

Custom Views

Open workbooks in their own program windows

Tile workbooks opened in their own program windows

Hiding rows and columns

Data-entry

Cell selection after data entry

Form-style data-entry

Restricting data-entry to a range of cells

Filling entire range with same value, formula, or text

Locking Cells

Eliminating AutoComplete annoyance

Documentation

Workbook documentation

Worksheet documentation

Worksheet Layout

How to arrange data

2-D and 3-D data representation

Representing data in 2 and 3-dimensions

Formatting

Currency symbols (dollar signs)/a>

Decimal point alignment

Text alignment

Text indentation

Date formats

Graphs and charts

Using graphs and charts

Graph types

Line graphs

Column and bar graphs

Pie graphs

Scatter graphs

Printing

Print Area

Tips and Traps

Tips and Traps

Feckless Features

Data Bars

Spreadsheet Errors

Avoiding spreadsheet errors

Cool arcane stuff

Lotus 1-2-3 slash commands

Copy worksheets between workbooks

Saving a workspace

Scroll worksheet without changing active cell

Chasing flies

Works Cited




Bruce Miller, 2000, 2005, 2016

Index to xx articles

Index to all articles

Hermit Home Page