| An
overview of Excel
Navigate
in Excel
Select,
enter data
Save
a workbook
Obtain
help |
|
Format
worksheet tabs
Reposition
worksheets in a workbook
Insert
and delete worksheets
Copy
and paste worksheets
Copy a
workbook |
| Move
and copy data between cells
Fill
cells with series of data
Edit
cell data
Insert
and delete cells, columns and rows
Find,
replace and go to cell data
Spell
check a worksheet
|
|
Set
a print title
Create
a header and footer
Set
page margins
Change
page orientation
Insert
and remove page breaks
Print
a range |
| Create
basic formulas
Calculate
with functions
Copy
formulas and functions
Create
an absolute reference |
Change
font size and type
Add
borders sand colour to cells
Change
column width and row height
Merge
cells
Apply
number formats
Apply
an Autoformat and styles |
Split
a worksheet
Arrange
worksheets
Freeze
and unfreeze rows and columns
Hide
and unhide worksheets |