|
|
Open an Excel workbook & navigate between different
sheets |
|
|
Use keyboard and mouse to quickly move through a
worksheet |
|
|
Enter text or values into worksheet cells |
|
|
Select cells, columns or rows using keyboard or
mouse |
|
|
Edit (correct or change) cells |
|
|
Quickly create formulas to add, multiply, divide or
subtract |
|
|
Use the most popular functions (autosum, average) |
|
|
Insert/delete columns or rows |
|
|
Insert/delete worksheet pages; rename them; reorder
them; copy/move |
|
|
Format values and labels to improve appearance |
|
|
Print a worksheet |
|
|
Copy or move a cell entry to a new location |
|
|
Use the Autofill feature to quickly create a list
of months, days, dates, etc. |
|
|
Page layout: change page margins; center the
worksheet on the page; change the page orientation; create and edit
headers and footers |
|
|
Center text over a number of columns |
|
|
Basic charts; jazzing up charts with drawing
toolbar |
|
|
Database management, sorting, filtering, subtotals,
Pivot tables |
|
|
Calculate %, applied, % of whole, calculated |
|
|
Mail merge data from Excel or Word |