Microsoft Excel Tutorial 1: Columns Widths, Alignments, Formulas and Calculations
Channel: prelearn
Date: 2016-02-04

All information shown here is also applicable to LibreOffice and OpenOffice.

In this video we will build our first formula.
Change column widths
A. Drag right edge, or
B. Double click right edge

Align content in cells
A. Select column(s), or
B. Select row(s), or
C. Select region

Then click on desired alignment

Formulas in Excel:
A. Always start with an =
B. Only contain cell addresses

ie:
=B2*C2
=D2-E2
not
=15*55

Transfer formula to remaining cells:
1. Steer mouse to lower right corner of cell containing formula
2. Mouse pointer changes to black cross
3. Keep mouse key pressed and drag to remaining cells

Thus you will auto fill your formula to remaining cells.