Insert Basic Formula
Microsoft Excel Beginners Plus – 365
Collapse
Expand
-
Select Cells Effectively
- Introduction
- Select a cell
- Select a range of cells
- Select multiple columns
- Select multiple rows
- Select all cells
-
Setup a Spreadsheet
- Change orientation
- Change column widths
- Change row heights
- Rename a sheet
- Move a sheet
- Change sheet tab colour
-
Use Tools to Work with Cells
- Use horizontal and vertical alignment tools
- Apply number formatting
- Use the Format Painter tool
- Copy and paste a cell
- Copy and paste a range of cells
- Cut and paste a cell
- Cut and paste a range of cells
- Use the mouse pointer to move cells
- Insert and delete rows
- Insert and delete columns
-
Insert Basic Formula
- Insert a formula to add 2 cells
- Insert a formula to subtract a cell from another cell
- Insert a formula to multiply a cell by another cell
- Multiply a cell by a percentage
- Use the Sum tool to add a range of cells
-
Use the Fill Handle
- Use the Fill Handle to copy a cell
- Use the Fill Handle to copy a formula
- Use the Fill Handle to fill days of the week or months