| |
1.Open Microsoft Excel application
2. Basic Technique
- Cells Selection
- Data Entry
- To insert a row
- To delete a row
- Undo
- To copy a range of cells
- To move a range of cells
- Clear cell information
3. Entering a formula
- Using formulas
- Using operators (+,-,x, ¸,etc...)
- Using reference
- Tips for entering a formula
4. Files Operation
- Saving a worksheet
- Save As...
- Save
- To close a worksheet
- Delete a worksheet
5. Printing a file
- Page Setup
- Header and Footer
- File Preview
- Turn the Grid Lines off
- Turn the Row/Column Heading off
- Auto Scaling
- Setting Manual Page Breaks
- Setting Row or Column Titles
- Setting print area
6. Useful functions
- SUM( )
- AVERAGE( )
- MAX( )
- MIN( )
- IF()
- Count()
7. Tips in editing a worksheet
- Paste insert row/column
- Drag and Drop
- Autofill
- Fill down
- Fill right
8. Address Notation
- Relative Address
- Absolute Address
9. Polishing the spreadsheet
- Changing default fonts
- Changing font size
- Changing Column Width
- Changing Row Height
- Setting Border Lines
- Setting Pattern to a Range of Cell
- Turning gridlines on/off
- Alignment(Vertical and Horizontal)
- Text Orientation
- Autoformat
10. Number Format
- Adding Currency Sign to the cells
11. Creating a master spreadsheet
- Creating a document template
- Using a document template
12. Exchange files with other applications
- Changing file format (Louts-123, or old version Excel etc)
13. Styles
- Creating Styles
- Using Styles
- Editing Styles
- Merge any Styles from other documents
14. Tool Bar
- Utility Tool Bar
- Promote and demote buttons
- Show outline symbols button(utility Tool Bar)
- Select visible cells button(utility Tool Bar
15. Data sorting
|
