Insert Basic Formula
Microsoft Excel Beginner Skills
Collapse
Expand
-
Get Started using Microsoft Excel
- Create a new blank workbook
- Use the Undo tool
- Open an existing workbook
- Use AutoComplete to insert text
- Insert a date correctly
- Change the contents of a cell
- Change the width of a column
- Change the width of several columns
- Change the height of a row
- Change the height of several rows
-
Use Font Formatting Tools
- Use the Bold tool
- Change the font size
- Change the font colour
- Change the fill colour
- Apply borders
- Change cell alignment
- Change the Ribbon Layout
-
Change Sheet Settings
- Change all column widths
- Change all row heights
- Insert / delete a sheet
- Rename a sheet
- Move a sheet
-
Use Useful Tools to Work with Cells
- Delete a row
- Apply number formatting
- Copy and paste
- Cut and paste
- Insert a row
- Use the Format Painter tool
-
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
- Use the AutoSum tool to add a list of numbers
-
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
- Use the Fill Handle to fill months
- Use the Fill Handle to fill dates